cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New

How to disable Read Only option for Mysql Server

Hi

How can i disable read only option?

 

When I enter my site, there is problem with database connection: Error displaying the error page: Application Instantiation Error: The MySQL server is running with the --read-only option so it cannot execute this statement...

 

I checked conf file in Joomla directory. Everything is OK. And i ca'nt do nothing in phpMyAdmin.

Please help. How to disable Read Only option for Mysql Server ?

10 REPLIES 10

The same thing happened to the site I manage a day ago,  but resolved itself after a few hours. It has happened again now.

I checked in mysqladmin and the server setting for 'read only' is showing up as 'on'.

 

Hopefully it will resolve itself again, but I would like to know why this happened and how to stop it. 

The server I am on is 166.62.8.13   Are you on the same server? 

Just been chatting to GoDaddy support. Looks other people have been reporting the problem since the 9th.  They are working on it.  No ETA. 

 

10 hours later and they have not resolved the problem.  Not impressed.

I have just chatted with Godaddy support team. They answered that: ‘As per the error that were getting here, we currently have an ongoing issue about MySQL database. Our team is working on it now to fix the issue‘.

Well, it is now over 36 hours and my site is still dead.  Seriously unimpressed.

I am having the same issue...

"SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --read-only option so it cannot execute this statement"

Was working fine at 8:30 EST Friday Nov 11 

Now receiving this error 7:00 EST Sat Nov 12

Also not impressed.

Also checked and Read Only variable set to ON

I will contact GoDaddy.  

 

I have 6-7 sites in this server.

What did I do?
Opened new database.
Copied from SQL my database, witch I backed up 1 months ago (I can't backup current DB).

Edited configuration file of site.

Site is working...
But some of my sites still dead

I don't understand how that worked for you. 

The server has been set to read only, so did you change servers? 

 

Oh, I get it. 

Creating a new database automatically chose a different server without asking!

I am trying your trick now. Thanks for the tip. 

my site keeps doing this 😞 i added a bunch of widgets yesterday to add some more educational tools. is this why?