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

etegration

Verified User
Joined
Jan 22, 2004
Messages
103
Location
Singapore
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?
 
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
 
DirectAdmin Support said:
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.
 
Back
Top