[PLUG] MySQL - Can't connect except as root

[Richard C. Steffens]

drew wymore wrote:

> Connect as root and execute this ..
> 
> mysql>use mysql;
> mysql>select host from user where user = 'bookorama';
> 
> it should return the user you created along with whatever host was created
> by MySQL Admin
> 
> Post that here, and also where you're trying to connect from (are you
> actually connecting from localhost?) I've seen MySQL get weird and
> sometimes
> it wants 127.0.0.1 instead of localhost or it wants the local machine name
> instead of localhost when I've used some apps on it.

------------------------------------------------------------------------
> mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 44 to server version: 5.0.18

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select host from user where user = 'bookorama';
+------+
| host |
+------+
| %    |
+------+
1 row in set (0.04 sec)

mysql>
------------------------------------------------------------------------

-- 
Regards,

Dick Steffens