ISPConfig fail to create MySQL database
Whem creating MySQL database in ISPConfig, no database get created. To debug, i disabled the cronjob. Created a database in ISPConfig control…
mysql
MySQL ERROR Access denied you need SUPER privilege for this operation
WHen restoring a MySQL database, i get following error root@ns3043014:~# mysql -u NEW_DB_USER -p’PASSOWRD_HERE’ DB_NAME < BACKUP_FILE.sql ERROR 1227 (42000) at line…
MariaDB
MariaDB Repository Setup Script MariaDB DEFAULT NULL ERROR 1064 (42000) Install MariaDB 10.3 on CentOS 7
Install MySQL as Service in Windows
When you manually install MySQL from zip, no MySQL service get created. To run MySQL Server as a service in windows, go…
Deploy MySQL Server in Kubernetes using Helm
To install MySQL server in Kubernetes, run helm install stable/mysql Once install is completed, you will get something like NOTES: MySQL can…
MySQL 8 apt Error The following signatures were invalid
When trying to install MySQL 8 on Ubuntu 18.04, i get following error root@ssdnodes-45790:~# apt update Ign:1 http://download.webmin.com/download/repository sarge InRelease Hit:2 http://download.webmin.com/download/repository…
MySQL Got error 24 Too many open files
For ubuntu, see Ubuntu 18.04 MariaDB 10.2 Too many open files On taking MySQL backup with mysqldump, i get following error mysqldump:…
MySQL Out of resources when opening file
On a MySQL server got the error Out of resources when opening file ‘/tmp/#sql_318d_0.MAD’ (Errcode: 24 “Too many open files”) This is…
mysqldump packet bigger than max_allowed_packet
When backing up a MySQL database using mysqldump command, got following error [root@vps189 ~]# mysqldump sok_main > sok_main.sql mysqldump: Error 2020: Got…
Reset MySQL 5.7 root password on Ubuntu 16.04
First stop MySQL with command service mysql stop Now run mysqld_safe –skip-grant-tables On Ubuntu 16.04 server with MySQL 5.7, when i run,…
MySQL Permission denied
After changing MySQL data directory, i get error Apr 17 03:01:20 hon-pc-01 mysqld[25298]: 180417 3:01:20 [Note] /usr/sbin/mysqld (mysqld 10.0.34-MariaDB-0ubuntu0.16.04.1) starting as process…
Change MySQL root password
If you have MYSQL root password and want to change the MySQL root password, first log in to MYSQL with the command…