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 --- "Sherwin T. Ang" <[EMAIL PROTECTED]> wrote: > hello, > > regardless on what system user you are, root or > ordinary system user, you > can still connect to the mysql server with MYSQL > ROOT privileges as long as > you know the password of root. Because a SYSTEM ROOT > is different from MYSQL > ROOT user. > > well in the case of your problem, you should read > the GRANT and REVOKE > syntax in the manual to make it clearer. > > http://www.mysql.com/doc/G/R/GRANT.html > > Regards, > > Sherwin T. Ang > Web Technical Administrator / Programmer > Alchemy Solutions > http://www.alchemy.com.ph > Creative. Technology. > > Tridel Technologies, Inc. > 7th Floor Hanston Building > Emerald Ave., Ortigas Center > Pasig City > Philippines > > Tel: (632) 634-5141/ (632) 634-5140 Local 1040 > Fax: (632) 634-5139 > > ----- Original Message ----- > From: "b g" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, March 12, 2002 11:38 PM > Subject: mySQL connection problem!!! > > > > Hello, > > > > I m ina great problem.. > > > > I am not able to conenct to mySQL server.. > > the problem is like.. when I m in root or mysql > USER > > login.. then I can login to mySQL server.. its > fine.. > > but other than 'root' and 'mysql', i can not > connect > > to the database server.. > > > > thats why I am not able to run any web based > database > > connection.. > > > > can u pls explain wht to do now? > > > > I hv created one mysql user using this: > > > > $ su > > passwd: > > $ mysql -u root mysql > > mysql> grant all priviliges on *.* to > user@localhost > > with grant option; > > mysql>\q > > $ > > > > and then i am able to connect.. that too when i > was > > in superuser mode.. else frm other users, i m not > able > > to conenct.. pls help.. > > > > the mysqld is running! > > > > Babul > > in India.. > > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Try FREE Yahoo! Mail - the world's greatest free > email! > > http://mail.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 > > > > > > __________________________________________________ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.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