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 44.55.22.11 as the IP address of the MySQL server:
# mysql -u fooUser -p -h 44.55.22.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.
mysql> _
some musings:
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 fooUser@localhost is not the same as fooUser@1.2.3.4.5.6.7.8 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.