Help - Search - Members - Calendar
Full Version: i can't modify my.cnf
The Planet Forums > Control Panels > Plesk
atarod
i have this settings on /etc/my.cnf

[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

but if i modify this file maybe adding skip-name-resolve in mysqld, mysql wont start...

my version is:
mysql Ver 14.7 Distrib 4.1.15, for redhat-linux-gnu (i686) using readline 4.3

any ideas? thx
atarod
its version 7.5.4 FedoraCore 3
EvolutionCrazy
have you looked on mysqld.log to see what error it's reporting?
atarod
i have no errors...
it looks like mysqld start ok, but plesk give me an error and i lose conection.

from a php:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

mysql> show databases;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR:
Can't connect to the server

mysql> status
--------------
mysql Ver 14.7 Distrib 4.1.15, for redhat-linux-gnu (i686) using readline 4.3

No connection

just only adding a line like:

key_buffer = 128M

i use mysql 4.1.15 and plesk 7.5.4
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.