For as long as you have root access to MySQL, this would work: 1UPDATE mysql.user SET Password=PASSWORD('new-password-here') WHERE USER='user-name-here' AND Host='host-name-here'; more details from https://www.cyberciti.biz/faq/mysql-change-user-password/

1DROP USER 'yourDBA'@'localhost'

1create database yourDB; 2CREATE USER 'yourDBA'@'localhost' IDENTIFIED BY 'yourPASS'; 3GRANT ALL PRIVILEGES ON yourDB.* TO 'yourDBA'@'localhost'; 4FLUSH PRIVILEGES;

Use format below: 1GRANT ALL ON yourDB.* TO yourDBA@'23.216.39.44' IDENTIFIED BY 'yourPASS'; and make sure that 'bind-address' in /etc/my.cnf is either 0.0.0.0 or commented out for this to take effect. Turn-off as well any firewall, SELinux, etc. Further details in …

If you see an error like the following: 1ERROR 2006 (HY000): MySQL server has gone away 2No connection. Trying to reconnect... 3Connection id: 990 4Current database: yourDB Add the the following to /etc/my.cnf, increasing the value if error persists. 1'max_allowed_packet=64M' See …