Re: adding users to mysql is impossible!

[Jeffrey Greer]

[posted and emailed]

Thanks, but it still does not work:

Here is what I have typed:

>mysql -u root -p mysql

mysql> GRANT ALL PRIVILEGES ON *.* TO test@"%"
IDENTIFIED BY 'test$$*' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)


At another command line I typed:

> mysqladmin reload -u root -p<my password>

I try to login and get this error

>mysql -u test -p'test$$*'
ERROR 1045: Access denied for user: 'test@localhost' (Using password:
YES)

I next killed all mysqld processes and restarted mysqld.  Still does
not work.  I checked the tables with "SELECT * FROM user WHERE
user='test';"  "test" is in there.

Jim Faucette wrote:

> > --
> Jeff,
>   There are two primary ways to add users. I use the oldest method:
>   mysql mysql
>   INSERT INTO user (host, user, password) VALUES ('localhost',
> 'test',     PASSWORD('test'));
> 
>   SELECT * FROM user WHERE user='test';
>   You'll see that all privs are set to 'N'. If this is a user who is
> allowed to access ALL databases, then UPDATE user SET ... those privs
> the user should have.
> 
>   Otherwise, if the user is only allowed to use certain DBs, then you'll
> need to INSERT one (or more records) INTO db. Ex:
> INSERT INTO db (host, db, user) VALUES ('localhost', 'testdb', 'test');
> Then set the privs you want the user to have for 'testdb'.
> 
> Quit mysql (\q). Then reload at the commandline:
> mysqladmin reload
> 
>  jim...

--
Jeff Greer
B.S. computer science, University of MO - Rolla

"If travelling by plane is 'flying' then travelling by boat is
swimming.
If you want to experience the environment, get out of the vehicle."
SKYDIVE!