首先进入数据库
mysql -u root
设定密码:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
然后会提示输入密码
你想root使用123456从任何主机连接到mysql服务器。
mysql>
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;