I add a user on Application server using "useradd" command.
/usr/sbin/useradd shantanu
This user can connect to mysql service using the following command...
mysql -h 10.10.10.111 -uroot -proot@123
I want this user to not to be able to connect to production mysql DB hosted on 10.10.10.111 I could use firewall protection, but I do not have root access to 10.10.10.111 I need some users to be able to connect to mysql hosted on 111 and some users should not be able to do so. Is there an easy way to do this apart from using jail ?