Error connecting when a user is denied the following...

[etegration]

When a mySQL user is denied the following:

Create tmp tables
Lock Tables
Grant
Alter
Drop
Create

$link = mysql_connect("localhost", "user_database", "password")

But when i use another user with everything granted via phpmyadmin installed with DA, it allows the connection. What is stopping the connection?

 

[DirectAdmin Support]

Hmm... I'm not sure the access rights would change the login. Just a note, that you've use "user_database" for the login name. It should be "user_username" ... in case that makes any difference for you. The database is selected after the connection is made with the db user/pass.

John

 

[etegration]

Hmm... I'm not sure the access rights would change the login. Just a note, that you've use "user_database" for the login name. It should be "user_username" ... in case that makes any difference for you. The database is selected after the connection is made with the db user/pass.

John

yes John, was lazy to edit the user_database which in fact it's the username.