On Wed, 2002-03-13 at 08:08, b g wrote: > 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..
With which user are you trying to connect ? Did you grant permissions to that user ? Be more specific. > thats why I am not able to run any web based database > connection.. i get could not connect to database.. > > can u pls explain wht to do now? > > I hv created one mysql user using this: > > $ su > passwd: > shell> mysql --user=root mysql > mysql> GRANT ALL PRIVILEGES ON *.* TO babul@localhost > -> IDENTIFIED BY 'babul123' WITH GRANT OPTION; > -> \q > $ > > then i am able to connect using the database > user/pass .. that too when i was in super-user mode.. > else frm other users, i m not able > to conenct.. pls help.. > > the mysqld is running! > > Babul > in India.. > -- dsoares (sql) --------------------------------------------------------------------- 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