List:General Discussion« Previous MessageNext Message »
From:Michael L USAATC Dean Date:February 13 2005 8:10pm
Subject:RE: 2+1 MySQL Questions
View as plain text  
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

Michael

-----Original Message-----
From: Behrang Saeedzadeh
To: mysql@stripped
Sent: 2/13/2005 1:42 PM
Subject: 2+1 MySQL Questions

Hi all

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
and Administrator?

Best Regards,

-- 

Behrang Saeedzadeh
http://www.jroller.com/page/behrangsa

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
Thread
2+1 MySQL QuestionsBehrang Saeedzadeh13 Feb
RE: 2+1 MySQL QuestionsMichael L USAATC Dean13 Feb