腾讯云centos mysql 搭建完成之后登录报错“Access denied for user 'root'@'localhost' (using password: YES”)
来源:互联网 发布:雷锋源越狱软件 编辑:程序博客网 时间:2024/06/07 21:52
1、编辑 /etc/my.cnf ,在[mysqld] 部分最后添加一行
- skip-grant-tables
2、保存后重启mysql
- service mysqld restart
3、输入以下命令,回车后输入密码再回车登录Mysql
- mysql -uroot -p mysql
4、重新设置密码,其中 your_pwd 部分改为你自己想要设置的密码
- update user set password=password("your_pwd") where user='root';
5、刷新权限
- flush privileges;
6、\q Mysql,删除第一步添加的 skip-grant-tables,用第2步的方法重启MySQL,用修改后的密码重新登录
出现Welcome字样即为登录成功!
7、配置 navicat premium 或者 navicat mysql 远程访问
第6步登录成功之后,输入以下命令,其中
a) %代表任何主机都能访问该服务器,如果想要某一特定IP访问,则将%符号改成特定的IP地址
b) your_pwd代表远程访问时输入的密码
- GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'your_pwd' WITH GRANT OPTION;
- FLUSH PRIVILEGES;
8、然后用navicat premium访问测试,输入服务器IP、端口默认3306、用户名root和刚刚改过的密码,点击测试
出现“连接成功”,搞定!!
阅读全文
0 0
- 腾讯云centos mysql 搭建完成之后登录报错“Access denied for user 'root'@'localhost' (using password: YES”)
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”的处理方法
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”的处理方法
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”的处理方法
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”)的处理方法
- MySQL for mac 连接报错:Access denied for user 'root'@'localhost' (using password: YES)
- MySQL改密码报错:ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
- mysql报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql报错 Access denied for user 'root'@'localhost' (using password: YES)
- mysql 链接报错Access denied for user 'root'@'localhost' (using password :Yes
- MYsql:1045 access denied for user 'root'@'localhost' using password yes 报错问题
- 连接mysql报错Access denied for user 'root'@'localhost' (using password: YES)解决办法
- MySQL 'root'@'localhost'无法登录|Access denied for user ‘root’@’localhost’ (using password: YES)”
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- MySql Access denied for user 'root'@'localhost' (using password: YES)
- mysql access denied for user'root'@'localhost' using password yes
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- 记一笔试题-
- Git:代码冲突常见解决方法
- SQl语句之日期限制,查询距今不得超过XX年数或天数
- jsp/servlet
- C语言宏定义和宏定义函数
- 腾讯云centos mysql 搭建完成之后登录报错“Access denied for user 'root'@'localhost' (using password: YES”)
- 五种方式让你在java中读取properties文件内容不再是难题
- 1994 IOI 简单dp
- Spring 的简单配置
- sublime代码自动提示插件及项目创建
- archlinux安装(2)
- 简单学习TextView
- AJAX异步刷新-----判断用户名是否可用,预览头像
- SpringMVC HandlerMethodArgumentResolver解读