Re: Installing Mysql on 9.0

["Eduardo A. dela Rosa" <EAdelaRosa@xxxxxxxxxxxx>]

On Fri, 2003-10-17 at 02:24, Dali Islam wrote:
> After I ran the command from the
> /usr/loca/mysql/sql-bench folder "perl run-all-tests"
> I got the following error:
>
> GOT error: 'Can't connect to local MySql server
> through socket '/var/lib/mysql/mysql.sock' (2) when
> connecting to DBI:mysql:database=test;host=localhost
> with user: '' password" ''

Go check and edit the /etc/my.cnf:

1.  look for the line that contains the following:
    [client]
    port    = 3306
    socket = /var/lib/mysql/mysql.sock

    [mysqld]
    port    = 3306
    socket = /var/lib/mysql/mysql.sock

2.  in both section (client & mysql) replace the value of socket to:

    socket = /tmp/mysql.sock
   
3.  try running the mysqld (folder /usr/local/mysql/bin should be in your $PATH)
4.  then check the file /tmp/mysql.sock (it should exist)
5.  your "run-all-test" should post no problem.

Cheers!

-- 
EDUARDO A. DELA ROSA
MCOM/2414
http://www.smart.com.ph

"Anyone who has never made a mistake has never tried anything new."
-- Albert Einstein