Unable to create a new user on MySQL - Table is read only
Posted: 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
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