Error in loading uma.mysql in database

[Rick Cooper]

I use phpmyadmin to facilitate my mysql database. After I created the 'uma' database with admin permission etc. I loaded the 'uma.msql' file to create the tables. However, I got the following:

Error
SQL-query : 
LOCK TABLES uma_challenge WRITE
MySQL said:
Access denied for user: 'user@localhost' to database 'user_uma'

Can someone please help me in rectifiying this error?

[Keith Vance]

MySQL said: Access Denied for user: 'user@localhost' to database 'user_uma'

It sounds like access is being denied to user@localhost to your database user_uma. Check your MySQL permissions and if possible use the MySQL shell to grant privileges; it's easier.

[Anonymous]

I'm getting this same error and I've tried the following for granting privileges:

GRANT ALL PRIVILEGES ON mydatabase.*
TO username@localhost IDENTIFIED BY 'password';

but then I'm given the following error message:

************
Database mydatabase running on localhost
Error

SQL-query :

GRANT ALL PRIVILEGES ON mydatabase. * TO username@localhost IDENTIFIED BY 'password'

MySQL said:

Access denied for user: 'username@localhost' to database 'mydatabase'
************

(I'm using phpMyAdmin for my MySQL database)

Any suggestions?

Thanks,
Nathan

[Ronald Willis]

I have some mysql experience, but from the command. I had some difficulty with the instructions myself and rewrote them for commandline access to a Linux installed MySQL database if you are interested. My weakest area is the PHP implementation for now. I will post upon request.

[Anonymous]

It turned out that on my server I am unable to grant a database user all privileges so I'm not permitted to use the LOCK command. So I removed all of LOCK statements and then it loaded into my database. Things seem to working OK, except that users can't be deleted in the web interface... they have to be manually deleted in the database... but I don't know if that is related to the LOCK commands being removed...