I found the mysql.sock under the tmp folder! I ran the mysqld program and saw error saying another mysql might be running. So I did ps -ae and found the follwoing 3056 ? 00:00:00 mysqld_safe 3088 ? 00:00:00 mysqld I tried to kill them but it's not going away. >>kill 3056 >>kill 3088 --- "Eduardo A. dela Rosa" <EAdelaRosa@xxxxxxxxxxxx> wrote: > 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 > __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
