我在MYSQL下查询到root的用户信息如下:mysql> show grants for [email protected];
+--------------------------------------------------------------------------------------------------------------------------+
| Grants for [email protected] |
+--------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.88' IDENTIFIED BY PASSWORD '*A9C2C13F251564116D94D81BEF652EBEDB863CCF' |
+--------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
因为现在WEB服务器的IP有变动,由192.168.1.88改为192.168.1.201
我要怎么操作呢?
+--------------------------------------------------------------------------------------------------------------------------+
| Grants for [email protected] |
+--------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.88' IDENTIFIED BY PASSWORD '*A9C2C13F251564116D94D81BEF652EBEDB863CCF' |
+--------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
因为现在WEB服务器的IP有变动,由192.168.1.88改为192.168.1.201
我要怎么操作呢?
呵呵,我对MYSQL一点都不懂,麻烦说具体点,我要怎么操作?
中的192.168.1.88换成你的新IP执行以下即可。
flush privileges;