Hello dear all,
How to do a command line test of a connection remotely
well - there are several ways to test the DB connection remotely, while the access of the MySQL server from another Linux® server.
See - for example the following - that uses 184.108.40.206 as the IP address of the MySQL server:
# mysql -u fooUser -p -h 220.127.116.11 Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 17 Server version: 5.0.45 Source distribution
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
When you set up a remote user, consider the following information:
A local user is of course very very different from a remote user.
For example, we can say [email protected] is not the same as [email protected] If we will want both users to have the same permissions, we need to duplicate permissions. Well we have to admit that it is a fact that we cannot recommend granting ALL permissions. This would be very stupid - especially for standard users, we recommend granting GRANT SELECT,INSERT,UPDATE,DELETE permissions. Honestly - to speak frankly: To grant access to only a specific table, we can use the database.table command.
Lemme give soom Examples; let us take for example, in the preceding step, you could use fooDatabase.fooTable instead of fooDatabase.