mysql'da turkce karakter problemi yaşıyordum.
http://forum.iyinet.com/sql-mysql-a...-1-x-ve-turkce-karakter-sorununun-cozumu.html
adresine girdim, server sahipleri icin yazan yerdekileri yaptım.
ssh de bu iki komutu girdikten sonra mysql acılmaz hale geldi:
Kod:
/usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --default-character-set=latin5 --pid-file="$mypidfile" >/dev/lisanssız 2>&1 &
nasıl duzeltebileceğim hakkında hicbir fikrim yok... roottaki tum işlerimlerim şu şekilde:
Kod:
[[email protected] ~]# locate etc/init.d/mysqld [[email protected] ~]# /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 070228 03:57:45 mysqld ended [[email protected] ~]# nano etc/init.d/mysqld [[email protected] ~]# locate my.cnf [[email protected] ~]# whereis my.cnf my: /etc/my.cnf [[email protected] ~]# nano /etc/my.cnf [[email protected] ~]# service httpd restart Stopping httpd: [ OK ] Starting httpd: [ OK ] [[email protected] ~]# service mysqld restart MySQL PID file could not be found! [FAILED] Starting MySQL....................... .. [1]+ Stopped service mysqld restart [[email protected] ~]# service mysqld stop MySQL PID file could not be found! [FAILED] [[email protected] ~]# service mysqld start Starting MySQL................................... [FAILED] [[email protected] ~]# /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 070228 04:04:38 mysqld ended [[email protected] ~]# --default-character-set=latin5 --pid-file="$mypidfile" >/dev/lisanssız 2>&1 & [2] 5503 [[email protected] ~]# service mysqld start Starting MySQL................................... [FAILED] [2]- Exit 127 --default-character-set=latin5 --pid-file="$mypidfile" >/dev/lisanssız 2>&1 [[email protected] ~]# nano /var/run/mysqld/mysqld.pid [[email protected] ~]# /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --default-character-set=latin5 --pid-file="$mypidfile" >/dev/lisanssız 2>&1 & [2] 5683 [[email protected] ~]# service mysqld start Starting MySQL................................... [FAILED] [2]- Exit 1 /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --default-character-set=latin5 --pid-file="$mypidfile" >/dev/lisanssız 2>&1 [[email protected] ~]#
-------------
MySQL Version: 4.1.21