|
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?
|
|
0
|
4359
|
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?
|
|
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?
|
|
0
|
2958
|
April 29, 2017
|
|
My my.ini for my localhost-only Windows machine
|
|
0
|
2571
|
April 30, 2017
|
|
How to connect to MySQL from Cygwin?
|
|
1
|
571
|
February 9, 2024
|
|
How to allow remote connections to a MySQL server?
|
|
0
|
911
|
February 22, 2018
|
|
How to set a custom location of the primary MySQL configuration file (`my.cnf` / `my.ini`)?
|
|
1
|
196
|
February 9, 2024
|
|
How to find big tables of a MySQL database?
|
|
2
|
842
|
January 8, 2024
|
|
How do I transfer MySQL to a new Windows workstation?
|
|
1
|
338
|
June 1, 2023
|
|
How did I fix «Unknown collation: 'utf8mb4_0900_ai_ci'» on importing a `*.sql` dump to MySQL?
|
|
1
|
201
|
December 4, 2023
|
|
How did I fix «update-alternatives: error: alternative path /etc/mysql/mariadb.cnf doesn't exist»?
|
|
1
|
620
|
October 19, 2023
|
|
How did I upgrade MySQL on Debian 10?
|
|
1
|
282
|
August 7, 2023
|
|
How did I fix «key 8C718D3B5072E1F5» / «duplicate signatures removed» / «unchanged: 1» on Debian 10 (Buster)?
|
|
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)?
|
|
1
|
316
|
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)?
|
|
1
|
1085
|
August 7, 2023
|
|
How do I transfer phpMyAdmin to a new Windows workstation?
|
|
1
|
212
|
June 27, 2023
|
|
How did I configure `pt-kill` as a daemon on Debian?
|
|
0
|
989
|
July 1, 2019
|
|
What is the `mysqld@.service` systemd file for?
|
|
0
|
434
|
April 5, 2021
|
|
How to workaround the «mysql_upgrade» freeze error?
|
|
0
|
1010
|
April 30, 2017
|
|
How did I fix the «Can't create test file» MariaDB / MySQL error?
|
|
1
|
2861
|
March 16, 2021
|
|
How to make phpMyAdmin 100 times faster in Windows?
|
|
0
|
494
|
November 30, 2020
|
|
How did I fix «Host '<…>' is not allowed to connect to this MySQL server»?
|
|
1
|
491
|
September 28, 2020
|
|
How to order MySQL databases by size?
|
|
1
|
976
|
March 31, 2020
|
|
How do I remove a prefix from all tables in a MySQL database?
|
|
0
|
929
|
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.»
|
|
1
|
3787
|
March 7, 2020
|
|
How do I fix «The user specified as a definer ('<user>'@'%') does not exist»?
|
|
2
|
978
|
January 28, 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?
|
|
0
|
764
|
January 4, 2020
|
|
How to escape a single quote within a password of mysqldump?
|
|
0
|
790
|
December 5, 2018
|
|
How to change a MySQL user's password via phpMyAdmin?
|
|
0
|
1150
|
May 28, 2018
|
|
How to create a new database via phpMyAdmin?
|
|
0
|
1303
|
May 28, 2018
|