How to reset an unknown `root` password in MySQL 8?
|
|
1
|
154
|
February 22, 2024
|
How did I fix «Plugin 'auth_socket' is not loaded» for MySQL?
|
|
1
|
175
|
February 22, 2024
|
How did I fix «Directory '/var/run/mysqld' for UNIX socket file don't exists» on `mysqld_safe`?
|
|
1
|
168
|
February 22, 2024
|
How do I stop `mysqld_safe`?
|
|
1
|
159
|
February 22, 2024
|
How did I fix «A mysqld process already exists» for `mysqld_safe`?
|
|
1
|
130
|
February 22, 2024
|
How to paste a tab-formatted SQL command into MySQL shell?
|
|
1
|
126
|
February 9, 2024
|
How to disable the «automatic rehashing» feature of `mysql` by default?
|
|
1
|
77
|
February 9, 2024
|
How to resolve the «TIMESTAMP with implicit DEFAULT value is deprecated» MySQL warning?
|
|
0
|
1597
|
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?
|
|
0
|
9183
|
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?
|
|
0
|
4267
|
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
|
1795
|
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
|
2897
|
April 29, 2017
|
My my.ini for my localhost-only Windows machine
|
|
0
|
2456
|
April 30, 2017
|
How to connect to MySQL from Cygwin?
|
|
1
|
519
|
February 9, 2024
|
How to allow remote connections to a MySQL server?
|
|
0
|
857
|
February 22, 2018
|
How to set a custom location of the primary MySQL configuration file (`my.cnf` / `my.ini`)?
|
|
1
|
88
|
February 9, 2024
|
How to find big tables of a MySQL database?
|
|
2
|
766
|
January 8, 2024
|
How do I transfer MySQL to a new Windows workstation?
|
|
1
|
245
|
June 1, 2023
|
How do I register an administrator in WordPress via SQL?
|
|
1
|
102
|
December 4, 2023
|
How did I fix «Unknown collation: 'utf8mb4_0900_ai_ci'» on importing a `*.sql` dump to MySQL?
|
|
1
|
127
|
December 4, 2023
|
How did I fix «update-alternatives: error: alternative path /etc/mysql/mariadb.cnf doesn't exist»?
|
|
1
|
272
|
October 19, 2023
|
How to fix «EXPKEYSIG 8C718D3B5072E1F5»?
|
|
1
|
1000
|
August 7, 2023
|
How did I upgrade MySQL on Debian 10?
|
|
1
|
174
|
August 7, 2023
|
How to fix «gpg: keyserver receive failed: Server indicated a failure» for ``keys.gnupg.net?
|
|
2
|
803
|
August 7, 2023
|
How did I fix «key 8C718D3B5072E1F5» / «duplicate signatures removed» / «unchanged: 1» on Debian 10 (Buster)?
|
|
1
|
243
|
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
|
200
|
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
|
547
|
August 7, 2023
|
How do I transfer phpMyAdmin to a new Windows workstation?
|
|
1
|
163
|
June 27, 2023
|
How to remove the «SSL context is not usable without certificate and private key» warning for a localhost-only MySQL server?
|
|
0
|
5176
|
April 30, 2017
|
How to fix «Failed to install the service» on `mysqld --install`?
|
|
1
|
166
|
June 7, 2023
|