I have installed and setup phpmyadmin in app engine, with mysql installed in compute engine. However, instead of showing login screen, I am seeing the screen below:
Below are my settings: config.inc.php in phpmyadmin :
$cfg['Servers'][$i]['host'] = '10.126.0.9';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Servers'][$i]['usergroups'] = false;
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'@'10.126.0.9' 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
Thanks.
