1create database yourDB; 2CREATE USER 'yourDBA'@'localhost' IDENTIFIED BY 'yourPASS'; 3GRANT ALL PRIVILEGES ON yourDB.* TO 'yourDBA'@'localhost'; 4FLUSH PRIVILEGES;
Read MoreUse 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 …
Read MoreIf 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 …
Read More