Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 08-20-2003, 08:18 AM   #1
Registered: Jul 2003
Location: Lisbon, Portugal
Distribution: Red Hat 9.0
Posts: 30

Rep: Reputation: 15
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,

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.



Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can not get access to mysql by normal user chinaundead Fedora 3 10-27-2010 03:33 AM
MySQL: 'access denied for user' turbo_acura Linux - General 1 10-20-2004 09:34 AM
can to get access to mysql from a normal user chinaundead Linux - Software 4 04-09-2004 08:56 PM
mySQL Access denied for user Gerardoj Linux - General 2 03-21-2004 11:13 AM
MYSQL access denied for user c0c0deuz Linux - General 1 03-18-2003 03:44 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:49 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration