Hi Todd Thanks..
I checked and did like.. from root mysqladmin shutdown and then again.. restarted the server from.. /etc/rc.d/init.d/mysqld start but of no use! --- As suggested by: Gerald Clark <[EMAIL PROTECTED]> FROM babul USER.. i can not go to /var/lib/mysql where all the databse directries/files are created.. so I hv changed teh dir/file perms of of /var/lib/mysql/*.* to 777!! and now its working.. when i execute $mysql -u nedfi -pnedfi2001 nedfi I get the mysql> prompt!! lets see if I can do other works.. Thanks Gerald Clark !! for ur suggestion.. any idea or comments? Babul --- Todd Williamsen <[EMAIL PROTECTED]> wrote: > I think I read somewhere about this issue. I think > it had to do with > multiple mySQL servers running concurrently. > > See if there is multiple servers running using the > ps command. If so, > then kill one of them. Also, when adding a user, do > you select a > database first before adding a user? > > -----Original Message----- > From: b g [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 13, 2002 2:35 AM > To: Sherwin T. Ang > Cc: [EMAIL PROTECTED] > Subject: Re: mySQL connection problem!!! > > > Hello Sherwin, > > Thanks for ur prompt reply. > > Yes, I have gone thru the mySQL manual chapter that > you have mentioned.. > > But what I think the problem is somewhere else.. > > when I try to execute the command 'mysql' (when I > log > in as user 'babul') on command line, I get the > following error: > > ERROR 2002: Can't conect to local MySQL server > through > socket '/var/lib/mysql/mysql.sock' (111) > > It seems that the mySQL server is not running on the > system... where as when I in superuser mode or login > thru mysql user, I get just the "mysql>" prompt..!! > > This is my first time with mySQL.. I m actually > trying > to restore a web database into my loca machine.. > then > update it locally and later withh restore it to the > web server.. > > Babul > > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __________________________________________________ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php