Thank u krishna. On 7/3/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote:
Hi, Yes, it is possible. the command i have given in my previous email will make u to connect from mysql database server. The command below will make you to connect from the client computer The command is " grant all privileges on *.* to 'user1'@'192.169.6.%' identified by password" The command below will make you to connect from the mysql database server The command is " grant all privileges on *.* to 'user1'@'localhost' identified by password" By giving this command the new privileges will not overide the old privileges. Regards, Krishna On 7/3/07, Ananda Kumar < [EMAIL PROTECTED]> wrote: > > 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 > > > > > > > >
