Problem setting up new User 1

[mhamilton3]

Hello,
I have what appears to be an easy task, but I am having difficulty. I have recently set up a new Unix box (FreeBSD) and I am using mySQL as a database. I assigned a password to the root@localhost and I use that to set up the other users. I logged into the command line mySQL with

mysql -u root -p

. I then selected the main database with

use mysql

. Then I inserted a user with

insert into user values('localhost', 'myuser', PASSWORD('mypassword'), 'Y', 'Y', ...)

. That took. I then tried to log in to mysql with

mysql -u myuser -p

and it will not recognize the password. As a matter of fact, if I use

mysql -r myuser

without a password, it lets me in. Any suggestions would be appreciated. Thanks.

- Mark

 

[sleipnir214]

Did you issue a FLUSH PRIVILEGES command after modifying the user table?

When you modify user permissions using the GRANT or REVOKE statements, the changes take place immediately and automatically.

If you modify the user tables directly, you have to flush the privileges for the changes to take place.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[mhamilton3]

Is love to strong a word to use here... You have made my day, thank you very much!