允许远程连接 (v8.0)

  1. CREATE USER 'root'@'192.168.1.1' IDENTIFIED BY '123';

免密登录

通过 APT 安装的，配置文件在 /etc/mysql/mysql.conf.d/mysqld.cnf

  1. sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

添加如下：

  1. [client]
  2. user            = root
  3. password        = 123

重启MySQL

  1. sudo sysytemctl restart mysql

输入 mysql 即可。