MySQL

Topic	Replies	Views	Activity
How to paste a tab-formatted SQL command into MySQL shell? mysql	1	252	February 9, 2024
How to disable the «automatic rehashing» feature of `mysql` by default? mysql , mysql-configuration-file	1	206	February 9, 2024
How to resolve the «TIMESTAMP with implicit DEFAULT value is deprecated» MySQL warning? mysql , mysql-configuration-file	0	1689	April 29, 2017
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-configuration-file	0	9692	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-configuration-file	0	4393	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-configuration-file	0	1868	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-configuration-file	0	2968	April 29, 2017
My my.ini for my localhost-only Windows machine mysql , windows , mysql-configuration-file	0	2591	April 30, 2017
How to connect to MySQL from Cygwin? windows , mysql , cygwin , env-path , windows-environment-variable , mysql-configuration-file , environment-variable	1	588	February 9, 2024
How to allow remote connections to a MySQL server? mysql , mysql-configuration-file	0	923	February 22, 2018
How to set a custom location of the primary MySQL configuration file (`my.cnf` / `my.ini`)? mysql , mysql-configuration-file , windows-environment-variable , environment-variable	1	215	February 9, 2024
How do I transfer MySQL to a new Windows workstation? windows-10-bootstrap , mysql , env-path , windows-service , os-service	1	362	June 1, 2023
How did I fix «Unknown collation: 'utf8mb4_0900_ai_ci'» on importing a `*.sql` dump to MySQL? mysql , sed , text-processing , unix , bash	1	224	December 4, 2023
How did I fix «update-alternatives: error: alternative path /etc/mysql/mariadb.cnf doesn't exist»? apt , mysql , mariadb , mysql-configuration-file	1	818	October 19, 2023
How did I upgrade MySQL on Debian 10? apt , mysql , debian , debian-10-buster , upgrade-report	1	295	August 7, 2023
How did I fix «key 8C718D3B5072E1F5» / «duplicate signatures removed» / «unchanged: 1» on Debian 10 (Buster)? gpg , apt , mysql , public-key-cryptography , public-key-certificate , debian , debian-10-buster , apt-key	1	381	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)? no_pubkey , gpg , apt , mysql , public-key-cryptography , public-key-certificate , debian , debian-10-buster	1	344	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)? apt , mysql , debian , debian-10-buster	1	1238	August 7, 2023
How do I transfer phpMyAdmin to a new Windows workstation? windows , phpmyadmin , mysql	1	230	June 27, 2023
How did I configure `pt-kill` as a daemon on Debian? mysql , os-service , daemon	0	1011	July 1, 2019
What is the `mysqld@.service` systemd file for? mysql , systemd , daemon , os-service	0	445	April 5, 2021
How to workaround the «mysql_upgrade» freeze error? mysql , cygwin	0	1018	April 30, 2017
How did I fix the «Can't create test file» MariaDB / MySQL error? mysql , mariadb	1	2949	March 16, 2021
How to make phpMyAdmin 100 times faster in Windows? mysql , phpmyadmin , windows , performance	0	505	November 30, 2020
How did I fix «Host '<…>' is not allowed to connect to this MySQL server»? mysql	1	496	September 28, 2020
How to order MySQL databases by size? mysql	1	993	March 31, 2020
How do I remove a prefix from all tables in a MySQL database? mysql	0	955	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	1	3823	March 7, 2020
How to fix «Could not open file <...> for error logging: Permission denied» / «Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock» for MySQL? mysql	0	771	January 4, 2020
How to escape a single quote within a password of mysqldump? mysql	0	791	December 5, 2018

How to paste a tab-formatted SQL command into MySQL shell?

mysql

1

252

February 9, 2024

How to disable the «automatic rehashing» feature of `mysql` by default?

mysql , mysql-configuration-file

1

206

February 9, 2024

How to resolve the «TIMESTAMP with implicit DEFAULT value is deprecated» MySQL warning?

mysql , mysql-configuration-file

0

1689

April 29, 2017

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-configuration-file

0

9692

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-configuration-file

0

4393

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-configuration-file

0

1868

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-configuration-file

0

2968

April 29, 2017

My my.ini for my localhost-only Windows machine

mysql , windows , mysql-configuration-file

0

2591

April 30, 2017

How to connect to MySQL from Cygwin?

windows , mysql , cygwin , env-path , windows-environment-variable , mysql-configuration-file , environment-variable

1

588

February 9, 2024

How to allow remote connections to a MySQL server?

mysql , mysql-configuration-file

0

923

February 22, 2018

How to set a custom location of the primary MySQL configuration file (`my.cnf` / `my.ini`)?

mysql , mysql-configuration-file , windows-environment-variable , environment-variable

1

215

February 9, 2024

How do I transfer MySQL to a new Windows workstation?

windows-10-bootstrap , mysql , env-path , windows-service , os-service

1

362

June 1, 2023

How did I fix «Unknown collation: 'utf8mb4_0900_ai_ci'» on importing a `*.sql` dump to MySQL?

mysql , sed , text-processing , unix , bash

1

224

December 4, 2023

How did I fix «update-alternatives: error: alternative path /etc/mysql/mariadb.cnf doesn't exist»?

apt , mysql , mariadb , mysql-configuration-file

1

818

October 19, 2023

How did I upgrade MySQL on Debian 10?

apt , mysql , debian , debian-10-buster , upgrade-report

1

295

August 7, 2023

How did I fix «key 8C718D3B5072E1F5» / «duplicate signatures removed» / «unchanged: 1» on Debian 10 (Buster)?

gpg , apt , mysql , public-key-cryptography , public-key-certificate , debian , debian-10-buster , apt-key

1

381

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)?

no_pubkey , gpg , apt , mysql , public-key-cryptography , public-key-certificate , debian , debian-10-buster

1

344

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)?

apt , mysql , debian , debian-10-buster

1

1238

August 7, 2023

How do I transfer phpMyAdmin to a new Windows workstation?

windows , phpmyadmin , mysql

1

230

June 27, 2023

How did I configure `pt-kill` as a daemon on Debian?

mysql , os-service , daemon

0

1011

July 1, 2019

What is the `mysqld@.service` systemd file for?

mysql , systemd , daemon , os-service

0

445

April 5, 2021

How to workaround the «mysql_upgrade» freeze error?

mysql , cygwin

0

1018

April 30, 2017

How did I fix the «Can't create test file» MariaDB / MySQL error?

mysql , mariadb

1

2949

March 16, 2021

How to make phpMyAdmin 100 times faster in Windows?

mysql , phpmyadmin , windows , performance

0

505

November 30, 2020

How did I fix «Host '<…>' is not allowed to connect to this MySQL server»?

mysql

1

496

September 28, 2020

How to order MySQL databases by size?

mysql

1

993

March 31, 2020

How do I remove a prefix from all tables in a MySQL database?

mysql

0

955

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

1

3823

March 7, 2020

How to fix «Could not open file <...> for error logging: Permission denied» / «Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock» for MySQL?

mysql

0

771

January 4, 2020

How to escape a single quote within a password of mysqldump?

mysql

0

791

December 5, 2018