1. Version
1) Operating system version
cat /proc/version
Linux version 3.10.0-957.1.3.el7.x86_ 64 ( [email protected] ) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-36) (GCC) ) #1 SMP Thu Nov 29 14:49:43 UTC 2018
2) Database version
mysql –version
mysql Ver 8.0.13 for linux-glibc2.12 on x86_ 64 (MySQL Community Server – GPL)
2. Problem description
In versions after 5.7.6, MySQL will be generated in the error log after initialization (specify the — initialize parameter for initialization) root@localhost Temporary password for the user. However, in this deployment, after starting mysql, it was found that no temporary password was generated in the errorlog
3. Problem solving
Later, it was found that the file in/etc/my.cnf was accidentally deleted log_ The error parameter is commented out, so that when initializing the instance, all information is sent to the standard output. When MySQL is started, it is based on the log_ The default value of error generates a log_ error
Read More:
- MySQL master-slave replication. An error is reported when starting slave. Slave failed to initialize relay log info structure from the repository
- MySQL error — multiple methods of failed to find valid data directory and MySQL setting password appear
- MySQL password setting error message: error 1054 (42s22): unknown column ‘password’ in ‘field list’
- Centos7 forgot the root password and could not log in to the system
- SQL Server 2005, unable to log in, forget sa password, 15405 error!
- 26 English letters in upper and lower case and 0-9 to generate 8-bit random password
- MySQL error 1054 (42s22) unknown column ‘password’ in ‘field list’
- MySQL 8 — error in setting simple password error 1819 (HY000): your password does not satisfy the current policy requirements
- Error 1064 in MySQL password change
- Springboot uses druid to log in MySQL. An error occurred: access denied: errorcode 1045, state 28000
- Linux-mysql8.0 password reset problem – error 1396 (HY000): Operation alter user failed for ‘root’ @’localhost ‘
- Error (1820) if the password is not changed in time after MySQL installation
- MySQL startup problem (ERROR 1045 (28000): Access denied for user’ODBC’@’localhost’ (using password: NO))
- MySQL forgot the root password
- In vs2013, reshharper and team management plug-in git share a temporary solution to the “failed modify to document” error.
- Modify the password of mysql8 on Windows
- Build LNMPR Error — php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution
- MYSQL:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- MySQL ERROR 1054 (42S22): Unknown column’password’ in’field list’ error
- Failed to decrypt protected XML node “DTS:Password” with error 0x8009000B “Key not valid for use in …