Setting Up Mysql Server for Remote Connection

Make sure you have added

 

$i++;
$cfg['Servers'][$i]['host']          = '35.159.20.95';
$cfg['Servers'][$i]['port']          = '3306';
$cfg['Servers'][$i]['socket']        = '';
$cfg['Servers'][$i]['connect_type']  = 'tcp';
$cfg['Servers'][$i]['extension']     = 'mysql';
$cfg['Servers'][$i]['compress']      = FALSE;
$cfg['Servers'][$i]['auth_type']     = 'cookie';
$cfg['Servers'][$i]['user']          = '';
$cfg['Servers'][$i]['password']      = '';

 

Open /etc/mysql/mysql.conf.d/mysqld.cnf

Check this Stack Exchange Thread

https://stackoverflow.com/questions/15663001/remote-connections-mysql-ubuntu

or

https://devdocs.magento.com/guides/v2.3/install-gde/prereq/mysql_remote.html

Was this article helpful?

Related Articles

Leave A Comment?