Thread: 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...

login to mysql as root user:

mysql -u root -p
use mysql;
grant all privileges on yourdatabase.* to youruser@'IPADDRESS' identified by 'password';
flush privileges

That should do the trick.

Originally Posted by prabhu_rhce

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...

Originally Posted by prabhu_rhce

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...

HI
login to mysql root by mysql -u root -p and give password

1.First create the database with grant all permission(eg here i have used SUSHILA1 as project name)
mysql> create database sushila1;
mysql> grant all privileges on sushila.* to sushila@'%'identified by 'sushila';

2..Now revoke select permission to specific database to all user.. so that now one can view that database
mysql> revoke select on sushila1.*from sushila@'%' identified by 'sushila';

3.Now give grant select permission to specific ip address (client machine) alone so that only he can view
mysql> grant all privileges on sushila1.*to sushila@'192.168.1.200' identified by 'sushila'; (here 192.168.1.200 is ip address of clent machine)


see you can view database name but not tables in above method.. If it is working for you reply me..