antechinus
Technical User
I have just created a root password in MySQL without using the PASSWORD function.
in the user table i put in a root password, like this.....
mysql> UPDATE user SET Password='new_password' WHERE user='root';
mysql> FLUSH PRIVILEGES;
Now i am denied access. How do start the mysql server now? The manual wasnt clear that the password() function should have been used.
Please help. Thank you.
in the user table i put in a root password, like this.....
mysql> UPDATE user SET Password='new_password' WHERE user='root';
mysql> FLUSH PRIVILEGES;
Now i am denied access. How do start the mysql server now? The manual wasnt clear that the password() function should have been used.
Please help. Thank you.
