illegal mix of collations(latin2_general_ci Implicit)and(latin1_s wedish_ci IMPLICIT) for operation"="

2005-01-24 Thread Cecep Rosuludin
Dear All, I found an error in mysql message, when I tried to excute this sql in mysqlfront: select dsr2.mother_vessel,mother_vessel_voy,voyage.voy_aims,voyage.td, poo.loading_port_name,pod.disch_name from dsr2 left join voyage on voyage.voy=dsr2.mother_vessel_voy left join poo on poo.loading_por

Re: Can't connect to local MySQL server through socket'/var/lib/m ysql/mysql.sock'

2004-11-01 Thread Cecep Rosuludin
key_buffer = 16K max_allowed_packet = 1M table_cache = 4 sort_buffer_size = 64K net_buffer_length = 2K thread_stack = 64K server-id = 1 - Original Message - From: ian douglas <[EMAIL PROTECTED]> To: Cecep Rosuludin <[EMAIL PROTECTED]> Subject: Re: Can't connect to l

Re: Can't connect to local MySQL server through socket'/var/lib/m ysql/mysql.sock'

2004-11-01 Thread Cecep Rosuludin
(delete) 2.MySQL-server-4.1.7-0.i386.rpm (I removed by rpm -e ) 3.the third one, I install mysql from Mandrake cd installer - Original Message - From: Spenser <[EMAIL PROTECTED]> To: Cecep Rosuludin <[EMAIL PROTECTED]> Subject: Re: Can't connect to local MySQL server thr

Re: Can't connect to local MySQL server through socket'/var/lib/m ysql/mysql.sock'

2004-11-01 Thread Cecep Rosuludin
Spenser, thanks for respons, I have done what you've ever done. this the result [EMAIL PROTECTED] root]# ps -e | grep mysql [EMAIL PROTECTED] root]# - Original Message - From: Spenser <[EMAIL PROTECTED]> To: Cecep Rosuludin <[EMAIL PROTECTED]> Subject: Re: Can't

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

2004-11-01 Thread Cecep Rosuludin
Dear AlL, my former question is "how to run mysql service". but now i have run mysql service [EMAIL PROTECTED] root]# service mysql start Starting MySQL Server [ OK ] but i still cannot connect to mysql [EMAIL PROTECTED] root]# mysql ERROR 2002: Can'

Re: run mysql service in Linux

2004-10-28 Thread Cecep Rosuludin
ribution directory and follow instructions in it > exactly. > Don't forget about mysql_install_db! > > Regards. > > > "Cecep Rosuludin" <[EMAIL PROTECTED]> wrote: > > dear All Master of Mysql, > > > > I'm new in Mysql, and I&#x

run mysql service in Linux

2004-10-27 Thread Cecep Rosuludin
dear All Master of Mysql, I'm new in Mysql, and I'd just move to mysql Linux version..!and i have problem to activate the service. I have installed Mysql linux ver. with this Command >tar-zxvf mysql-standard-4.0.21-pc-linux-i686.tar when i try to Configure >./configure ,there is a note that i