When is mysql-client needed?
R.Neville asked: I have read a number of tutorials on installing MySQL, and I’ve noticed that many of them only discuss installing mysql-server, whereas some also discuss installing mysql-client. My …
Why can't I connect to MariaDB with Navicat through SSH tunnel?
Codemonkey asked: I’ve always used Navicat on windows to manage my MySQL/Percona instances. A few days ago I bought a new server and have installed MariaDB 10.3.9. I can connect …
PHP 7.2.8 PDO Fails to Connect to MySQL 8.0.12 (GA) in AWS EC2 LEMP Stack
HumanJHawkins asked: I’m testing a new LEMP webserver built with Ubuntu Server 18.04 LTS, NGINX 1.14, PHP 7.2.8, and MySQL 8.0.12. It is an AWS EC2 instance using the official …
execstop mysql error on stop and restart
user239612 asked: prerequisite: os: kali-linux 2018.1 uname -r: 4.14.0-kali3-amd64 mysql version: mysql Ver 15.1 Distrib 10.1.29-MariaDB problem: yesterday i had setup an apache server with this help, https://www.tecmint.com/install-wordpress-on-ubuntu-16-04-with-lamp/. I was …
Port 3306 keeps closed even after being open on iptables
oscar_vb asked: Due to the nature of my project, I need to open port 3306 on a cloud server running CentOS 6. Using this site: http://www.yougetsignal.com/tools/open-ports/ I can see whether …
How run docker on VDS (lxd/containers)
Viktor S asked: I have VDS like lxd/container (I see it df -h). Os is installed debian 7.11. Kernel: uname -r 4.13.0-19-generic I want to run mysql in docker which …
MySQL "my.cnf" variables not updating after Ansible run
JonnySerra asked: i’m creating a simple Ansible playbook for my Project where i’m installing MySQL on an Ubuntu VM. As part of this setup i’m creating a custom my.cnf file …
Forcing mysql client to use IP over hostname (from python)?
fromClouds asked: Is there any way to force a mysql client to prefer using an IP address over a hostname for self-identification to a server? I am running Python 2.7.12 …
Large mysql dump pipe to s3
John W. Nesk asked: Is there any problem in doing this with lots of data? mysqldump … | gzip | s3cmd put – s3://bucket/file.sql.gz The MySQL dump is about 100GB …
mysqld.service for systemd – Failed to parse resource value, ignoring: 40000 – LimitMEMLOCK
Berlin asked: I got this error mysql systemd[1]: [/usr/lib/systemd/system/mysqld.service:39] Failed to parse resource value, ignoring: 40000 on Centos 7 with mysql 5.7 when I set the LimitMEMLOCK limit for MYSQL …