无法选择数据库!Access denied for user ''@'localhost' to database ''解决
来源:互联网 发布:Apple Watch解锁mac 编辑:程序博客网 时间:2024/05/15 18:12
php代码如下
$connection = @mysql_connect("localhost","scetol","sce1234" )or die("无法连接到数据库!"); mysql_select_db("count")or die("无法选择数据库!".mysql_error());
提示以下错误
无法选择数据库!Access denied for user 'scetol'@'localhost' to database 'count'
原来用的是scetol这个数据库.现在新建立一个数据库.用scetol账号连接,会提示以下错误.
原因是scetol这个账号,其实不是超级管理员的账号,是我专门为scetol数据库建立的.所以.用他连接新的数据库count,当然是提示错误的.
解决方法是.为count单独建立一个权限比较低的专用账号即可.在phpmyadmin中.打开count这个新数据库.点击右上角的权限.进入后,点击添加新用户,设置一下用户名与密码.主机选择本地即localhost
然后直接点击执行.下面的都不要打勾.
提示添加完用户后,会有一个选项.如图,然后直接选择新的数据库后进入.
然后按下图红框中所示,打勾.点击执行即可.管理权限不要打勾.
0 0
- 无法选择数据库!Access denied for user ''@'localhost' to database ''解决
- 解决Access denied for user ''@'localhost' to database 'mysql
- 解决Access denied for user ''@'localhost' to database 'mysql'问题
- mysql Access denied for user ''@'localhost' to database
- Access denied for user ''@'localhost' to database 'mysql'
- Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database
- Mysql错误: Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database
- Access denied for user 'root'@'localhost' to database
- mysql Access denied for user ''@'localhost' to database
- Access denied for user ''@'localhost' to database 'xxx‘
- ERROR 1044 (42000): Access denied for user ”@’localhost’ to database
- mysql Access denied for user ''@'localhost' to database 'mysql'
- Access denied for user ''@'localhost' to database 'mysql'
- mysql提示access denied for user ''@'localhost' to database
- Access denied for user ''@'localhost' to database 'mysql'
- Access denied for user'admin'@'localhost' to database 问题的解决
- 代码敲累了就来看看《PPT制作经验分享-思维导图》
- JavaScript判断浏览器类型及版本
- Servelt返回数组类型json数据
- DbUtils简单使用
- [资源帖]SIGGRAPH2016 下载地址
- 无法选择数据库!Access denied for user ''@'localhost' to database ''解决
- 每天一个linux命令(11):nl命令
- c::一道关于找凶手的题
- GIS之旅——大学本科总结
- eclipse-集成友盟
- 期望E(X)
- Ubuntu安装Pyenv+Anaconda2+PyCharm+OpenAI-gym+Cuda+TensorFlow (三)
- java中的堆和栈问题
- 打造通用的自定义评分星级RatingBar