I have just installed MYSQL 5.0.37 on my home machine. Inorder to start learning how to maintain my own databases and to create an enviroment to begin learning on.
I have everything setup, and the process runs, when I created a password for the default database for ther root login, it worked fine.
I used this command to do so;
The command was sucessful. I logged off the server, and logged back on using this command;
I recieved the error:
How do I correct this, I thought at that point it was to prompt me for my password, but it did not. How do I imput my password on the mysql -u root -p 3306 line? Any help would be most appricated!
I have everything setup, and the process runs, when I created a password for the default database for ther root login, it worked fine.
I used this command to do so;
| Code: |
| update user set Password=password('mypass') where User='root';
|
The command was sucessful. I logged off the server, and logged back on using this command;
| Code: |
| mysql -u root -P 3306 mysql |
I recieved the error:
| Code: |
| ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) |
How do I correct this, I thought at that point it was to prompt me for my password, but it did not. How do I imput my password on the mysql -u root -p 3306 line? Any help would be most appricated!
