Access denied for user: 'webuser@localhost'

kimya

I haven't seen this in the newbie FAQ, but if it has been said before, please excuse me -- I am not only a newbie to PHP/SQL, but also to this forum. 🙂

Here is my problem: I created a few users in my new mySQL server, including a webuser with this line:

GRANT SELECT on mydatabase.* TO webuser@'%' IDENTIFIED BY 'xxxxxxxx'

I FLUSH PRIVILEGES, and then then I run this script to test it:

<?php

echo mysql_connect('localhost', 'webuser', 'xxxxxxxx');

When I run it, this is the result:

Warning: mysql_connect(): Access denied for user: 'webuser@localhost' (Using password: YES) in C:\inetpub\wwwroot\Kimya\info_msql.php on line 3

Any ideas on what I might be doing wrong? 🙂

Thanks a lot!

marky2coats

Hi,

You have set privileges for webuser@% and not webuser@localhost.

When a user is accesing the mysql server localy it uses the webuser@localhost ie this account takes priority over webuser@% (% means anywhere).

Mark.

kimya

Thanks a lot for the answer. 🙂

I set it to '%' because I wanted it to be reached from any host -- if I set it to localhost, it will only be reached from my computer, right? maybe I am wrong at this. 🙂

Thanks again 🙂

marky2coats

Yes you are right. So if you want your server to be accessed locally by a user AND from anywhere you need user@localhost and user@% accounts.

I usually make the anywhere accounts have alot less privileges than local ones due to mysql passing username and passwords in plain text.

Mark.

kimya

Thanks a lot for answering. 🙂 It works fine with user@localhost, it's what I am using for now. I will try to find a way to make it work with any domain. 🙂

Thanks again!