Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Running a minimal Centos 6.0 build as a vagrant box, with SELINUX=permissive. Right off the bat, performing a "yum install mysql-server" and then "service mysqld start" it fails.

Inside /var/log/mysql.log we have the following--

130815 10:47:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130815 10:47:32 [Warning] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
130815 10:47:32  InnoDB: Initializing buffer pool, size = 8.0M
130815 10:47:32  InnoDB: Completed initialization of buffer pool
130815 10:47:32  InnoDB: Started; log sequence number 0 44233
130815 10:47:32 [ERROR] Can't start server : Bind on unix socket: Operation not permitted
130815 10:47:32 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
130815 10:47:32 [ERROR] Aborting

130815 10:47:32  InnoDB: Starting shutdown...
130815 10:47:38  InnoDB: Shutdown completed; log sequence number 0 44233
130815 10:47:38 [Note] /usr/libexec/mysqld: Shutdown complete

130815 10:47:38 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

I've googled and googled on this and am quite stuck. Can anyone help?

Thank you

share|improve this question
1  
ps -waux |grep -i 'mysqld' - is it running already? –  thinice Aug 15 '13 at 16:40
1  
Please post your my.conf –  TheFiddlerWins Aug 15 '13 at 16:47
    
we need to see your my.conf, almost sounds like mysql user can't create files to expected locations, i.e. socket file –  AngryWombat Aug 15 '13 at 22:55
add comment

2 Answers

This was happening due to a misconfiguration in the installed /etc/my.cnf. It was placing the socket and pid files inside /var/lib/mysql when the pid needed to be in /var/run/mysqld and the socket in /

share|improve this answer
add comment

You may check your mysql server status using

chkconfig mysqld

start your mysql server using root user.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.