mgaintyhotmail.com
Date: Mon Dec 10 2007 - 16:17:50 CST

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

1)the user you have connected with does not have permissions to the table
2)you have not yet connected to the DB containing users table easily solved
by connect mysql and rerun query

Viel Gluck/Buena Suerte
Martin--
----- Original Message -----
Wrom: LYRWTQTIPWIGYOKSTTZRCLBDXRQBGJSNBOHMKHJYFMY
To: <mysqllists.mysql.com>
Sent: Monday, December 10, 2007 4:51 PM
Subject: Blank users/passwords

I'm a new MySQL DBA taking over admin duties for an existing MySQL
nonclustered 4.1 installation. It has 6 small user databases. So in the
mysql database, I run the query

Select host, user, password from user;

Which returns the following:

+---------------------+-----------------+-------------------------------
------------+

| host | user | password
|

+---------------------+-----------------+-------------------------------
------------+

| localhost | root | (long hex string)
|

| localhost network name | root |
|

| localhost network name | |
|

| localhost | | (long hex string)
|

| localhost | one_user | (long hex string)
|

| % | one_user | (long hex string)
|

| % | root | (long hex string)
|

| localhost | two_user | (long hex string)
|

| IP address x | one_user | (long hex string)
|

| IP address y | one_user |
|

+---------------------+-----------------+-------------------------------
------------+

Does this mean that:

1. Line 2 above: root can log in with a blank password from (localhost
network name)?

2. Line 3 above: A blank user/password can be used to log in from
(localhost network name)?

3. Line 4 above: A blank user can be used to log in from localhost, but
a password has been specified?

4. Line 10 above: User "one-user" can be used to log in from IP address
y with a blank password?

Or am I reading this incorrectly?

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

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