grant all on *.* to root@'%' identified by '111111';
grant all on *.* to root@'192.168.1.88' identified by '111111';
谢谢 zhoupuyue同学 顺便帮忙怎么写取消了它的权利了
-- 怎么授权给其它机子访问 mysql> grant all on *.* to root@'192.168.1.88' identified by '111111'; Query OK, 0 rows affected (0.14 sec) -- 怎么写取消了它的权利了 mysql> drop user root@'192.168.1.88'; Query OK, 0 rows affected (0.14 sec)mysql>
grant all privileges on *.* to root@'%' identified by "111111" with grant option;我一般刚装完MySql就得这么干一次。之后可以通过phpmyadmin之类的来慢慢修改权限问题。
顺便帮忙怎么写取消了它的权利了
mysql> grant all on *.* to root@'192.168.1.88' identified by '111111';
Query OK, 0 rows affected (0.14 sec) -- 怎么写取消了它的权利了
mysql> drop user root@'192.168.1.88';
Query OK, 0 rows affected (0.14 sec)mysql>