How to access and test a remote - mysql db connection?

How to access and test a remote - mysql db connection?
0

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 [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.