foxpiles

Member
Nov 23, 2005
20
0
151
i've just install whm and cpanel, but i got this message when i try to start mysql service after i uprade mysql into version 5

Code:
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
running on
WHM 10.8.0 cPanel 10.9.0-R94
CentOS 4.4 x86_64 - WHM X v3.1.0

any idea, anyone?
thanks in advance :)
 

katmai

Well-Known Member
Mar 13, 2006
562
2
168
Brno, Czech Republic
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=500
max_connections=1000
interactive_timeout=10
wait_timeout=30
connect_timeout=10
thread_cache_size=96
key_buffer=32M
join_buffer=1M
max_allowed_packet=8M
table_cache=1024
record_buffer=1M
sort_buffer_size=1024K
read_buffer_size=1024K
max_connect_errors=10
thread_concurrency=8
myisam_sort_buffer_size=64M
server-id=1
log-slow-queries
long_query_time = 5

[mysql.server]
user=mysql

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

try putting this into your /etc/my.cnf and then start mysql server
 

foxpiles

Member
Nov 23, 2005
20
0
151
thanks, katmai, but it's still not working.
i try change version into 4.1 and use mysqlup, the 4.1 is working.
but i really need to use 5.0 so i'll have to keep trying.

please help.
 

foxpiles

Member
Nov 23, 2005
20
0
151
solved, thanks guys. :)

for anyone who interest, i comment out basedir in my.cnf and restart mysql. works like charm.
#basedir=/var/lib
 

katmai

Well-Known Member
Mar 13, 2006
562
2
168
Brno, Czech Republic
uhm ... dewd ... this solution was in /etc/my.cnf i gave you ...
 

katmai

Well-Known Member
Mar 13, 2006
562
2
168
Brno, Czech Republic
that thing is barely in alpha release and you want cpanel to make it available so that you could scream about cpanel not doing their job and not fixing something that isn't even in beta yet?
 

Spiral

BANNED
Jun 24, 2005
2,020
8
193
Lose the following lines out of your my.cnf file:

Code:
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
 

BostonDedicated

Registered
Sep 23, 2005
1
0
151
Awesome !

WORKS FOR ME TO!!!

/etc/my.cnf

go down to where you see [mysql.server]

put a # in front of the line that sais basedir=/var/lib
 

Shelly

Registered
Aug 19, 2006
3
0
151
I use
WHM 10.8.0 cPanel 10.8.2-C118
CentOS 4.4 i686 – WHM X v3.1.0

It should be similar as everyone's enviroment.

But it's too easy for me to upgrade MySQL from 4 to 5.

I chose ver 5.0 under WHM>> Tweak Settings >> MySQL, then click Save button. That's it.
It took less than 5 minutes until upgrade is done. Database works fine.

I didn't run /scripts/mysqlup and didn't change /etc/my.cnf
Since my.cnf in my server only has 3 lines:
*****************
[mysqld]
set-variable = max_connections=500
safe-show-database
******************

Why my process is quite different from all of you?

I wonder if my server's setting is too unique, OR I missed something?

Pls give me some advinces.

Thanks in advance