vicidial.org

Hi Guys,

I already installed MySql 5.0.45 in Slackware 12.1.

While in cpan prompt and run this command "force install DBD::mysql", It prompted me a lot of error, pls find below:

failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at t/40server_prepare.t line 16
t/40server_prepare_error....skipped: ERROR: DBI connect('test;mysql_server_prepare=1','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at t/40server_prepare_error.t line 18
t/40types...................skipped: ERROR: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). Can't continue test
t/41bindparam...............skipped: ERROR: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). Can't continue test
t/41blobs_prepare...........skipped: ERROR: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). Can't continue test
t/42bindparam...............skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at t/42bindparam.t line 13
t/50chopblanks..............skipped: ERROR: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). Can't continue test
t/50commit..................skipped: ERROR: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). Can't continue test
t/55utf8....................skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at t/55utf8.t line 18
t/60leaks...................skipped: Skip $ENV{SLOW_TESTS} is not set
t/65types...................skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (

How can I resolve this problem. Pls advise.

Regards,

it looks like a test connection initiated by the perl module, i got that too when installing the DBD::Mysql module. Also you could check if you have the mysql client libraries installed.

hi codehaxor,

thanks for your prompt reply.

sorry im newbie in installing mysql, how can I check if i have mysql client lib installed. If i don't have it, how can i get that..im really sorry this is my first time to install mysql.

your advice is highly appreciated.

regards,

hello everyone,

My problem was resolved already.

Since the mysql.sock was missing in tmp folder (ERROR 2002), so what i did i just copy the mysql.sock file from /var/lib/mysql/ and supplied this command ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock. After that I start mysql (/usr/local/mysql/bin/mysqld_safe --user=mysql &) run (/usr/local/mysql/bin/mysql) and it works!

However, how to automatically start my mysql??? I noticed that everytime i restarted my server, i have to manually start it. Pls advice.

regards,

cire_08,

Following the scratch install, you will come to entries for rc.local. There it is explained how to do what you asked.

Regards

devafree

Hi devafree,

Thanks for your advice.

I’ll definitely check that tomorrow.

regards