PDA

View Full Version : Need help please.


Iroxorsju
01-03-2005, 11:44 AM
I have been through all the help topics and I am still haveing problems. I need help with, I get the error 1044: access denied to local user. I used the guide just above this and I still get the error. So if anyone has the time to help me I would very much appriciate the help. You can talk with me on My MSN messenger my handle is Killjoy78@hotmail.com. Or just leave a post. Thanks in advance.

Skyphen
01-30-2005, 09:00 AM
Did you grant yourself access? Use the command:
GRANT ALL PRIVILEGES ON *.* TO Username@localhost IDENTIFIED BY 'Password' WITH GRANT OPTION;

Replace username with your mysql username and replace your password with what password you are using. Note: You must be using user root to grant priveleges to another user, unless ofcourse the user you are using has the grant priveleges as well.

To connect to mysql using root user use the command:

mysql -u root

Hope this helps.