改表
select
host,
user
from
user
;
update
user
set
host =
'%'
where
user
=
'root'
;
授权
GRANT
ALL
PRIVILEGES
ON
*.*
TO
'root'
@
'%'
IDENTIFIED
BY
'123456'
WITH
GRANT
OPTION
;
如果你想允许用户jack从ip为10.10.50.127的主机连接到mysql服务器,并使用654321作为密码
GRANT
ALL
PRIVILEGES
ON
*.*
TO
'jack'
@’10.10.50.127’ IDENTIFIED
BY
'654321'
WITH
GRANT
OPTION
;
FLUSH RIVILEGES
注释掉修改my.cnf 中的bind-address=127.0.0.1