docker php mysql_使用Docker从PHP连接到MySQL服务器

港控/mmm° 2023-01-11 04:59 115阅读 0赞

![bd96500e110b49cbb3cd949968f18be7.png][]

I am new to Docker. I am developing a PHP application in Docker environment, and I need to use a MySql Server/database to persist data. Following documentation, I run this command to create the MySql server image:

docker run -v /var/lib/mysql mariadb

It downloaded it, but I also go this error with it:

error: database is uninitialized and password option is not specified You need to specify one of MYSQL\_ROOT\_PASSWORD, MYSQL\_ALLOW\_EMPTY\_PASSWORD and MYSQL\_RANDOM\_ROOT\_PASSWORD

How do I set the MYSQL\_ALLOW\_EMPTY\_PASSWORD option?

And then how would I create a database on this image, and then read/write to it from my PHP code (which is on a different image)?

解决方案

Create container

Run this command: docker run --name some-mariadb -e MYSQL\_ROOT\_PASSWORD=mysecretpw -v mysql:/var/lib/mysql -d mariadb:latest

With this, you are creating your docker container with mariadb, and storing data on mysql folder. In the command, you have -e MYSQL\_ROOT\_PASSWORD=my-secret-pw. This set your root password as my-secret-pw. When you connect to it, your user is root, and password is my-secret-pw.

Find out the address

docker inspect some-mariadb - With this command, you will find all information about your container. You need your IP address.

Hint: docker inspect some-mariadb | grep IPAddress you make easier to find your IP Address.

Connecting

Now, it is the PHP part. Run the PHP below, but check your host address, that in my case was 172.17.0.2 (from PHP documentation.):

$link = mysqli\_connect("172.17.0.2", "root", "my-secret-pw");

if (!$link) \{

echo "Error: Unable to connect to MySQL." . PHP\_EOL;

echo "Debugging errno: " . mysqli\_connect\_errno() . PHP\_EOL;

echo "Debugging error: " . mysqli\_connect\_error() . PHP\_EOL;

exit;

echo "Success: A proper connection to MySQL was made!" . PHP\_EOL;