安装MySQL
1.安装mysql-server、mysql-client
sudo apt-get install mysql-server mysql-client
2.修改root密码
1)打开文件/etc/mysql/mysql.confused.d/mysql.cnf,在其中的[mysqld]配置项添加skip-grant-tables
2)重启 mysql 服务:sudo service mysql restart
3)登录 mysql(此时不需要输入密码,直接输入mysql即可登录),输入:
flush privileges;
alter user 'root'@'localhost' identified with mysql_native_password by 'root';
exit;
4)打开文件 /etc/mysql/mysql.confused.d/mysql.cnf,删除此前添加的skip-grant-tables
5)重启 mysql 服务:sudo service mysql restart
初始化
创建user用户,设置密码为user
create user if not exists 'user'@'localhost' identified by 'user';
创建数据库userDatabase
create database if not exists userDatabase;
mysql赋权操作
grant all privileges on userDatabase.* to 'user'@'localhost';
配置远程连接
打开文件 /etc/mysql/mysql.conf.d/mysqld.cnf,注释其中"bind-address = 127.0.0.1
"这一行;
以root用户登录,执行update mysql.user set host='%' where User='user';
赋予远程连接权限给user,执行grant all privileges on userDatabase.* to 'user'@'%';
重装MySQL服务器
1.查看 mysql-server:dpkg -l|grep mysql-server
2.卸载 mysql-server:
sudo apt-get remove --purge mysql-server mysql-server-8.0 mysql-server-core-8.0
3.删除数据库文件:sudo rm -rf /var/lib/mysql
4.重装安装 mysql-server:sudo apt-get install mysql-server