安装
准备:下载:版本=5.1.17的MySQL并上传至Ubuntu系统
#解压
tar -xvf mysql-server_5.7.17-1ubuntu16.10_amd64.deb-bundle.tar
#提前安装插件
sudo apt-get install libaio1 libmecab2
#若安装失败使用以下命令
apt --fix-broken install
sudo apt-get install libaio1 libmecab2
#逐步执行
sudo dpkg -i mysql-common_5.7.17-1ubuntu16.10_amd64.deb
sudo dpkg -i libmysqlclient20_5.7.17-1ubuntu16.10_amd64.deb
sudo dpkg -i libmysqlclient-dev_5.7.17-1ubuntu16.10_amd64.deb
sudo dpkg -i libmysqld-dev_5.7.17-1ubuntu16.10_amd64.deb
sudo dpkg -i libmysqlclient20_5.7.17-1ubuntu16.10_amd64.deb
sudo dpkg -i mysql-community-client_5.7.17-1ubuntu16.10_amd64.deb
sudo dpkg -i mysql-client_5.7.17-1ubuntu16.10_amd64.deb
sudo dpkg -i mysql-client_5.7.17-1ubuntu16.10_amd64.deb
#在安装 mysql-community-server 时要求输入密码的页面
sudo dpkg -i mysql-community-server_5.7.17-1ubuntu16.10_amd64.deb
sudo dpkg -i mysql-server_5.7.17-1ubuntu16.10_amd64.deb
设置远程
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
将bind-address的值改为 0.0.0.0
启动
sudo service mysql start
sudo service mysql status
sudo service mysql stop
用户授权
#修改root用户密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '数据库root用户密码';
#给root授权允许任意地址访问
CREATE USER 'root'@'%' IDENTIFIED BY '数据库root用户密码';
ALTER USER 'root'@'%' IDENTIFIED BY '数据库root用户密码';
#给root用户所有权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
flush privileges;
或:
update user set host = '%' where user = 'root';
修改密码
set password for root@localhost = password('qwer');
flush privileges;
若出现ssl报错,mysql版本高需要ssl验证,卸载降低版本或修改代码连接useSSL=false
卸载
sudo apt purge mysql-*
sudo rm -rf /etc/mysql/ /var/lib/mysql
sudo apt autoremove
sudo apt autoclean