Adding New Users in MySQL (mysqladmin)

I have hit a brick wall with this one:
when I use the command

./bin/mysqladmin -u (user) -p (password)

I get this:
./bin/mysqladmin: unable to change password; error: 'You are using MySQL as an anonymous users
and anonymous users are not allowed to change passwords'

I'm assuming that it is looking for this user to already exist, but I am unsure as to HOW to add new users. I'm new to MySQL, so please be patient. I do, however, have over two year's expierence on Linux administration, so server talk is easy for me to comprehend!

Any help is welcome, will even accept urls to tutorials!!

Regards,
Brant

Are you trying to log in to MySQL or trying to change the password?

If you are trying to change the password, try this syntax:
./bin/mysqladmin -u root -p 'mynewpassword'

For logging into MySQL, I use this command:
mysql -h localhost -u root -p

This will then prompt me for a password. The -h is for Hostname, which can be myhost.com or localhost.

Also, check out www.mysql.com for the MySQL documentation, as well as http://www.devshed.com/Server_Side/PHP/DB_Basics/ here at devshed, and finally WebMonkey (www.webmonkey.com) has some great MySQL info at http://hotwired.lycos.com/webmonkey...?tw=programming

Hope this helps!

michael

Thank YOU!! I finally got a web based program to help me add new users and hosts.
I fiddled for a few hours trying to add them via mysql directly (with no luck) then went to the contrib page on MySQL and took their suggestion....works VERY WELL!
Once Again, thank you!!

Regards,
Brant

I use the GRANT statements myself. A bit more difficult to learn, but much more control over access. Of course, if you don't need that type of control...