MySQL crashes running but not working [closed]

Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 6 years ago. Improve this question Mysql is running but it not responding when using phpmyadmin when i check mysqld.log it tells: [root@dc /]# tail /var/log/mysqld.log 151111 8:58:21 [Note] … Read more

MySQL : How to lock all write in all databases? [closed]

Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 7 years ago. Improve this question I need to block all writes (insert , update, delete) on all databases. How can I do that ? Put all database in … Read more

High Cpu Usage after MySQL Update (5.1 to 5.5) on CentOS 5.8 (64 Bit)

General Problem: Server load 20.92 (8 CPUs) [it varies from 7 to 40, normally it should be less than 1) Server Specs: Dedicated Server Intel Core i7 (8 Cpus) RAM: 8GB We use WHM and we have about 25 databases (8 are wordpress) most of which are MyISAM. We are using the default MySQL options … Read more

Moving data between drives CentOS 6 + cPanel [closed]

Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 7 years ago. Improve this question Recently, my server crashed. The hosting company has installed new CentOS on a replacement drive and attached the old drive to my server. … Read more

Why can root still login remotly?

I have a very strange issue I’m hoping someone may have seen before and might be kind enough to help me resolve. On MySQL, I took away the ability for the root user to login from any remote host: MariaDB [(none)]> select user, host from mysql.user where user = ‘root’; +——+———–+ | user | host … Read more

MySQL statement [closed]

Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 9 years ago. Improve this question How to create a MySQL statement to check expiry and and deactivate a/c on matched date? desc mailbox; username varchar pass varchar created … Read more

MySQL Configuration on my.cnf [closed]

It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 9 years ago. [mysqld] core-file default-storage-engine=MyISAM max_connections = 5000 max_user_connections = … Read more

Ubuntu Mysql stop working after outofmemory in a clamscan, mysqld.sock

I’m having daily problems with postman with autentification througth mysql on my Ubuntu14LTS Server. I think the problem arrise after a clamscan scron that breaks in an Out of Memory. In some way mysql socket gets break and I can’t read my emails from an email client due to authdaemond auth error, but I can … Read more

Can’t run Apache – Would having Ruby on Rails and mysql server installed on the same machine be the reason why?

everyone. I am trying unsuccessfully to run Apache on my machine. I used the command line to find out all the applications that are using port 80 and I ended them, but Apache refuses to run on my server after that. I have a Ruby on Rails web service and mySQL server 5.5 installed on … Read more