Hi Krishna, If i execute a new grant statement, then the new previlage will over ride the old previlage, if this happens, then i will not be able to connect from other client machines. I want to connect from client also from the local host. Is this possible.
regards anandkl On 7/3/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote:
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 >
