I have installed and setup phpmyadmin in app engine, with mysql installed in compute engine. I am receiving this error mysqli_real_connect(): (HY000/2002): No such file or directory when logging into phpmyadmin. I have set up vpc access connector in app.yaml, and opened port 3306 in the compute engine.
config.inc.php in phpmyadmin :
$cfg['Servers'][$i]['host'] = '10.126.0.9:3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
in compute engine with mysql installed with config /etc/mysql/mysql.conf.d/mysqld.conf
[mysqld]
#
# * Basic Settings
#
user = mysql
# pid-file = /var/run/mysqld/mysqld.pid
# socket = /var/run/mysqld/mysqld.sock
# port = 3306
# datadir = /var/lib/mysql
# If MySQL is running as a replication slave, this should be
# changed. Ref https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_tmpdir
# tmpdir = /tmp
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 10.126.0.9
#mysqlx-bind-address = 0.0.0.0
On top of that, I have created user to login from phpmyadmin
CREATE USER 'myadminLogin'@'*' IDENTIFIED BY 'password';
Mysql and OS variant
mysql -V
mysql Ver 8.0.30-0ubuntu0.20.04.2 for Linux on x86_64 ((Ubuntu))
sudo netstat -tulpn | grep LISTEN | grep mysql
tcp 0 0 10.126.0.9:3306 0.0.0.0:* LISTEN 32879/mysqld
tcp6 0 0 :::33060 :::* LISTEN 32879/mysqld
Port opened: 3306
Network analysis
Thanks.
Update 17/9/22 Hi all, after the above changes, I no longer see the login panel but currently being directed straight to the page below. May I know what is the issue? Thanks
