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