Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2007
    Posts
    197

    Smile Unanswered: Problem with user name

    Hi,
    I have created a new user and grant only for one database

    grant all privileges on A.* to a@localhost identified by 'a'

    but after some time when i login with this user

    and do show databases;

    it show all databases on this server

    when i do flush privileges commad now this user work fine show only one particular database

    but after while when I login from this user all databases shows

    how can counter this problem ??

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    grant privilieges on the required databases
    MySQL :: MySQL 5.1 Reference Manual :: 12.5.1.3 GRANT Syntax

    eg
    grant all privileges on *.mydatabasename to auser@anipaddressOrhostname identified by 'apassword'

    however I've alwasy found the grant procedure to be a bit of a pain, so tend to do it these days using MySQL Administrator GUI tool, available fromt eh MySQL website as part of the GUI Tools
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2007
    Posts
    197
    Quote Originally Posted by healdem
    grant privilieges on the required databases
    MySQL :: MySQL 5.1 Reference Manual :: 12.5.1.3 GRANT Syntax

    eg
    grant all privileges on *.mydatabasename to auser@anipaddressOrhostname identified by 'apassword'
    I have done the grant only for one database

    grant all privileges on A.* to a@localhost identified by 'a'

    where A is database

    but still after some time with user "a" you can access all databases
    untill you do flush privileges command

    the same process repeats

  4. #4
    Join Date
    Jun 2007
    Posts
    197
    Quote Originally Posted by ankur02018
    I have done the grant only for one database

    grant all privileges on A.* to a@localhost identified by 'a'

    where A is database

    but still after some time with user "a" you can access all databases
    untill you do flush privileges command

    the same process repeats
    Problem is solved I start mysql in safe mode once

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •