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.

I am trying to install this application named socialengine and all is going well except on the mysql screen i keep getting this error

 The MySQL storage engine is not installed. 

I notice my sock file is here

mysqld --verbose --help | grep ^socket
110602 10:06:06 [Note] Plugin 'FEDERATED' is disabled.
socket                            /var/run/mysqld/mysqld.sock

So it appears to be running

So reading online i thought i can resolve this by adding this to my vim /etc/mysql/my.cnf file

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0


[mysqld]

key_buffer = 224M
sort_buffer_size = 4M
read_buffer_size = 4M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 12M
query_cache_size = 44M
default-storage-engine=innodb

basically I added the last line and then

 service mysql restart

but what happens is after i restart I now get this error that cant find my sock

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

what happen....and how do i address this

Update after running

ps axf | grep [m]ysql
 5056 ?        S      0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables --skip-networking
 5189 ?        Sl     3:57  \_ /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --skip-grant-tables --skip-networking --pid-file=/var/lib/mysql/li317-112.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
10832 ?        Ssl    0:00 /usr/sbin/mysqld
share|improve this question
    
Can you check if it is actually running with ps axf | grep [m]ysql? –  slillibri Jun 2 '11 at 19:04
    
You might also want to check the logs. In Ubuntu, I believe you're looking for /var/log/mysql.log or mysql.err. –  Jack M. Jun 2 '11 at 19:07
    
updating my answer with the return –  Matt Jun 2 '11 at 19:10
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.