![]() Note: I already told you that in the prerequisites section that the remote connection of mysql DB only works if you’ve enabled the incoming connections in the mysql server machine. flush privileges Verify remote database table access on a client system And finally, you may also need to run flush privileges on mysql> prompt. You see the testUser only has remote access to three tables instead of the complete mdc_collector database. To exposed database tables enter the following commands at mysql> prompt.Īfter giving remote access to mysql database tables let’s see the selected grants for testUser with the following query. Now let’s say we want to give access to testUser only billing_data, monthly_billing_data, and load_profile_data tables instead of the complete database. If you guys have seen the above mdc_collector database then you know there are a total of ten tables and we only need to give remote access to some specific tables. You see currently there are no database table grants for the testUser. Grant some specific mysql database tables access to testUserīefore granting remote database tables access lets see the current grants for testUser with the below query. It means our testUser client can connect to mysql database server via any Ip address.Īfter the creation of testUser let’s see all mysql user’s hosts and username with the following query. Please note the % sign in the above command refers to any host. First, let’s create a new mysql user with the following query at mysql> prompt. Now in order to grant some specific database tables access, we need to create a new user (with no grant options) from which our client can access only the exposed tables. ![]() You can create your own database or use your existing database.Ĭreate a new mysql user for remote database access You can see this link for enabling the remote connection in the mysql database server.īelow is the example of my complete mysql database.
0 Comments
Leave a Reply. |