Paul,
> I am assuming that the 'alan' account that you're planning to use has
> all privileges. Otherwise, you will find after flushing the privileges
> that you'll no longer be able to administer your server without starting
> it with the --skip-grant-tables option...
The *alan* account does have all privileges. :-) That account works fine.
And the problem I asked early seems to be solved.
> If you deleted the rows with a DELETE statement, you'll need to also
> issue a FLUSH PRIVILEGES statement to cause the server to reread the
> grant tables.
In order to try the FLUSH PRIVILEGES statement, I inserted a new user
account into the 'user' table of the 'mysql' database:
mysql> insert into user (host, user, password) values ('localhost', 'brian',
'brian');
After doing this, I subsequently use FLUSH PRIVILEGES to let the MySQL
server reread the grant tables.
mysql> flush privileges
Query OK, 0 rows affected (0.01 sec)
Then, I quit the MySQL and try to login by 'c:\mysql\bin\mysql -h
localhost -u brian -p' followed by the password brian. I got the following
error message:
Error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES).
Then, I restart the computer, and repeat the process above again, same
error. ---- It seems I don't have to restart the computer (in WindowsXP) to
make the change valid.
Something cause my attention is that if I do the
mysql> select host, user, password from user;
I found that the password of *alan* is something like 51df199bcd85 while
*brian's* new account password is brian. ---- That is, the later one has not
been encrypted.
I can see the Alan's *actual* password characters('alan') in WinMySQLadmin
or the my.conf file, not the user table; but I DO see Brian's *actual*
password ('brian') from the user table.
BTW, I can't find any thing in the my.conf or WinMySQLadmin related to the
*brian* --- e.g. in the my.conf file, I only can see 'user=alan,
password=alan'.
Please help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]