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

Problems with the Windows version of XAMPP, questions, comments, and anything related.

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

Postby Bren » 15. March 2008 23:16

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
Bren
 
Posts: 4
Joined: 17. February 2008 18:29
Location: Northampton

Postby Wiedmann » 15. March 2008 23:28

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?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Bren » 16. March 2008 00:44

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
Bren
 
Posts: 4
Joined: 17. February 2008 18:29
Location: Northampton


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 66 guests