你想root用户名使用root密码从任何主机连接到MySQL服务器的话。
运行命令:mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
命令: GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'ekanet321' WITH GRANT OPTION;
你想root用户名使用root密码从任何主机连接到MySQL服务器的话。
运行命令:mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
命令: GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'ekanet321' WITH GRANT OPTION;