MySQL user access and grants
 

Hello all,

I am a newbie at MySQL and have a question regarding a problem I am running into using users other than root on my machine. I am using MySQL and all other apps localy.

I can log on to MySQL as root without problems but when I log on as any other user even when I am granted all previleges, I seem to run into trouble. I will start just with logging in for now... I have included part of the table mysql.user for reference.

For example, at logon, the administartor tuka below with all previleges can logon with a blank password (??? - see first block after table) on the same machine but if I type in the attributed password upon login ( 2nd block), an error is returned.

Any explanation to this ? Also what does % mean and does this have any link to the problem ? Why does root appear in 3 different forms in the table ?

Thanks in advance,
Tuka



mysql> select host,user,password,Grant_priv from user
-> ;
+-----------------------+-----------+------------------+------------+
| host | user | password | Grant_priv |
+-----------------------+-----------+------------------+------------+
| localhost | root | 2826f9444a2ab7e8 | Y |
| localhost.localdomain | root | | Y |
| localhost | | | N |
| localhost.localdomain | | | N |
| % | tuka | 2826f9444a2ab7e8 | Y |
| % | bookorama | 7db6167f3d363957 | N |
| % | root | 2826f9444a2ab7e8 | N |
+-----------------------+-----------+------------------+------------+
7 rows in set (0.00 sec)

[root@localhost root]# mysql -u tuka -p
Enter password:
ERROR 1045: Access denied for user: 'tuka@localhost' (Using password: YES)

[root@localhost root]# mysql -u tuka -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.54

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

mysql>