CentOS 6.2 64 bit , Mysql Another Problem ~

alphomse

New member
Joined
Mar 15, 2012
Messages
2
i have install 2 times as new servers today, all is working well without mysql, i found as so long but still dont know how to fix this.....

after install finished, mysql dont wake and i try .....

[root@s1 lib]# service mysqld restart
ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/s1.domain.com.pid).

1) i have try copy my.cnf ( dont have this file at /etc/ , just only my.cnf.old & my.cnf.rpmsave ), dont work :(

2) i have try :
[root@s1 lib]# ln -sf /usr/lib64/libexpat.so /usr/lib/libexpat.so
[root@s1 lib]# ln -sf /usr/lib64/libm.so /usr/lib/libm.so
[root@s1 lib]# ln -sf /usr/lib64/libssl.so /usr/lib/libssl.so

, dont work too :'(

anyone know how to fix this ..... >.<
 
ya. thank you , i found at http://help.directadmin.com/item.php?id=368 too :)

but after installed get other problem :(

next error :
http://help.directadmin.com/item.php?id=368

[root@s1 mysql]# service mysqld restart
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL. ERROR! Manager of pid-file quit without updating file.

log :
120316 10:10:31 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
 
Googling that error didn't help me and probably won't help you either.

Where did you get your my.cnf file from?

I use one called my-large.cnf. I copy it over any default with these commands:
Code:
cd /etc
cp -f /usr/share/mysql/my-large.cnf ./my.cnf
service mysqld restart
Doing that and then restarting mysql may help. Does it?

Note that this may not be the best configuration file for you.

Jeff
 
Back
Top