mysql Access denied for user 错误处理
来源:互联网 发布:手机云桌面软件 编辑:程序博客网 时间:2024/05/16 16:15
定义用户:create user test identified by 'test';
+------------------+------+
| host | user |
+------------------+------+
| % | test |
| localhost | |
| localhost | root |
| test.saeg.com.cn | |
| test.saeg.com.cn | root |
+------------------+------+
5 rows in set (0.00 sec)
5.参看用户权限
show grants for root@'localhost';
+------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for test@% |
+------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' IDENTIFIED BY PASSWORD '*dfg' WITH GRANT OPTION |
+------------------------------------------------------------------------------------------------------------------------------------------------+
因为你的帐号权限问题才导致此错误。。。所以你要把你访问数据库的帐号的权限改一下。。
具体格式如:grant all on mysql.* to 'root'@'localhost' identified by 'password';
1。mysql.* 你访问的数据库名字。
2。root' 你的用户名
3。'password' 需要修改的密码。。
最后问题解决
- mysql Access denied for user 错误处理
- MySql access denied for user错误
- Access denied for user错误
- Mysql错误: Access denied for user ''@'localhost' to database 'mysql'
- MySQL提示Access denied for user 'ODBC'@'localhost'错误
- mysql Access denied for user root@localhost错误解决方法总结
- MySQL WINDOWS-XP错误: Access denied for user 'root'@'localhost'
- mysql Access denied for user root@localhost错误解决方法总结
- 链接mysql密码错误的异常 Access denied for user
- mysql Access denied for user root@localhost错误解决方法总结
- Mysql复制错误error_code: 1045 Access denied for user
- windonws8 下 phpmyadmin 1045错误:mysql Access denied for user
- mysql Access denied for user root@localhost错误解决方法总结
- mysql Access denied for user root@localhost错误解决方法总结
- mysql Access denied for user root@localhost错误
- mysql Access denied for user root@localhost错误解决方法总结
- mysql Access denied for user root@localhost错误解决方法
- mysql Access denied for user root@localhost错误解决方法总结
- (js)用window.onload实现刷新页面的导航栏状态的切换
- [IE9] 如何开启IE9的GPU硬件加速
- Matlab中del2()函数学习笔记
- TCP建立和关闭连接
- 检测字符种类 验证强度
- mysql Access denied for user 错误处理
- 同一个页面用Js和服务器验证控件OnClientClick提交问题
- linux进程调度浅析
- const 限定符
- Linux 系统编程的推荐书籍
- linxu select 返回值
- 集合类说明及区别
- css -基础知识
- oracle scott