- problem display:
solution Enter MySQL from the command line
start MySQL service:
net start MySQL login MySQL:
MySQL - U root - P password View user information:
select host, user, plugin, authentication_ string from mysql.user;
modify user password:
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
Connection successful
Read More:
- Nginx Error:HTTP 1.0 client does not support chunked response
- Error: unrecognized command line option “-std=c++11”, to solve the problem that ubuntu does not support c++11
- The MAC system installs MySQL client, and the error is solved_ config not found
- Solve the problem that node. js USES MySQL to connect econnunion 127.0.0.0.1:3306
- Linux-mysql8.0 password reset problem – error 1396 (HY000): Operation alter user failed for ‘root’ @’localhost ‘
- MySQL: if the remote connection using navicatip fails, prompt “is not allowed to connect to this MySQL server”
- Solve the problem of MySQL database report 1055 error
- Solve the problem that dbvisualizer cannot connect to mysql8
- How to solve the problem of “08001” when JDBC connects to MySQL
- [MySQL] [serialize] [error record] after modifying data, no data will be returned (in fact, MySQL does not support it)
- How to Solve MacOS Big Sur MySQL workbench flashback problem
- Solution to MySQL Error 1130 problem
- Solve the problem of error loading MySQL DB module. Encountered during Django project
- Solve MySQL error 1698 (28000): access denied for user ‘root’ @’localhost ‘
- MySQL startup problem (ERROR 1045 (28000): Access denied for user’ODBC’@’localhost’ (using password: NO))
- MySQL installation failed: dpkg: error processing package MySQL server (- – configure): dependency problem
- Solve net start mysql, start MySQL service, prompt system error 5. Access denied.
- Mysql Error:The user specified as a definer (‘mysql.infoschema‘@‘localhost‘) does not exist
- Solve MySQL installation error: initializing database prompts an error when installing mysql
- Arduino reports an error when writing a custom library file to solve the problem of not name of type, not declared in this scope