Ubuntu18.04 安装MySQL5.7.21
1、解压文件
1)官网下载:https://dev.mysql.com/downloads/mysql/
2)选择先前版本下载
3)解压文件
sudo tar -xvf mysql-server_5.7.21-1ubuntu17.04_amd64.deb-bundle.tar -C /usr/local/mysql-5.7.21-17.04-64bit
2、安装MySQL
- 到解压路径下安装
- 安装顺序
sudo apt-get install libaio1
sudo dpkg -i mysql-common_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg -i libmysqlclient20_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg -i libmysqlclient-dev_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg -i libmysqld-dev_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-community-client_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-client_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-server_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-community-server_5.7.21-1ubuntu14.04_amd64.deb
注:须在mysql-community-server之前先装mysql-server,若报错显示未安装libmecab2,可手动安装,安装前先请除mysql-community-server
apt --fix-broken install
sudo apt-get install libmecab2
sudo dpkg -i mysql-community-source_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-community-test_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-testsuite_5.7.21-1ubuntu14.04_amd64.deb
注:若无需上述三个安装包可不装
- root密码输入
安装mysql-community-server时会跳出弹框输入root密码,以及再次输入密码。
- 安装完成
查看MySQL状态
sudo netstat -tap | grep mysql
3、常见错误
1)Error 2002
在my.cnf增加一行
输入sudo vim /etc/mysql/my.cnf,增加以下内容
[mysql]
protocol=tcp
重启服务
Service mysql restart
重新登录即可
2)Error 1689 :skip-grant-tables
在my.cnf增加一行
输入sudo vim /etc/mysql/my.cnf,增加以下内容
[mysql]
skip-grant-tables(跳过密码验证)
4、设置远程访问
注释掉配置文件中的“bind-address = 127.0.0.1”(本机访问字段)
获取配置路径:
cat /etc/mysql/my.cnf
该文件中的
“!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/”
即为实际配置文件路径
vim /etc/mysql/mysql.conf.d/mysqld.cnf
注释bind-address = 127.0.0.1
重启MySQL服务:Service mysql restart
登录MySQL:Mysql -uroot -p
授予用户权限:grant all on . to admin@‘%’ identified by ‘newroot’ with grant option;
刷新用户权限:flush privileges;
即可使用账号名admin和密码netroot进行全程登录: