Topics tagged mysql

Topic	Replies	Views	Activity
How to resolve the «'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' "sql modes should be used with strict mode» MySQL warning? MySQL mysql , mysql-configuration-file	0	9564	April 29, 2017
How to remove the «Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path» MySQL warning? MySQL mysql , mysql-configuration-file	0	4360	April 29, 2017
How to remove the «Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location» MySQL warning? MySQL mysql , mysql-configuration-file	0	1856	April 29, 2017
How to fix the «Cannot open datafile for read-only» / «Could not find a valid tablespace file» MySQL error for an intentionally deleted database? MySQL mysql , mysql-configuration-file	0	2958	April 29, 2017
My my.ini for my localhost-only Windows machine MySQL mysql , windows , mysql-configuration-file	0	2571	April 30, 2017
How to connect to MySQL from Cygwin? MySQL windows , mysql , cygwin , env-path , windows-environment-variable , mysql-configuration-file , environment-variable	1	571	February 9, 2024
How to allow remote connections to a MySQL server? MySQL mysql , mysql-configuration-file	0	911	February 22, 2018
How to set a custom location of the primary MySQL configuration file (`my.cnf` / `my.ini`)? MySQL mysql , mysql-configuration-file , windows-environment-variable , environment-variable	1	196	February 9, 2024
How to find big tables of a MySQL database? MySQL mysql , storage-space	2	842	January 8, 2024
How do I transfer MySQL to a new Windows workstation? MySQL windows-10-bootstrap , mysql , env-path , windows-service , os-service	1	338	June 1, 2023
How do I register an administrator in WordPress via SQL? WordPress wordpress , mysql	1	153	December 4, 2023
How did I fix «Unknown collation: 'utf8mb4_0900_ai_ci'» on importing a `*.sql` dump to MySQL? MySQL mysql , sed , text-processing , unix , bash	1	201	December 4, 2023
How did I fix «update-alternatives: error: alternative path /etc/mysql/mariadb.cnf doesn't exist»? MySQL apt , mysql , mariadb , mysql-configuration-file	1	623	October 19, 2023
How to fix «EXPKEYSIG 8C718D3B5072E1F5»? Debian mysql , debian , expkeysig , public-key-cryptography , digital-signature , gpg , apt , public-key-certificate , apt-key	1	1093	August 7, 2023
How did I upgrade MySQL on Debian 10? MySQL apt , mysql , debian , debian-10-buster	1	282	August 7, 2023
How to fix «gpg: keyserver receive failed: Server indicated a failure» for ``keys.gnupg.net? Unix gpg , public-key-cryptography , debian , public-key-certificate , mysql , apt-key	2	1426	August 7, 2023
How did I fix «key 8C718D3B5072E1F5» / «duplicate signatures removed» / «unchanged: 1» on Debian 10 (Buster)? MySQL gpg , apt , mysql , public-key-cryptography , public-key-certificate , debian , debian-10-buster , apt-key	1	364	August 7, 2023
How did I fix «Err http://repo.mysql.com/apt/debian jessie InRelease» / «The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 8C718D3B5072E1F5» on Debian10 (Buster)? MySQL no_pubkey , gpg , apt , mysql , public-key-cryptography , public-key-certificate , debian , debian-10-buster	1	317	August 7, 2023
How did I fix «The detected system (debian jessie) is not supported by MySQL» on `dpkg-reconfigure mysql-apt-config` on Debian 10 (Buster)? MySQL apt , mysql , debian , debian-10-buster	1	1086	August 7, 2023
How do I transfer phpMyAdmin to a new Windows workstation? MySQL windows , phpmyadmin , mysql	1	212	June 27, 2023
How to fix «Failed to install the service» on `mysqld --install`? Other windows , windows-service , os-service , mysql	1	223	June 7, 2023
How did I configure `pt-kill` as a daemon on Debian? MySQL mysql , os-service , daemon	0	989	July 1, 2019
What is the `mysqld@.service` systemd file for? MySQL mysql , systemd , daemon , os-service	0	434	April 5, 2021
How to workaround the «mysql_upgrade» freeze error? MySQL mysql , cygwin	0	1010	April 30, 2017
How did I fix the «Can't create test file» MariaDB / MySQL error? MySQL mysql , mariadb	1	2864	March 16, 2021
How to make phpMyAdmin 100 times faster in Windows? MySQL mysql , phpmyadmin , windows , performance	0	494	November 30, 2020
How did I fix «Host '<…>' is not allowed to connect to this MySQL server»? MySQL mysql	1	491	September 28, 2020
How to order MySQL databases by size? MySQL mysql	1	976	March 31, 2020
How do I remove a prefix from all tables in a MySQL database? MySQL mysql	0	930	March 29, 2020
How have I fixed «InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung.» MySQL mysql	1	3787	March 7, 2020