Find the answer to your Linux question:
Results 1 to 3 of 3
Hi all, I am configure mysql database in redhat linux 6. how can i hide specific database in mysql server and give view for specific ipaddress for my client machine......
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined! prabahar's Avatar
    Join Date
    Jan 2013
    Location
    Tamilnadu,India
    Posts
    10

    How to hidden mysql database


    Hi all,
    I am configure mysql database in redhat linux 6. how can i hide specific database in mysql server and give view for specific ipaddress for my client machine...

  2. #2
    Just Joined!
    Join Date
    Nov 2007
    Posts
    5
    Hello.

    User security in MySQL is granted to specific IP addresses to specific users, or you can grant permissions to a user to any IP address. For example if you want to give permissions to user johndoe to the database dbtest from the 192.168.0.10 IP , you should type the following command:

    GRANT ALL PRIVILEGES ON dbtest.* TO 'johndoe'@'192.168.0.10'
    -> IDENTIFIED BY 'passwordd' WITH GRANT OPTION;

  3. #3
    Just Joined! msohail's Avatar
    Join Date
    Nov 2011
    Posts
    47
    Quote Originally Posted by prabahar View Post
    Hi all,
    I am configure mysql database in redhat linux 6. how can i hide specific database in mysql server and give view for specific ipaddress for my client machine...
    You might want to try this.

    Code:
    create user 'username'@'UserIP_Address';
    update mysql.user set password = PASSWORD('some-password') where user = 'username' and host = 'UserIP_Address';
    grant select on database_Name.* to 'username'@'UserIP_Address';
    flush privileges;
    Jazak Allah
    Sohail

  4. $spacer_open
    $spacer_close

Posting Permissions

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