Questions tagged [mysql]
For questions about MySQL, which is an open source Relational Database Management System (RDBMS).
34
questions
0
votes
0answers
12 views
Cannot execute two phpmyadmin instances in different containers
I trying to run multiple instances of phpmyadmin and MySQL. So I have actually 2 docker-compose.yml files, which contains this
database:
container_name: boilerplate_db
restart: always
...
0
votes
1answer
22 views
mysqld: [ERROR] Found option without preceding group in config file /root/.my.cnf at line 1!
I'm trying to create a .my.cnf file for my MySQL docker-container that would allow me to prefill the user and password for the MySQL client. To achieve this I created the following dockerfile:
FROM ...
0
votes
0answers
15 views
How can I pinpoint a bottleneck to optimize database queries?
I'm using GCP with a Mysql 5.7 Cloud SQL instances. I have a VM which reads/writes data with the instance.
My operations (a PHP script which reads and writes to the database) do not seem to have an ...
0
votes
1answer
25 views
Confluence mySQL image doesn't start anymore
I am running a confluence container containing an image for the application itself and one for the mySQL db. This was running smoothly until I run the latest Docker update. Since then, the mySQL image ...
0
votes
2answers
29 views
How can I model this schema in MySQL?
I want to create a schema that reflects the following relationships, and I'm trying to do this in MySQL Workbench. (I'm no DB expert)
I have 3 environments - sandbox, staging, and production
I ...
0
votes
0answers
34 views
Deploy and expose Mysql in AWS Lightsail container service
AWS Lightsail container service allows exposing the container only if it has an HTTP / HTTPS port open with the proper responses to healthcheck. I'm trying to run a MySQL container from the docker hub ...
0
votes
2answers
154 views
backup dockerise mysql database from host volume
I use a VPS (my host) where a LAMP server was installed.
I already have a database associated to host mariaDB server Ver 15.1 Distrib 10.1.47 and automysqlbackup backups it. This part works well.
For ...
0
votes
0answers
7 views
Can Azure MySQL use a precompiled library (or can I compile I library to use with Azure MySQL?)
I want to run a Damerau-Levenshtein distance comparison between strings in separate records. Using my local MySQL instance I have referenced a precompiled library that runs significantly faster than a ...
0
votes
0answers
13 views
How to manage MySQL database versioning/revisions?
Can anyone help me to understand that how do I manage the MySQL database revisions?
0
votes
0answers
18 views
Topology and configuration of MySQL client and server containers
Perhaps I'm using MySQL in an unusual way. I was thinking of just having alice and bob containers, where the console client is used on one to query the other.
I'm probably using MySQL in an obscure ...
0
votes
0answers
59 views
Is the MySQL Command-Line Client on alpine or another minimalist container?
This seems not wholly unreasonable:
root $
root $ docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
root $
root $...
0
votes
1answer
531 views
how to connect to a MySQL database in a docker container?
starting up the default mysql server:
root $
root $ docker run --name mysql -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password mysql/mysql-server:latest
...
0
votes
1answer
113 views
How to gain console access to a MySQL server running on a docker container from the host?
I thought I had this working a few minutes ago:
root $
root $ docker container ls
CONTAINER ID IMAGE COMMAND CREATED STATUS ...
0
votes
0answers
46 views
from docker container: intermittent error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket
Help me to understand what's happening here with regards to connecting to the database:
root $
root $ docker ps -a
CONTAINER ID IMAGE COMMAND CREATED ...
0
votes
0answers
9 views
how to connect to MySQL from the MySQL command line client with docker? [duplicate]
Trying to connect to MySQL:
root $
root $ docker container ls
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
root $
...
0
votes
0answers
593 views
docker-compose to populate MariaDB/MySQL Database from mysqldump from GH repo referencing docker-entrypoint-initdb.d path on build
I'm dabbling with creating an application that can be built from a single docker-compose.yml file "on the fly" in any Docker / docker-compose enabled machine (most likely for QA, UAT or ...
0
votes
1answer
266 views
How to create a “silent” MySQL docker container?
How can I create a MySQL docker container as below in the background:
root:~#
root:~# docker run -e MYSQL_ROOT_PASSWORD=pass --name sql-db -p 3306:3306 mysql &
[1] 137878
root:~# 2020-09-01 08:25:...
0
votes
2answers
290 views
how to send a password to MySQL with docker?
Just getting started, want to run the downloaded version of mysql:
root:~#
root:~# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
basex/basexhttp ...
0
votes
1answer
131 views
Combining Two Containers
I'm working on a Windows laptop and running Docker for Windows on it. I want to run an Ubuntu container with a specific version and a MySQL server on it. So the question is, do I have to download ...
1
vote
0answers
41 views
Are there turn-key development webapp containers for evaluation?
In short: I want a ready-made webapp framework with a web server and a database in a container, such that I can edit files on my local drive and view the results through a browser pointed at the ...
1
vote
1answer
30 views
Managed MySQL cluster - similar solution for a private cloud
Is it possible to build a similar solution to managed MySQL cluster on a private cloud (VMware vSphere / Hyper V). Even with Kubernetes.
A solution which supports auto-scaling, auto-upgrade, multi-...
1
vote
1answer
399 views
mariadb docker on raspberry
I've tried countless docker images, but all of them have the same behaviour.
When I open up a console and try to import my database structure via the mysql/mariadb command. But I always get the same ...
0
votes
1answer
38 views
Let docker containers work with each other
I’m new to docker and I want to dockerize a aleardy existing application.
It consists of a react application (I already created a container for that one successfully), a REST-api based on node-...
1
vote
2answers
4k views
docker | database connection refused between two containers
I have a mysql database running with the following docker-compose.yml:
version: '3.3'
services:
db:
image: mysql:5.7
restart: always
environment:
...
2
votes
0answers
20 views
Connecting to MySQL Remotely on Azure VM
I am having trouble connecting remotely to my MySql install that runs on an Azure VM.
Here is what I did:
Ubuntu VM with MySql 5.7 installed
Bind Address set to 0.0.0.0
User granted rights with ...
1
vote
1answer
210 views
docker mysql container not running suddenly
docker mysql container was working perfectl.But after restarting of the server and using the start command to run the conatiner it is not working.My other containers are all up and running as normal....
0
votes
1answer
50 views
Unable to create container after installing mysql and phpmyadmin | Ubuntu
I have installed docker successfully and try to install phpmyadmin and mysql.
I have did following steps.
Using below link I have pulled php version
https://hub.docker.com/r/codepulse/php-7.2.0-...
2
votes
2answers
224 views
How to handle AWS Offsite or cross-account RDS (mysql) backups?
AWS Provides a great solution to provide point-in-time recovery backups within RDS. However, while we take every measure to protect the root account, I'm paranoid that if someone were to gain access ...
0
votes
1answer
33 views
Dockerized MySql slower in Wifi than ethernet
When I try to connect to a MySQL server that runs in a docker container(in System A) through my application(Running in system B) via wifi, it takes at least 4X amount of time than it would when both ...
3
votes
1answer
106 views
Mysql with Kubernetes
I am converting a webapp from monolithic to kubernetes based architecture.
But how can mysql be persistent with data when we have 2 mysql pods in each of 2 differnet nodes?
I think we can mount a ...
2
votes
1answer
4k views
Persistent data in MySQL with Docker
If I startup MySQL server during docker build (derived from official MySQL Dokcer Image) in two different statements, would be database files be pertained?
I would say yes, but it seems to be wrong. ...
5
votes
1answer
517 views
Terraform: Delay the MySQL Provider
I have a Terraform project which uses the MySQL provider. Because of the way Terraform works, the MySQL provider will fail to load correctly because the AWS_RDS instance doesn't exist. Is there a ...
1
vote
2answers
8k views
Can't connect to my dockerized MySQL
I'm trying to implement this pre-cooked package of NGINX, PHP-FPM, MySQL, E-L-K.
Everything is working fine but the connection with the database. It throws a ConnectionException.
I'm not really sure ...
8
votes
3answers
2k views
How to create staging servers for multiple git branches?
I have to create a new staging process for our development and testing.
At any given time, there are only around 4 git branches actively being developed and tested. Within each git branch, there may ...