List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:July 3 2007 6:03am
Subject:Re: permissions on mysql db
View as plain text  
Thank u krishna.

On 7/3/07, krishna chandra prajapati <prajapatikc@stripped> 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 < anandkl@stripped> 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 <prajapatikc@stripped > 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 <anandkl@stripped> 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
> > > >
> > >
> > >
> >
>

Thread
permissions on mysql dbAnanda Kumar28 Jun
  • Re: permissions on mysql dbkrishna chandra prajapati3 Jul
    • Re: permissions on mysql dbAnanda Kumar3 Jul
      • Re: permissions on mysql dbkrishna chandra prajapati3 Jul
        • Re: permissions on mysql dbAnanda Kumar3 Jul
Re: permissions on mysql dbAnanda Kumar28 Jun