Remotely connecting into MySQL running on an Ubuntu Digital Ocean Node with JMeter locally
I’m trying to remotely connect to MySQL which has been installed on an Ubuntu VM in Digital Ocean. I have edited the my.cnf file as described on the MariaDB website
bind-address = VM ip address
Ran this command in MySQL within the VM
GRANT ALL PRIVILEGES ON . TO ‘root’@'VM IP ADDRESS’ IDENTIFIED BY 'MY PASSWORD’ WITH GRANT OPTION;
& added the database URL within J-Meter as follows
However, when I run the JMX file I cannot get a connection to the VM in Digital Ocean
Any suggestions please?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.