I need to run MySQL service for my linux 2.16 version with SUSE version 11 distribution.Downloaded the following files and installed all the rpms as under:MySQL-server-5.5.27-1.sles11.i586MySQL-client-5.5.27-1.sles11.i586MySQL-devel-5.5.27-1.sles11.i586MySQL-shared-5.5.27-1.sles11.i586MySQL-shared-compat-5.5.27-1.sles11.i586There was no error during installation and I have confirmed the installed packages via:rpm -qa|grep -i sqlBut the server is not getting started when trying to execute through:$> mysqlM getting the following as eror msg:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)I have checked that in the /etc/init.d location, only mysql entry is there instead of mysqld, is this the reason of the server startup error.On googling for hours, I have also tried ./mysql start from the same location but getting the following output:Starting MySQL..The server quit without updating PID file (/var/lib/mysql/ABC2-rahul.pid).I am new to mysql, any help will be appreciated. Thanks in advance.I have cheked and found that some configuration files have been in the /usr/share/mysql loaction, and I have copied my-huge.cnf file to /etc location, any comments ?Following is the content from the same my.cnf file:[mysqld]port            = 3306socket          = /var/lib/mysql/mysql.sockskip-external-lockingkey_buffer_size = 384Mmax_allowed_packet = 1Mtable_open_cache = 512sort_buffer_size = 2Mread_buffer_size = 2Mread_rnd_buffer_size = 8Mmyisam_sort_buffer_size = 64Mthread_cache_size = 8query_cache_size = 32Mthread_concurrency = 8log-bin=mysql-binserver-id       = 1[mysqldump]quickmax_allowed_packet = 16M[mysql]no-auto-rehash[myisamchk]key_buffer_size = 256Msort_buffer_size = 256Mread_buffer = 2Mwrite_buffer = 2M[mysqlhotcopy]interactive-timeout
MySQL not getting started on linux
linux;mysql
Have you tried starting the mysql service? Run this as root:service mysql startor/etc/init.d/mysql start If it still doesn't work try one of the following. All these commands should be run as root:Rename your my.cnf file. That will force mysql to create a new one:mv /etc/my.cnf /etc/my.cnf.oldMake sure your permissions are set up correctly:chown -R mysql /var/lib/mysqlChange /var/lib/mysql to the appropriate path of your mysql installation is somewhere else.The solutions here may also be helpful.