php 连接mysql 错误排查一例
mysql> select user,host from mysql.user;+-----------------+---------------+
| user | host |
+-----------------+---------------+
| SbsBL6tnULzkI21 | % |
| root | 127.0.0.1 |
| SbsBL6tnULzkI21 | 192.168.2.* |
| root | ::1 |
| | localhost |
| SbsBL6tnULzkI21 | localhost |
| root | localhost |
| | mycloudserver |
| SbsBL6tnULzkI21 | mycloudserver |
| root | mycloudserver |
+-----------------+---------------+
10 rows in set (0.00 sec)
查看用户host,发现主机名是小写
在/etc/hosts文件添加以下解析
192.168.2.100 mycloudserver MyCloudServer
登录 正常
页:
[1]