linux安装mysql

apt-get install mysql-server mysql-client

debian 10报错
解决E: Package ‘mysql-server‘ has no installation candidate与ERROR 1698 (28000)

apt install mariadb-server mariadb-client

安装mariadb之后依旧是使用mysql命令，它是mysql的分支而已

配置root的密码

sudo mysql_secure_installation

配置登录

USE mysql;
SELECT User, Host, plugin FROM mysql.user;

可以看到

+------------------+---------------------------------+
| User             | plugin                          |
+------------------+---------------------------------+
| root             | auth_socket（或是unix_socket）   |
+------------------+---------------------------------+

此时输入

UPDATE user SET plugin='mysql_native_password' WHERE User='root';
FLUSH PRIVILEGES;
exit;
sudo service mysql restart

添加远程访问权限

update user set host = '%' where user ='root';
grant all privileges on *.* to 'root'@'%';
flush privileges;

此时远程访问报错 10061 unknow error

打开mysql配置文件vi /etc/mysql/mysql.conf.d/50-server.cnf
j将bind-address = 127.0.0.1注销​