- 初始化root密碼
update user set password=PASSWORD (‘root’) where User='root';
- 允許mysql遠(yuǎn)程訪問(wèn),可以使用以下兩種方式:
a .修改user表
use mysql;
update user set host ='%' where user ='root';
select host,user from user;
b 授權(quán)
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
