From: Dean, Michael L USAATC (michael.deanatc.army.mil)
Date: Sun Feb 13 2005 - 14:10:47 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Creating users in mysql is: GRANT ALL|[CREATE|UPDATE|etc.)] PRIVILEGES ON
dbname.tablename TO userhost IDENTIFIED BY password

If you want to check the "grants" to see if you've created that user
correctly, try: SHOW GRANTS FOR userhost

Michael

-----Original Message-----
From: Behrang Saeedzadeh
To: mysqllists.mysql.com
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=michael.deanatc.army.mil

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]