访问被拒绝用户'someuser'@'localhost'（使用密码：是） [英] Access denied for user 'someuser'@'localhost' (using password: YES)

问题描述

我在mysql中创建了一个名为somedatabase的数据库

  CREATE DATABASE somedatabase; 
 GRANT ALL ON somedatabase。* TO'someuser'@'localhost'IDENTIFIED BY'somepassword'; 
  

但是当我尝试使用php应用程序访问此数据库时，我收到以下错误

mysql_connect（）[function.mysql-connect]：访问
拒绝用户'someuser'@'localhost'（使用密码：YES）

Mysql查询浏览器允许我使用用户名：someuser和password登录到此数据库： somepassword。那么为什么我无法通过应用程序连接到数据库。

php代码：

  $ db_url ='mysql：// someuser：* somepassword * @ localhost / somedatabase'; 
  

解决方案

不要在使用时使用singlequote（'） GRANT。

  GRANT ALL ON somedatabase。* TO someuser @'localhost'IDENTIFIED BY'somepassword'; 
  

我也假设你正在和MySQL一样运行Apache / PHP。 p>

I have created a database by name 'somedatabase' in mysql

CREATE DATABASE somedatabase;  
GRANT ALL ON somedatabase.* TO 'someuser'@'localhost' IDENTIFIED BY 'somepassword';

but when i try to access this database using php application i get the following error

"mysql_connect() [function.mysql-connect]: Access denied for user 'someuser'@'localhost' (using password: YES)"

The Mysql query browser does allow me to login to this database using username : someuser and password : somepassword. Then why is that i am not able to connect to database through application.

php code :

$db_url = 'mysql://someuser:*somepassword*@localhost/somedatabase';

解决方案

Do not use singlequote (') around someuser when using GRANT.

GRANT ALL ON somedatabase.* TO someuser@'localhost' IDENTIFIED BY 'somepassword'; 

I am also assuming that you're running Apache/PHP on the same box as MySQL.

这篇关于访问被拒绝用户'someuser'@'localhost'（使用密码：是）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！