Creating users in mysql is: GRANT ALL|[CREATE|UPDATE|etc.)] PRIVILEGES ON
dbname.tablename TO user@host IDENTIFIED BY password
If you want to check the "grants" to see if you've created that user
correctly, try: SHOW GRANTS FOR user@host
From: Behrang Saeedzadeh
Sent: 2/13/2005 1:42 PM
Subject: 2+1 MySQL Questions
I've installed MySQL on my Ubuntu Linux system. Then I installed MySQL
Query Browser on my Win XP laptop.
I've created a user for the MySQL which in the host field I've put %,
I guess it means access from every IP (am I right?)
But I cant connect to the MySQL instance. What could be wrong?
Also, I created the user using mysqlcc but it doesn't save the
password. I created a user with a password but I can only login with
that user when I don't pass the password. How can I create users
manually? Is there any commands for this?
And finally, is there a .deb package available for MySQL Query Browser
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
|• 2+1 MySQL Questions||Behrang Saeedzadeh||13 Feb|
|• RE: 2+1 MySQL Questions||Michael L USAATC Dean||13 Feb|