Error 2002

[Titam]

Hi, i have this problem following a command line (trying to change charset with
mysqld --default-character-set=latin1 \
--default-collation=latin1_swedish_ci
)

and now, when I try to start mysqld :

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

When i try to start mysqld, log file says :

051017 14:23:11 mysqld started
051017 14:23:11 mysqld ended

051017 14:23:41 mysqld started
051017 14:23:41 mysqld ended

051017 14:24:01 mysqld started
051017 14:24:01 mysqld ended

051017 14:24:11 mysqld started
051017 14:24:11 mysqld ended

051017 14:25:01 mysqld started
051017 14:25:01 mysqld ended

051017 14:25:11 mysqld started
051017 14:25:12 mysqld ended

and mysqld-safe :

/usr/bin/mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/serveur2.hollinae.com.pid
051017 14:33:23 mysqld ended

Same things when I try to start just mysql

 

[Titam]

Problem solved : reinstall of mysql ... but i would like to change my char set and i don't know how to do :'( I have some problems with export / import with char é è à etc.

 

[DirectAdmin Support]

Hello,

Adding the settings in your /etc/my.cnf (which may need to be created):

[mysqld]
default-charset=latin1

Or, if you're trying to follow this:
http://dev.mysql.com/doc/refman/5.0/en/charset-server.html
Make the changes to the boot script:

/etc/init.d/mysqld
(or /usr/local/etc/rc.d/mysqld on FreeBSD)

John

 

[Titam]

Hi, I tried, but look :

[root@serveur2 scripts]# vi /etc/my.cnf

I had this : [mysqld] default-charset=latin1

[root@serveur2 scripts]# service mysqld start
Starting MySQL................................... [ÉCHOUÉ]

so ... I commented default-charset etc ...

[root@serveur2 scripts]# service mysqld start
Starting MySQL................................... [OK]


:'(

 

[DirectAdmin Support]

Check your /var/lib/mysql/<hostname>.err file. (Where <hostname> is your hostname.