Access denied for user

[Anon]

Hi,
I have a trouble with the remote connection on mysql db.

On my pc all runs correcty, but when I put my stuff on the server there is some kind of error.

I have to create all: the database, the users permissions, and the db permissions.
So I think I do some mistakes in permissions.

This is the connection php script (on my pc it work correcly).

$server_name="localhost";
$usr_name="userName";
$usr_pwd="userPwd";
$database_name="dbName;
$connection=mysql_connect($server_name,
$usr_name,$usr_pwd)
or die ("Mysql error: " .mysql_error() );
$DB=mysql_select_db($database_name,$conn
essione)
or die ("Mysql error: " .mysql_error() );

---

I have already tryed to change "localhost" with:

---

$server_name="myDomain.com";
either
$server_name="IPaddress";
either
$server_name="www.myDomain.com";

---

and I have always an error.
This is my error:

Warning: Access denied for user: 'userName@localhost' (Using password: YES) in /usr/local/etc/httpd/htdocs/ mioSito/admin/include/db/connection.php on line 9
Warning: MySQL Connection Failed: Access denied for user: 'userName@localhost' (Using password: YES) in / usr/local/etc/httpd/htdocs/columbus/admin/include/db/connection.php on line 9

Mysql error: Access denied for user: 'userName@localhost' (Using password: YES)

(either: [e-mail])

These are the user privileges ("user" table in "mysql" database):

Host %
User userName
Password userPwd
Select_priv Y
Insert_priv Y
Update_priv Y
Delete_priv Y
Create_priv N
Drop_priv N
Reload_priv N
Shutdown_priv N
Process_priv N
File_priv N
Grant_priv N
References_priv N
Index_priv N

Alter_priv N

And these are my database privileges ("db" table in "mysql" database):

Host %
Db dbName
User userName
Select_priv Y
Insert_priv Y
Update_priv Y
Delete_priv Y
Create_priv N
Drop_priv N
Grant_priv N
References_priv N
Index_priv N

Alter_priv N

the others tables are empties.

What can I do?
Please Help me.

I have already tryed with
FLUSH PRIVILEGES

Thank you,
saintex

[scoppc]

Try to use:

GRANT ALL PRIVILEGES ON . TO 'userName@localhost'
blah blah blah ...

probably that's the problem.

scoppc

"May All Beings Live In Happiness"

[Anon]

nothing to do 🙁

[scoppc]

$server_name="localhost";
$usr_name="userName";
$usr_pwd="userPwd";
$database_name="dbName;
$connection=mysql_connect($server_name,
$usr_name,$usr_pwd)
or die ("Mysql error: " .mysql_error() );
$DB=mysql_select_db($database_name,$conn
essione)

or die ("Mysql error: " .mysql_error() );

from the above code, can you see that you left one " at line 4?
is that the mistake?

scoppc

"May All Beings Live In Happiness"

[Anon]

yes It's a mistake, but a copy-mistake.

On original scipt I have:
$database_name="dbName";

Then I have done a test with my server and I have tested my connection with mysql user root permession.

All work correcly.

So I know, it isn't a script error, but it is a mysql user permission error.

The problem is that I have to set correctly a user for mysql (cause I can't use root for connection).

What is my mistake?

[Anon]

In telnet also the mysql prompt said "access denied" ecc. and the code error is 1045

Thank you for answering

[Anon]

I have set the permissions with GRANT etc.
(before I have used phpMyAdmin) and now it works right.

Thank you.

Just another question:
Is it better "localhost" or "serverName.com"
in "host" columns (in "mysql" database)?
What is the difference?

[Anon]

the localhost entry might be quicker on the local machine, as it doesn't need to do a dns lookup, but i doubt that it will make that much difference.

[Anon]

thank you