How to do a command line test of a connection remotely

[malaga]

hello dear Armbian-experts, 

 

 

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

 

some examples:  Lemme give soom Examples; let us take for example, in the preceding step, you could use fooDatabase.fooTable instead of fooDatabase.

 

 

what do you say..!? 

[martinayotte]

3 minutes ago, malaga said:

what do you say..!?

I don't see anything here related to Armbian ...

[lanefu]

hello dear Armbian-experts, 
 
 
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.11Enter password:Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 17Server version: 5.0.45 Source distributionType '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. 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. 
 
some examples:  Lemme give soom Examples; let us take for example, in the preceding step, you could use fooDatabase.fooTable instead of fooDatabase.
 
 
what do you say..!? 

Try stack overflow or a forum in your native languages for questions like this


Sent from my iPad using Tapatalk