Cannot connect to database

nballon · #1 (**permalink**) 10-18-05, 19:45

I am new at this so I will be brief. I keep getting this error when I try to add tables from the command line using MySQL - ERROR 1044: Access denied for user: '@localhost'...can someone show me or point me in the right direction to change the access so that I can start adding elements to my database?

thanks!

tombell · #2 (**permalink**) 10-19-05, 02:43

Post the exact command you are using to connect to the server

healdem · #3 (**permalink**) 10-19-05, 04:40

What privileges do you have to that database / server
what Grants have been assigned

Have a look at the MySQL manager for 'Grant Privileges'

nballon · #4 (**permalink**) 10-19-05, 23:03

Is "use testDB;"......as far as the priviliges are concerned, I am simply doing exercises on my laptop so I am the registered owner. I couldnt locate the "Grant Privileges" option in MySQL..any idea where to help a ROOKIE??

jfulton · #5 (**permalink**) 10-20-05, 13:00

You need to set up a user to have the correct permissions and then log in as that user.

Pretty sure you didn't log in to mysql (hence the: ''@localhost). Log in like:

Code:

mysql --user=user_name --password=your_password db_name

Also, do you have the users set up correctly? To set up a new user with all permissions try something like:

Code:

GRANT ALL PRIVILEGES ON * . * 
TO 'user_name'@'localhost' 
IDENTIFIED BY 'your_password' 
WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0
MAX_CONNECTIONS_PER_HOUR 0 
MAX_UPDATES_PER_HOUR 0 ;

Replacing 'user_name' and 'your_password' with the correct info. Then log in as that user.

or even easier, get phpMyAdmin

nballon · #6 (**permalink**) 10-20-05, 14:21

will do! thanks again for the assistance and I am SURE I will be back if I have any more problems/issues! Good looking out!

Internet Services

Web Development

Digital Marketing

Consumer Tech