Page 1 of 1

Unable to create a new user on MySQL - Table is read only

PostPosted: 15. March 2008 23:16
by Bren
Hello
I recently installed XAMPP which provided phpMyAdmin - 2.11.4 and MySQL client version: 5.0.5 and is running on Windows Vista.

I am logged in as 'root@localhost' on PHPMyAdmin and have tried to create a new user for a new database (wordpress).

However I only get the following:
#1036 - Table 'user' is read only.

Can anyone please suggest how I can do this?? Have googled extensively and nothing seems to be leaping out - at least for this version of MySQL....

I am suspecting its something to do with the user that logs into MySQL, but according to privileges, this should be able to do everything.... ?

Can anyone help me?

Many thanks
Brenda

PostPosted: 15. March 2008 23:28
by Wiedmann
Windows Vista.

UAC is disabled for the XAMPP dir?

#1036 - Table 'user' is read only.

What's about the file attribute "read only" (in Explorer) for the files in the XAMPP dir?

PostPosted: 16. March 2008 00:44
by Bren
Thanks for that. It must have been the UAC setting.

By turning it off - I can now create a user. Yay!

I had already check that folder was not 'read only' but there had to be something else.

Vista definitely makes life hard for users.

Thanks very much for your help.
Brenda