Home
About Me
Résumé
Portfolio
DevOps
C/C++
Drupal
Java
PHP
Ruby
Symfony
WordPress
Blog
Astronomy
Fitness
Photography
RDBMS
Technology
WWF
Pictures
Instagram
Galleries
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
Contact
Search for:
Search Button
Home
About Me
Résumé
Portfolio
DevOps
C/C++
Drupal
Java
PHP
Ruby
Symfony
WordPress
Blog
Astronomy
Fitness
Photography
RDBMS
Technology
WWF
Pictures
Instagram
Galleries
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
Contact
Search for:
Search Button
DevOps
Software Development
MySQL
August 1, 2022
Table of Contents
MTOP
User Account Management
Database Design
Database Normal Forms
MySQL Tuning
MySQL Configuration (my.cnf)
MySQL Option Files
MySQLTuner
MacOS
CentOS
Table ‘query_log’ is marked as crashed and should be repaired
ERROR! The server quit without updating PID file
MySQL – Convert all Tables of one or more Database(s) from MyISAM to InnoDB and vice-versa
Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
Index column size too large. The maximum column size is 767 bytes.
ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.
ERROR 1839 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ON
InnoDB Engine Tables shows incorrect table_rows counts.
ERROR 1366 (HY000) at line 3019: Incorrect string value: ‘\xF0\x9F\x98\x8A
MySQL 5.7 won’t start after brew upgrade
Workbench won’t connect to my localhost
Table ‘performance_schema.session_variables’ doesn’t exist
How to change password policy
ERROR 1067 (42000) at line 57: Invalid default value for ‘comment_date’
Find all my.cnf by order of preference
Workbench Connections using old authentication protocol
Workbench look and feel
MySQL is down and won’t start
MySQL is down and server running at 100% capacity
Converting all Tables of one or more Database(s) from MyISAM to InnoDB and vice-versa
ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.
mysql-upgrade access denied
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files
[ERROR] Unix socket lock file is empty /tmp/mysql.sock.lock
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement
MySQL won’t allow ROOT to login remotely
MySQLi does not seem to retain db connection from query to query
MySQL Workbench wants to use your confidential information
MySQL Process List
[Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
Error Code: 1292. Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘order_date’ at row 111
Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation ‘=’
Installing MySQL 5.7 on MacOS
How to import MyISAM databases from physical files
How to import InnoDB databases from physical files
Escaping a reserved symbol with regular expressions
install_driver(mysql) failed: Can’t load module DBD::mysql
Error Code: 1215. Cannot add foreign key constraint
Error Code: 1701. Cannot truncate a table referenced in a foreign key constraint
SQL Queries with Joins are very slow
Error Code: 1292. Truncated incorrect datetime value: ‘0000-00-00’
[ERROR] InnoDB: The Auto-extending innodb_system data file…
[ERROR] Can’t find error-message file ‘/usr/local/share/mysql/errmsg.sys’…
ERROR 1018 (HY000): Unknown error 1018
[Warning] File Descriptor 1725 exceeded FD_SETSIZE=1024
Migrating dbs from server to server
Unable to connect to CentOS MySQL server via SSH
Shared object “libreadline.so.8” not found, required by “mysql”
Error: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
mysqli_connect: authentication method unknown to the client [caching_sha2_password]
Uninstalling MySQL 8.0
Unable to access my websites while MySQL is recovering from crash
MySQL Keeps Crashing due to out of memory
Time is off
mysqldump: Got error: 1449: The user specified as a definer (‘puma’@’localhost’) does not exist when using LOCK TABLES
mysqldump: Couldn’t execute ‘show events’: Unknown error 1044 (1044)
Database 4 byte UTF-8 support – Enabled, but database tables need conversion
Error Code: 1093. Unknown error 1093
Locations
Access denied for user ‘rom’@’205.211.94.206’ (using password: {{ PASSWORD }}
time_zone inconsistencies
Creating databases permissions
Master-Slave Replication
a. Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.
b. [Warning] Neither –relay-log nor –relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use ‘–relay-log=www-db-relay-bin’ to avoid this problem
c. Replication not working
d. Disabling replication
Binary Log Cleanup
Binary Log Management
MySQLDump excluding tables
Granting privileges
7.1.4 GRANT Statement
GRANT General Overview
Object Quoting Guidelines
Privileges Supported by MySQL
Account Names and Passwords
Global Privileges
Database Privileges
Table Privileges
Column Privileges
Stored Routine Privileges
Proxy User Privileges
Implicit Account Creation
Other Account Characteristics
MySQL and Standard SQL Versions of GRANT
Error Code: 1147. There is no such grant defined for user
mysql-connector-java-5.1.26-bin.jar, but this file/folder was not found.
Storing root password
Restoring performance_schema
Unable to restore Drupal on CentOS
dyld: Library not loaded
Reinstalling MySQL 5.7 on MacOS
MySQL on CentOS running at max memory capacity
Unable to restore Drupal on CentOS (2)
InnoDB vs MyISAM
Implement SSL/TLS encryption
DB: 127.0.0.1
WordPress Solution
Drupal Solution (Not yet found)
DB: victordiaz.ca
DB: development-{{ HOST_NAME }}
[Warning] Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed
[ERROR] SSL error: Unable to get private key from SSL/TLS certificate
Access denied for user ‘test’@’10.1.0.102’
Error Code: 1138. Invalid use of NULL value
ERROR 1273 (HY000) at line 145: Unknown collation: ‘utf8mb4_0900_ai_ci’
mysqldump some tables
Unknown system variable ‘validate_password_policy’
Case Sensitivity Issues
Resetting Root Password
Error [InnoDB] Unable to lock /var/lib/mysql/ibdata1 error: 11
Unable to login without sudo
Invalid datetime format: 1292 Incorrect datetime value: ‘0000-00-00 00:00:00’
slow.log analysis
SQL-MODE
utf8mb4_general_ci VS utf8mb4_unicode_ci
.my.cnf conficts
mysqldump best practices
mysql options
Error Code: 1267. Illegal mix of collations
MySQL 8.0
MacOS Upgrade
CentOS Upgrade
MySQL 8.0 – Failed! Error: File ‘./mysql/user.MYD’ not found
MySQL 8.0 – Failed! Error: Can’t find file: ‘proxies_priv’
MySQL 8.0 – Host ‘127.0.0.1’ is not allowed to connect to this MySQL server
Problem 1:
Solution 1:
Problem 2:
Solution 2:
Problem 3:
Solution 3:
MySQL 8.0 – Error Code: 1193. Unknown system variable ‘validate_password_policy’
MySQL 8.0 – [Warning] [MY-012152] [InnoDB] Open files 1030 exceeds the limit 1024
MySQL 8.0 – victordiaz@127.0.0.1 on using SSL/TLS – Access denied
MySQL 8.0 – ERROR 1064 (42000) at line 1: You have an error in your SQL syntax
MySQL 8.0 – Please confirm O_DIRECT is supported and remove the file /var/lib/check_sector_size if it exists
MySQL 8.0 – MY-001126 – Can’t open shared library ‘/usr/lib/lib/mysql/plugin/component_validate_password.so’
MySQL 8.0 – Validate Configuration
MySQL 8.0 – Host ‘10.3.0.14’ is blocked because of many connection errors: unblock with ‘mysqladmin flush-hosts’
MySQL 8.0 – PDOException: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client in drupal_is_denied()
MySQL 8.0 – mysqld: Can’t read dir of ‘/etc/my.cnf.d’
MySQL 8.0 – mysql.cnf for mariadb.cnf
MySQL 8.0 – PDOException: SQLSTATE[42000]: Syntax error or access violation
With MySQL 5.7 this is not a problem
Uninstalling MySQL
On MacOS
On CentOS
On Debian
MySQL 8.0 – Logs
MySQL Table Format does not work with SSH
group_concat has max of 1024 characters
MySQL with SSH – Escaping
MySQL 8.0 – Package ‘mysql-server’ has no installation candidate
[ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
MySQL 8.0 – System tables (TO BE COMPLETED)
Master-Slave Replication – Appearances are deceiving
mysql not found
Unable to connect from romlx777 to 10.3.5.10
MySQL INSERT … ON DUPLICATE UPDATE – Adds one to the autoincrement
Transpose Output
Connecting to GE MySQL Container
devops
,
MySQL
,
software development
Written By victord On August 1, 2022