MySQL PRIVILEGES problem
| From: | Manu Verhaegen | Date: | Mon, 23 Jul 2001 09:49:35 +0000 |
| Subject: | MySQL PRIVILEGES problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-59165@lists.php.net to get a copy of this message | ||
Dear all,
I have the following problem :
I want change te root password for mysql and we receive the following error message
ERROR 1064: parse error near 'FLUSH PRIVILEGES' at line 1
I login to my MySQL server and type the following commands
shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password') where
mysql> user='root';
mysql> FLUSH PRIVILEGES;
ERROR 1064: parse error near 'FLUSH PRIVILEGES' at line 1
thanks in advance.