painted-fox / docker-mariadb Goto Github PK

If I try to connect from another docker container I get

SQLSTATE[HY000] [1130] Host '172.17.0.4' is not allowed to connect to this MariaDB server

I see that there is the following in first_run.sh:

CREATE USER '$USER'@'%' IDENTIFIED BY '$PASS';
GRANT ALL PRIVILEGES ON *.* TO '$USER'@'%' WITH GRANT OPTION;

so it should be working. Any idea why I get this error? Is there something I could check?

EDIT:
Using docker logs I get:

MARIADB_USER=super
MARIADB_PASS=LlEZm86IxY0SXLNt
MARIADB_DATA_DIR=/data
Initializing MariaDB at /data
Starting MariaDB...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
140306 22:26:33 mysqld_safe Logging to '/data/mysql.log'.
140306 22:26:33 mysqld_safe Starting mysqld daemon with databases from /data

Maybe the error in between is the problem?

I have multiple problems when mapping this to another port than the default 3306. I'm using the 3307 port instead.
When I do this container starts multiple processes and won't allow logging in.
$ mysql -u super --password=J8s0hY0d6QJsOfF0 --protocol=tcp --port=3307
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

Hi! I wanted to discuss the best strategy for supporting MariaDB 10 (which now is the current stable)

It would be easy to simply change the repository and call it a day, but I don't think it is 100% backwards compatible with MariaDB 5.5 - plus it is necessary to run mysql_upgrade after changing versions.

What do you think is the best strategy then? Having two images (potentially in another repo)?

The container will fail to reinitialize and run MariaDB when you restart the container with a docker stop && docker start. It will also fail to reinitialize when you reboot the host machine.

I'm seeing this on a Digital Ocean droplet running Ubuntu 13.10 (64 bit).

Running docker logs mariadb shows:

MARIADB_SUPER_USER=super
MARIADB_SUPER_PASS=ENgLS9rQ2rQgEYKj
MARIADB_DATA_DIR=/data
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)