Comments (10)
This issue is still not resolved. Switched to mysql image. No problems.
from mariadb-docker.
So I temporarily resolved it using a script that is automatically run when the container starts up.
fix-permissions.sh
#!/bin/bash
mysql -u root -e "grant all on *.* to '$MYSQL_USER'@'%' identified by '${MYSQL_PASSWORD}' with grant option; flush privileges;"
and its use in Dockerfile:
# copy the file into the container
COPY fix-permissions.sh /docker-entrypoint-initdb.d/fix-permissions.sh
# make it executable
RUN chmod +x /docker-entrypoint-initdb.d/fix-permissions.sh
from mariadb-docker.
Unable to reproduce. Closing old issue.
from mariadb-docker.
Can you provide us a little more information about how you're running it? I can't seem to reproduce:
$ docker pull mariadb
Using default tag: latest
latest: Pulling from library/mariadb
fdd5d7827f33: Already exists
a3ed95caeb02: Already exists
2d9b55a37647: Already exists
88a4bacbf934: Already exists
d2f0eb2850d3: Already exists
e35651814623: Already exists
12cafcc1e597: Already exists
b12059a0fd60: Already exists
9643f0599420: Already exists
452cf8ba3692: Already exists
Digest: sha256:de91e4cb58e716a12f0ee204d628ba9c855f217a42f96360181c28beb0e7b075
Status: Image is up to date for mariadb:latest
$ docker run --name some-mariadb -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mariadb
c5b36b0bf92e473b796e6fc2708c0e747ccaa21ab800d769abc6dbcc4e8f957a
$ docker run -it --link some-mariadb:mysql --rm mariadb sh -c 'exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -uroot -p"$MYSQL_ENV_MYSQL_ROOT_PASSWORD"'
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.1.12-MariaDB-1~jessie mariadb.org binary distribution
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> SELECT 1;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)
MariaDB [(none)]>
from mariadb-docker.
I use rancher and it likes to setup custom networks for my docker containers which in turn causes the same issue
Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [1130] Host '10.42.209.230' is not allowed to connect to this MariaDB server
mariadb:
environment:
MYSQL_ROOT_PASSWORD: 1234
MYSQL_DATABASE: owncloud
labels:
io.rancher.container.pull_image: always
tty: true
image: mariadb
volumes:
- /opt/docker/owncloud/db:/var/lib/mysql
owncloud:
environment:
VIRTUAL_HOST: owncloud..local
VIRTUAL_PORT: '8080'
labels:
io.rancher.container.pull_image: always
image: owncloud
links:
- mariadb:mariadb
volumes:
- /opt/docker/owncloud/data:/var/www/html
from mariadb-docker.
I'm experiencing the same problem when using docker-compose -p PROJECT_NAME up
, it seems to be related to the custom network which gets created instead of the default one when the project name switch is used.
from mariadb-docker.
I am seeing this on Travis https://travis-ci.org/schmunk42/yii2-giiant/builds/282246176 - works fine locally.
[edit]
Sorry, does not really belong here as I am using a base-image from tutum https://github.com/schmunk42/docker-mariadb-example-databases/blob/master/Dockerfile
from mariadb-docker.
I'm experiencing this issue using the OwnCloud docker-compose.yml on the latest version of Docker on OpenSUSE.
from mariadb-docker.
Experiencing it on Ubuntu 16
from mariadb-docker.
I had the same issue on kubernetes and could fixing it by setting explicitly MYSQL_ROOT_HOST
to %
.
from mariadb-docker.
Related Issues (20)
- Dashes in username are not allowed HOT 3
- Aborted connection to db: 'unconnected' user: 'unauthenticated' host: 'xxx' (This connection closed normally without authentication) HOT 42
- [Question - help needed] My Master - Master setup stop working due to an error I can not solve HOT 2
- Add option to auto upgrade user tables HOT 7
- Latest Mariadb image has authentication issues HOT 3
- Server sent charset HOT 2
- Database failing after update to new latest image HOT 5
- Fields with names 'uuid' or '..._uuid' cannot be deleted HOT 1
- There is a strange error when trying to recreate a table after deleting it. HOT 1
- Yes it seems another: mysqld: io_uring_queue_init() failed with ENOMEM: try larger memory locked limit HOT 7
- .my-healthcheck.cnf permissions problems HOT 13
- Crash when entrypoint inits database and passing init-connect argument with whitespace HOT 2
- Why is there no 10.5.25 or 10.6.18 HOT 6
- Fresh container, fails tc.log and fails permissions HOT 3
- Issue with mounting a volume with `/*!999999\- enable the sandbox mode */ ` HOT 3
- Missing arm64 builds and wrong lts version HOT 4
- Default collation changed between 11.4.1 and 11.4.2 (latest) HOT 6
- MARIADB_AUTO_UPGRADE=1/mariadb-upgrade not workling if ssl is enabled HOT 28
- So I have a test like (with custom config since `require_secure_transport=ON`) HOT 6
- it's fine when installed but after reboot it will show errors.Can't create/write to file './ddl_recovery.log' (Errcode: 13 "Permission denied") HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mariadb-docker.