I created a MySQL Database via docker (and docker compose command) using this configuration:
version: '3.8'
services:
db:
image: mysql
volumes:
- ./data/mysql:/var/lib/mysql
ports:
- '3306:3306'
environment:
MYSQL_ROOT_PASSWORD: 'root'
MYSQL_DATABASE: 'test'
I tried to access http://localhost:3306
but it tells me that the page is currently not working. Is the link I am using wrong or can you tell me how I can access the database?
>Solution :
The URL http://localhost:3306 will not work for accessing the MySQL database as it is the port that MySQL uses to communicate with other services, not a web server port.
To access the MySQL database, you can use a MySQL client tool such as MySQL Workbench or the command-line tool mysql. Here are the steps to access the database using mysql command-line tool:
- Open a terminal or command prompt.
- Enter the command mysql -h localhost -u root -p and press enter.
- You will be prompted to enter the password for the MySQL root user. Enter the password ‘root’ that you set in the docker-compose.yml file.
- Once you have successfully logged in, you can run MySQL queries to create tables, insert data, and perform other operations on the database.
Note that when you run the docker-compose up command, it may take a few moments for the database to start up fully before you can connect to it.