Today, I came to phpstudy. I found that MySQL could not be opened and reported this error. After a round of search, I solved the problem
Modify mysql.ini
sql_ mode =‘STRICT_ TRANS_ TABLES,NO_ ZERO_ IN_ DATE,NO_ ZERO_ DATE,ERROR_ F
OR_ DIVISION_ BY_ ZERO,NO_ AUTO_ CREATE_ USER,NO_ ENGINE_ ‘
I solved it like this. It depends on whether you can do it or not
Others have provided the following solutions
1. Phpstudy upgrade, SQL_ Mode is followed by more spaces. Just delete the spaces
2、 Directly annotate SQL_ Mode line content（ After I do this, MySQL starts and then stops, and goes back and forth ε=( ´ ο｀*))) Alas)
3、 Remove SQL_ No in mode_ AUTO_ CREATE_ USER
4、 SQL_ mode = NO_ AUTO_ CREATE_ USER,NO_ ENGING_ SUBSTITUTION
All the above are modified in mysql.ini
Read More:
- MySQL creates tables and sets auto increment of primary keys
- MySQL skip grant tables add user error 1290
- [resolved] superset failed to create admin user: error! User already exists user or attributeerror: ‘nonetype’‘
- How can Oracle query tables of other users without adding a table user name
- Failed to read auto-increment value from the storage engine in MySQL
- Problem solving module ‘ tensorflow.compat . V2 ‘has no attribute’ contrib ‘and importerror cannot import name’ auto ‘
- Error 1045 (28000): solution to access denied for user ‘root’ @’localhost ‘(using password: no)
- Error 1045 (28000): access denied for user ‘root’ @’localhost ‘(using password: no)
- [MySQL] error 1396 (HY000): Operation create user failed for ‘MySQL’ @’localhost ‘
- ERROR 1045 (28000): Access denied for user’ODBC’@localhost (using password: NO)209150;’211503;’
- MySQL startup problem (ERROR 1045 (28000): Access denied for user’ODBC’@’localhost’ (using password: NO))
- Error 1396 (HY000): Operation create user failed for ‘xxx’ @’xxx ‘
- Pg_dump Error: pg_dump: No matching tables were found，pg_dump: schema with OID 1515227 does not exi
- Uncaught error: call to undefined function MySQL when building sqli lab environment with phpstudy_ Connect() error
- Failed to create agent because there is no valid NavMesh
- sqoop-import ERROR tool.ImportTool: Import failed: No primary key could be found for table user_info
- -bash: cannot create temp file for here-document: No space left on device
- standard_init_linux.go:178: exec user process caused “no such file or directory”
- Create a new project in pycharm: modulenotfounde rror:No module named ‘distutils.util‘
- ER_ACCESS_DENIED_ERROR: Access denied for user ‘root‘@‘localhost‘ (using password: NO)