8

How to properly kill MySQL?

view full story
linux-howto

http://serverfault.com – I have CentOS 64bit with CPanel installed and I use service mysql stop However, it keeps doing ..... for minutes and it never stops. It used to be instant. Any idea why it does that and how to fix? Right now I have to do killall -9 mysql but is there a better way? The server is also very very active. (HowTos)

dayu's picture
Submitted by dayu on 03/06/2013 – Made popular on 03/06/2013

Stories similar to How to properly kill MySQL?

phpmyadmin problem 2 years 47 weeks ago

Hi all,

I have installed phpmyadmin3.3 in my server. here my php package versions.

php-mysql-5.2.10-1.el5.centos php-common-5.2.10-1.el5.centos php-ldap-5.2.10-1.el5.centos php-cli-5.2.10-1.el5.centos php-imap-5.2.10-1.el5.centos php-xmlrpc-5.2.10-1.el5.centos php-pgsql-5.2.10-1.el5.centos php-5.2.10-1.el5.centos

I installed Percona mySQL on my fresh CPanel server (no databases yet) according to: http://www.ecommy.com/linux/install-...el-environment

Everything seemed to be OK and the server also starts fine, except some commands return this error:

root@server [/var/lib/mysql]# mysql -A -sN information_schema -e "select * from user_statistics;" mysql: unknown variable 'innodb_file_per_table=1'

root@serve

I'm having trouble with a CentOS server running on AWS. This is CentOS 5.6 i386 from RightImage, but the problem was the same on all RightScale AMIs.

When issuing the following command:

yum install mysql mysql-server mysql-devel

the only packages proposed by yum are MySQL-devel-community and MySQL-server-community.

I am using godaddy's dedicate server to host my web application, it's centOS 5(I have no idea why they are still using this.), I installed mysql in that server, everything was running OK since one day I got an report saying that the web application cannot connect to mysql, I checked and found out that mysql crashed, after restarting mysql, everything worked again.

Hi all,

I installed centos 5, with LAMP. httpd is working fine, ssh, ftp all working ok.

But, when I try to use mysql its not,

when I give the command

Code: mysql I get

Code: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Remove services from upstart 45 weeks 4 days ago

I have mysql installed (from repos) on a development machine (laptop) and I don't need the daemon running on every boot. I've copied /etc/init/mysql.conf to /etc/init/mysql.conf.old and then removed everything following the "start on" line.

Is this possible at all? I have installed the php 5.4.5 from the remi repositories on my CentOS installation, however, it seems that the PHP MySQL library isn't the same as my MySQL library.

The error: Your PHP MySQL library version 5.0.92 differs from your MySQL server version 5.5.25a.

I really did it this time.. I deleted a database named MySQL in my server. Shortly after MySQL went haywire and now I cannot login as a user to mysql, I cannot re-install mysql, I get an error for every solution I try.

So I decided hell with it I'll remove mysql, php and start again. I used rpm -qa | grep mysql but it returned nothing.

Mysql error on Centos 5 45 weeks 1 day ago

MySQL server runs out of the box, so selinux is not the problem.Is sounds more like mysql-server was not installed or service mysqld was not started.Since the OP never bothered to respo... [by gerald_clark]