1 安装mysql-server
sudo apt install mysql-server
2 登陆
mysql -uroot -p
第一次登陆任意密码即可。
3 修改登陆密码
use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;
4 允许远程连接
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
将bind-address = 127.0.0.1注释掉,或者改成允许连接的IP地址
5 指定远程可以访问的用户
CREATE USER 'root'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
flush privileges;
授权给所有用户
使用Sqlyog连接如果报错2058,这是因为在8.0之前用的是mysql_native_password,8.0以后用的是caching_sha2_password。
执行如下代码:
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
flush privileges;