Birju, Here's a little Linux/Unix info for you. The "/tmp/mysql.sock" in question is used for ipc (Inter Process Communication). This allows other applications to communicate with the mysql server without using a "TCP/IP" connection. This eliminates the need to pass everything through the networking code.
In the post below, the person is having problems when trying to connect through the network layer. It would be like changing your database connect string to DBI connect('database=search;host=192.168.1.5','web',...). As far as the 1045 error, it does not look like you typed everything correctly. What is the "-number" supposed to be? walt On Wednesday 14 January 2004 05:03 am, you wrote: > Hello Walt, > > I did and it says the following > > > mysql -u websquash -number > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: > NO) > > One more thing, I just saw that there is someone who has posted a query > where the mysql crashes on freebsd. I am pasting it below > if that can be of help to you taking my situation in consideration. > > ----------------------Some one posted this ---------------- > Hi!On Jan 12, Holm Tiffe wrote:> >Description:> mysqld 4.0.17 crash on > FreeBSD 5.1-current-alpha> >How-To-Repeat:> Any acces over IP (not domain > socket) crashes mysqld:> #/usr/local/bin/mysqladmin: connect to server at > 'install' failed> error: 'Lost connection to MySQL server during query'> > > syslog:> install mysqld[78066]: warning: can't get client address: Bad file > descriptorI suspect it is a an issue of KSE library (either a bug or > someincompatibility with MySQL).Could you run mysqld with libc_r and see if > it helps ?Unfortunately we don't have FreeBSD-5/Alphato try this ourselves. > Regards,Sergei-- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / > Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, > Senior Software Developer/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany > <___/ www.mysql.com-- MySQL General Mailing ListFor list archives: > http://lists.mysql.com/mysqlTo unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] >- ------------------- > > > > > ----- Original Message ----- > From: "walt" <[EMAIL PROTECTED]> > To: "Birju Shah" <[EMAIL PROTECTED]> > Sent: Tuesday, January 13, 2004 12:17 PM > Subject: Re: Mysql Socket Error > > On Wednesday 14 January 2004 04:41 am, you wrote: > > Hello, > > > > When I run the command it gave me this > > > > Command history > > > > > ls /tmp/mysql.sock > > > > /tmp/mysql.sock > > > > > > > > > > Now, how do I execute the client through the command prompt ? > > > > Let me know > > > > Thankyou > > birju shah > > try something like > `mysql -u your_user_name -p` > when it asks for your password, type it in. > > walt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]