Chris Green wrote:

I'm having trouble getting started with mysql.

I had a bit of a problem getting it installed but I've got through that now, I downloaded the latest Slackware package file and replaced my existing (screwed up) installation and the basics seem to be working.

I have installed mysql version 4.0.22 and the mysqld daemon is up and running OK. The root mysql user works OK and I can create databases etc. etc.

However I seem quite unable to create any more users that actually work, whatever I do I get permission errors. E.g. I have created a user 'chris' with 'GRANT ALL ON *.* TO chris' and if I run mysql as chris and try and create a database I get:- ERROR 1044: Access denied for user: '@localhost' to database 'chrisdb' Similarly if chris tries to use an already existing database:- ERROR 1044: Access denied for user: '@localhost' to database 'fred'

The entries in the mysql database look OK:- +-----------+-------+------------------+-------------+ | host | user | password | create_priv | +-----------+-------+------------------+-------------+ | localhost | root | 035974c000be6930 | Y | | server | root | | Y | | localhost | | | N | | server | | | N | | % | chris | | Y | | % | lucy | | Y | +-----------+-------+------------------+-------------+

So what's wrong? I'm stuck.

The grant that I generally use, which seems to work is: grant all on databasename.* to user@localhost identified by 'password'

Did you actually mean to create the user with no password?

Hope that helps

Dave

Chris Green writes:

However I seem quite unable to create any more users that actually work, whatever I do I get permission errors. E.g. I have created a user 'chris' with 'GRANT ALL ON *.* TO chris' and if I run mysql as chris and try and create a database I get:- ERROR 1044: Access denied for user: '@localhost' to database 'chrisdb' Similarly if chris tries to use an already existing database:- ERROR 1044: Access denied for user: '@localhost' to database 'fred'

IIRC, GRANT ALL ON *.* TO chris .. is the equivalent of GRANT ALL ON *.* TO chris@'%' .. ie allow chris access to all databases from any machine, so that bit looks right (although rather insecure...)

I think that the error message is the clue: user '@localhost' suggests that you're not trying to connect as user chris. Which I think means that you're confusing mysql usernames and Linux users.

Try (logged in to Linux as any user): mysql -uchris or mysql -uchris fred

You don't say how you're connecting, but that's the key.

NB: I would recommend GRANT ALL ON *.* TO chris@localhost IDENTIFIED BY 'mypassword' and mysql -uchris -p fred .. which prompts for the password, or: mysql -uchris -pmypassword fred

Substitute localhost for '%' if you really mean any host.

Also, note that "GRANT ALL ON" really only grants most access rights - user "chris" won't be able to assign access rights to others. Use "GRANT ALL, GRANT OPTION ON".

This kind of thing is particularly relevant if installing something like phpMyAdmin (well recommended); you can't use phpMyAdmin to define users unless you give it the grant option, and if you allow worldwide rights without passwords (instead of just localhost with password) you're asking for trouble :-)