Mysql User grant problems

ubers0ldat · 07-27-2003, 05:47 PM

Hey

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:

mysql_select_db('uber');

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..

dkaplowitz · 07-27-2003, 09:53 PM

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 php.net and mysql.com about how to properly access your db.

Good luck.

ubers0ldat · 07-27-2003, 11:25 PM

Yes, i am providing the connection parameters..

mysql_connect('localhost','mysql','password');

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

mysql_select_db('uber');

Any ideas?

piti · 07-28-2003, 03:16 AM

what u need is to grant the mysql user rights to access the uber database
grant all on uber.* to mysql@localhost

ubers0ldat · 07-29-2003, 04:55 PM

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?

ohlssonvox · 07-29-2003, 05:49 PM

I always use webmin to setup MySQL databases. It is quite a bit easier: http://www.webmin.com

Looking_Lost · 07-29-2003, 06:05 PM

Have you logged into mysql before you try the grant command?

typed in

mysql

first

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!!

ubers0ldat · 07-30-2003, 12:33 AM

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 :

http://www.mysql.com/doc/en/Adding_users.html

mysql> GRANT ALL PRIVILEGES ON *.* TO username@localhost
-> IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;

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

)