atarod
Dec 19 2005, 07:23 PM
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
Dec 20 2005, 02:11 AM
its version 7.5.4 FedoraCore 3
EvolutionCrazy
Dec 20 2005, 02:54 AM
have you looked on mysqld.log to see what error it's reporting?
atarod
Dec 20 2005, 04:40 AM
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.