Linux系统下mysql安装及mysql workbench安装配置
系统环境:ubuntu16mysql安装下载mysql源安装包curl -LO http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm安装mysql源sudo yum localinstall mysql57-community-release-el7-11.noarch.rpm检查yum源是否...
·
系统环境:ubuntu16
mysql安装
下载mysql源安装包
curl -LO http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
安装mysql源
sudo yum localinstall mysql57-community-release-el7-11.noarch.rpm
检查yum源是否安装成功
sudo yum repolist enabled | grep "mysql.*-community.*"
mysql-connectors-community MySQL Connectors Community 21
mysql-tools-community MySQL Tools Community 38
mysql57-community MySQL 5.7 Community Server 130
安装mysql
sudo yum install mysql-community-server
安装服务
sudo systemctl enable mysqld
启动服务
sudo systemctl start mysqld
查看服务状态
sudo systemctl status mysqld
mysql默认端口3306
查看mysql端口号
sudo mysql -u root
mysql> show global variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
安装mysql workbench
sudo aptitude install -y mysql-workbench
运行mysql workbench
sudo mysql-workbench
现在sparl workbench连接mysql数据库会报错
解决方法如下:
更改mysql的root密码
mysql -u root -p
在mysql>后输入
update mysql.user set authentication_string=password('newpassword') where user='root' and host='127.0.0.1' or host='localhost';
更改mysql默认UNIX auth_socket plugin插件
sudo mysql -u root
mysql>USE mysql;
mysql>SELECT User, Host, plugin FROM mysql.user;
+------------------+-----------------------+
| User | plugin |
+------------------+-----------------------+
| root | auth_socket |
| mysql.sys | mysql_native_password |
| debian-sys-maint | mysql_native_password |
+------------------+-----------------------+
mysql> USE mysql;
mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit;
备注:过程中如果报错,注意检查自己的密码是否输入错误
更多推荐
已为社区贡献1条内容
所有评论(0)