Review your favorite Linux distribution.
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 07-27-2003, 05:47 PM   #1
Registered: Jul 2003
Posts: 33

Rep: Reputation: 15
Mysql User grant problems


I just got Mysql up and working (yay!)

heres some background info:

Slackware 9
Mysql 4.3.5

I guess i created a user called 'mysql' with a blank password.

IN PHP, when i try to select a db with this command line:


it returns with this error, which i receive with this function mysql_error():

Access denied for user: '@localhost' to database 'uber'

Now, what does this mean? and what do i have to do?

Thanks a lot..
Old 07-27-2003, 09:53 PM   #2
Registered: Oct 2002
Location: Havertown PA
Distribution: Ubuntu/RHEL/Fedora
Posts: 253

Rep: Reputation: 31
Are you specifying a username in the php script? You'll need to make a reference to the username and pass in the script ....or in a global file that has all the database parameters defined in it (which is more secure than putting the username/pass in each individual script.

It seems the script is trying to log into MySQL without any credentials other than the machine's identity.

There is a ton of good documentation on and about how to properly access your db.

Good luck.
Old 07-27-2003, 11:25 PM   #3
Registered: Jul 2003
Posts: 33

Original Poster
Rep: Reputation: 15
Yes, i am providing the connection parameters..


that doesn't produce an error, i have it setup so if the login doesnt work, it'll give me a message, But im only getting a message when i select a database with this line


Any ideas?
Old 07-28-2003, 03:16 AM   #4
LQ Newbie
Registered: Jul 2003
Distribution: mdk, rh
Posts: 11

Rep: Reputation: 0
what u need is to grant the mysql user rights to access the uber database
grant all on uber.* to mysql@localhost
Old 07-29-2003, 04:55 PM   #5
Registered: Jul 2003
Posts: 33

Original Poster
Rep: Reputation: 15
When I type in the following command that u gave me:
grant all on uber.* to mysql@localhost

I get the error that grant: command not found

Are you sure thats the right command?
Old 07-29-2003, 05:49 PM   #6
LQ Newbie
Registered: Jul 2003
Location: tokyo
Distribution: cat in the REDHAT
Posts: 9

Rep: Reputation: 0
I always use webmin to setup MySQL databases. It is quite a bit easier:
Old 07-29-2003, 06:05 PM   #7
Senior Member
Registered: Apr 2003
Location: Eire
Distribution: Slackware 12.0, OpenSuse 10.3
Posts: 1,120

Rep: Reputation: 45
Have you logged into mysql before you try the grant command?

typed in



don't forget a ; at the end

Wondering if the mysql user you originally create was a system user for mysql to run as nah forget that you logged in as them, duh!!

Last edited by Looking_Lost; 07-29-2003 at 06:09 PM.
Old 07-30-2003, 12:33 AM   #8
Registered: Jul 2003
Posts: 33

Original Poster
Rep: Reputation: 15
Well, thanks for the replies, but i read the manual and i knew it was an issue with user permissions. And i was just havin trouble with it. But ir ead the manual thoroughly and heres what i came up with :

mysql> GRANT ALL PRIVILEGES ON *.* TO username@localhost

make sure u login to mysql first, and can issue commands to the mysql program (yes it may be simple to u gurus, but to us newbies it's a pretty difficult task )


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
Grant Privileges - MySQL Jannyno Linux - General 2 06-23-2012 02:00 AM
grant user access to /fat-c & copying users' preferences to another user n0x Linux - Newbie 1 07-04-2004 12:04 AM
Why mysql GRANT does not work? robertoneto123 Linux - Software 2 01-23-2004 07:33 AM
mysql grant issues Robin01 Linux - Newbie 1 10-29-2003 09:56 PM
MYSQL GRANT etc etc markopolox Programming 8 09-23-2003 02:58 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 01:31 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