LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices

Reply
 
Search this Thread
Old 08-20-2003, 08:18 AM   #1
tuka
Member
 
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,
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>
 
  


Reply


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


All times are GMT -5. The time now is 10:32 AM.

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