ubantu安装mysql

安装

准备：下载：版本=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