搭主从数据库时遇到的问题，直接复制原来存在的数据库时启动报这个错，解决方法：打开MySQL目录下的my.ini文件，在文件最后一行加上“skip-grant-tables”，保存之后重启mysql服务，再次登录就OK了。
cmd访问同一电脑上不同端口数据库的方法 mysql -uroot -p -P3307 //3307是端口号 根据自己设置而定
相关文章
- MySQL for Linux错误： ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- Mysql创建新用户后无法登录，提示 Access denied for user 'username'@'localhost' (using password: YES)
- 升级到macOS 10.12 mysqlb报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- 【转载】在MySQL登录时出现Access denied for user 'root'@'localhost' (using password: YES) 拒绝访问，并可修改MySQL密码
- Access denied for user ‘root‘@‘localhost‘(using password:YES)
- 解决The specified database user/password combination is rejected: com.mysql.cj.exceptions.CJException: Access denied for user \'root\'@\'localhost\' (using password: YES)问题
- MySQL命令行登录时出现Access denied for user ‘root‘@‘localhost‘ (using password: YES 拒绝访问
- yum 安装 Mysql error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 开启远程连接 修改登入密码 忘记root密码 配置防火墙规则 随手mark
- eclipse不正常编译导致错误:Access denied for user 'root'@'localhost' (using password: YES)
- Grant的时候报错的解决：Access denied for user 'root'@'localhost' (using password: YES)