What you need to look at the running processes in your MySQL Amazon Web Services RDS Database to use this:
- A MySQL command line client installed on your Windows machine
- An Amazon Web Services RDS MySQL instance
- A user/admin account on the MySQL instance
First you need to assign yourself process privileges on the database with your sql client (I use Toad):
grant grant process on *.* to myusername;
Then you can look at the processes using the command in a windows command line client, this assumes you have mysql in C:\Program Files (x86)\MySQL\MySQL Server 5.7:
“C:\Program Files (x86)\MySQL\MySQL Server 5.7\bin\mysql.exe” -h my.amazon.rds.url -P 3306 -u myusername -p mydatabasename
The first part is the path to mysql.exe file, which is standard when you install mysql to your pc (if you’re using windows. If not, this won’t work)
“C:\Program Files (x86)\MySQL\MySQL Server 5.7\bin\mysql.exe”
The second part is where you’re telling mysql to login to our database remotely. You need to change the my.amazon.rds.url to your own, and myusername part to your username
-h my.amazon.rds.url -P 3306 -u myusername -p CCMCBA
You’ll be asked for your password, then you should see mysql>
Type this in:
mysql> show full processlist;
You’ll see something like this:
+—-+———-+————————————-+——–+———+——
+——-+———————–+
| Id | User | Host | db | Command | Time
| State | Info |
+—-+———-+————————————-+——–+———+——
+——-+———————–+
| 2 | rdsadmin | localhost:51113 | NULL | Sleep | 9
| | NULL |
| 17 | myusername | ipmyipaddress | CCMCBA | Query | 0
| init | show full processlist |
+—-+———-+————————————-+——–+———+——
+——-+———————–+
2 rows in set (0.09 sec)
“rds admin” is probably someone or something in the admin console, and myusername is my connection in the mysql command line client, with my ip address.