MySQL —允许所有ip远程连接数据库

  • Post author:
  • Post category:mysql




1.修改允许连接ip

C:\Users\CSJ>mysql -uroot -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.33 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mysql
Database changed
mysql> select user,host from user;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| mysql.s



版权声明:本文为m0_66984268原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。