Results 1 to 3 of 3
Thread: How to hidden mysql database
Enjoy an ad free experience by logging in. Not a member yet? Register.
How to hidden mysql database
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...
- Join Date
- Nov 2007
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;
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;