1、问题描述:
当在SQLyog中执行以下脚本:
CREATE DATABASE IF NOT EXISTS sys;
USE sys; CREATE USER root1 IDENTIFIED BY 'root1';
GRANT ALL ON sys.* TO root1;
但是,建立新连接时报错:
命令行窗口登录:
D:\MyDev\MySQL\MySQL_Server_5.\bin>mysql -uroot1 -p
Enter password: *****
ERROR (): Access denied for user 'root1'@'localhost' (using password: YES)
2、解决方案:
具体修改脚本:
CREATE DATABASE IF NOT EXISTS sys;
CREATE USER root1@localhost IDENTIFIED BY 'root1';
GRANT ALL ON sys.* TO root1;