Look up skip grants in the manual.
- Original Message -
From: "root" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 16:09
Subject: password() function not used when creating root password
> I have just created a root password i
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?
Th