to make it easy to check MySQL or RDS MySQL database built in ECS server, a MySQL test script is written, which can be detected when a friend is unfamiliar with command line operation. Script:http://jinxiang.oss-cn-hangzhou.aliyuncs.com/mysqltest_gbk.sh
Script Execution methods:wget http://jinxiang.oss-cn-hangzhou.aliyuncs.com/mysqltest_gbk.shchmod 755 mysqltest_gbk.sh./mysqltest_gbk.shDemo:1, enter MySQL related information:here to connect RDS, so account using RDS account, address also use RDS domain name, password input does not display, is normal.
when the correct information is entered, a list of features is displayed:
2, display data table:Selecting the first item "show datasheet" will automatically list the database, and then selecting the database will list all the tables in the corresponding library, the jinxiang_db library is selected in the example, you can see that there are 3 tables
3, creating test tables and deleting test tables:The test table is automatically created when the function is selected and the table is named Test_script_table
You can then view the results by displaying the data table, repeating the creation will find that the table already exists, deleting the test table and then deleting the action will also prompt:
4, display the list of connections:Select the corresponding function can display the current number of connections, test account because there is no access pressure, the list is not displayed, here in order to test the database was deliberately insert operation, you can see the query queue.
Select "Connection Statistics" will be grouped by account number of connections, here only with the root account statistics will be listed in each account group, because RDS does not have a root account, so only display the current account.
5, permission checkingbecause the permission check requires a root account, this is connected to the MySQL test inside the ECS:you can see that MySQL inside the ECS can be called remotely.
Linux system MySQL Connection check script
