Hi Everybody, The user which has been created with all previleges on all db, will only work from the client machine only. If you want to access from the mysql database server you have to create a user "grant all privileges on *.* to '%'@'localhost' identified by password". I hope this should work.
Regards, Krishna On 6/28/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi All, I have created a user and grant all previlages on all db and the user can connect from any machine with in the same doiman. Now, when i login from a mysql client machine, i am able to see all the databases, but when i login directly from the mysql database server, I am able to see only the information_schema and test database. Should i grant any more previlages for the user to see all the database , when connected directly from the mysql database server. regards anandkl
