Installing phpMyAdmin and MySQL via Docker In local

Installing phpMyAdmin and MySQL via Docker In local

Prerequisite:
1. Basic Understanding of Docker and Container : 
If you haven't attend any Docker 101 webinars and seminars, ask your TL to arrange one. 
2. Docker is installed : 

MySQL 
1. docker pull mysql
2. docker run --name mysql --restart always -v /my/own/datadir:/var/lib/mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:5.6

Change "/my/own/datadir" to the path where you want mysql to store the data

Change "my-secret-pw" to the password you want to set. 



phpMyAdmin
1. docker pull phpmyadmin/phpmyadmin
2. docker run --name myadmin --restart always -d --link mysql_db_server:db -p 8080:80 phpmyadmin/phpmyadmin

Change 8080 to the port which is avalaible and you can use to run PMA



    • Related Articles

    • Installing Docker

      Installing Docker On Windows Minimul Requirement :  1. Windows 10 64bit 2. At least 4GB of RAM. Steps: 1. Download exe from  download.docker.com 2. Run the installer.   3. Start the docker.  More Information ...

    • Connecting to development database

      Overview: Database Admin UI URL PHPMyAdmin https://pma.openxcell.dev Adminer https://adminer.openxcell.dev MySQL Databases: For all the application using mysql database https://pma.openxcell.dev serves the PHPMyAdmin Frontend. To access the ...

    • Difference between phpMyAdmin and MySQL

      MySQL is a database server (which comes with a command line client for it) PHPMyAdmin is a (web application) client for MySQL. MySql is server where your commands get executed and returns you data, It manages all about data while PhpMyAdmin is a web ...

    • What & How : MySQL User

      Run below commands to create MySQL user. 1. For local MySQL 1.CREATE USER 'username'@'%' IDENTIFIED BY 'password'; 2.GRANT ALL ON *.* TO 'username'@'%'; 2. For AWS RDS 1. CREATE USER 'username'@'%' IDENTIFIED BY 'password'; 2. GRANT SELECT, INSERT, ...

    • What & How : Docker commands

      1. Install Docker $curl https://get.docker.com/ > dockerinstall && chmod 777 dockerinstall && ./dockerinstall 2. Docker should now be installed, the daemon started, and the process enabled to start on boot. Check that it's running: $service docker ...