Oracle MySQL 8.0.29 Installation using docker-compose.yml
My Docker version is the latest ( as of date ) Docker Engine v20.10.16 and Docker Desktop 4.9.0 (80466) is currently the newest version available.
version: "3.9"
services:
mysql:
container_name: "mysqldb"
image: mysql
command: --default-authentication-plugin=mysql_native_password
restart: always
ports:
- "33071:3306"
volumes:
- ./db_data:/var/lib/mysql
environment:
MYSQL_ALLOW_EMPTY_PASSWORD: yes
Add this below code to your phpmyadmin configuration file in your local develompent host environemet F:\Xammp\PhpMyAdmin\config.inc.php and login with root and without any password.
*/
$i++;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '33071';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
?>