TASIOMIND.DEV — OPERATIONAL▸▸▸FULL STACK DEVELOPER @ GWQ SERVICEPLUS AG▸▸▸FOUNDER — K8SGPT.AI▸▸▸OPEN SOURCE: ACTIVE▸▸▸DISTRIBUTED SYSTEMS / KUBERNETES / AI▸▸▸RUST + GO + PYTHON▸▸▸FIELD TESTED / STATUS — NOMINAL▸▸▸LOCATION: EUROPE/BERLIN▸▸▸TASIOMIND.DEV — OPERATIONAL▸▸▸FULL STACK DEVELOPER @ GWQ SERVICEPLUS AG▸▸▸FOUNDER — K8SGPT.AI▸▸▸OPEN SOURCE: ACTIVE▸▸▸DISTRIBUTED SYSTEMS / KUBERNETES / AI▸▸▸RUST + GO + PYTHON▸▸▸FIELD TESTED / STATUS — NOMINAL▸▸▸LOCATION: EUROPE/BERLIN▸▸▸
← databases

Common MySQL Errors

July 6, 2017

Can't connect to local MySQL server through socket

code
sudo mkdir -p /var/run/mysqld
sudo chown mysql:mysql /var/run/mysqld
sudo touch /var/run/mysqld/mysqld.sock
sudo systemctl restart mysql

Server running with --skip-grant-tables

code
FLUSH PRIVILEGES;

Table mysql.user doesn't exist

code
USE mysql;
SELECT * FROM user;

Falls fehlend:

code
mysql_install_db

Remote connect refused (Port 3306)

Pruefe bind-address in mysqld.cnf und Security Group/Firewall.

validate_password policy

code
UNINSTALL PLUGIN validate_password;

Links