mysql8设置局域网访问

环境:

Ubuntu19.10

Mysql Server version: 8.0.19-0ubuntu0.19.10.3 (Ubuntu)

 

步骤如下:

①编辑/etc/mysql/mysql.conf.d/mysqld.cnf

bind-address        = 127.0.0.1

改成

#bind-address        = 127.0.0.1

②检查权限是否ok

mysql> select host, user, authentication_string, plugin from mysql.user; 
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
| host      | user             | authentication_string                                                  | plugin                |
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
| %         | appleyuchi       | *D3E7FCBA6B5307C86B6EBC7C3BF1DB509167E8F2                              | mysql_native_password |
| localhost | debian-sys-maint | $A$005$)3rPsdLabBEQ5cN2nhkVIHrAK49jjwQ/P58Fhq8QgvQl2Cskryo4VI9uUoD | caching_sha2_password |
| localhost | mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | mysql.session    | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | mysql.sys        | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | root             |                                                                        | auth_socket           |
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
6 rows in set (0.01 sec)

mysql> GRANT ALL ON *.* TO 'appleyuchi'@'%';
 

 

③service mysql restart

此时局域网内的其他电脑可以连接你的数据库