At 1:01 PM -0400 04-07-2000, Elizabeth Alvanas wrote:
>I was wondering if you could please help me with a problem I am having with
>database administration. I am trying to grant the user 'administrator' with
>password '12345678' access to all database tables. I go into mysql using
>user='root'. I then type the following:
> mysql> use mysql
> mysql> insert into user
>I can then "select * from user;" and see this new user.
>However, if I quit from mysql and try to go into mysql again by typing:
> mysql -u administrator -p
>I receive the error message:
> ERROR 1045: Access denied for user: 'administrator@localhost' (Using
>I can however access the server without specifying a password by typing:
> mysql -u administrator
>I can then successfully do a "show databases" but access is denied to any
>I am using MySQL server version 3.22.32.
>Am I doing something wrong?
You probably didn't reload the grant tables. Without doing that,
your changes have no effect when you modify the tables manually.
mysql> FLUSH PRIVILEGES;
But it's better to use the GRANT statement, which is easier and causes
the tables to be reloaded automatically. I think this should do it:
IDENTIFIED BY '12345678'
Paul DuBois, paul@stripped