Steps to retrieve the PHP database password
- 2020-03-31 21:26:50
- OfStack
Log in with your system administrator.
2. Stop MySQL service.
3. Enter the command window, and then enter the installation directory of MySQL, for example, my installation directory is c: MySQL, and enter c: mysqlbin
4. Skip the permission check to start MySQL,
C: mysqlbin> Mysqld - nt - skip - grant - tables
5. Reopen a window, enter the c:mysqlbin directory, and set a new password for root
C: mysqlbin> Mysqladmin-u root lave-privileges password" newpassword"
C: mysqlbin> Mysqladmin-u root-p shutdown
Replace newpassword with the root you want to use, and the second command prompts you for a newpassword, repeating the password from the first command.
6. Stop MySQL Server and start MySQL in normal mode
7. You can now use the new password to link to Mysql. :)
2. Stop MySQL service.
3. Enter the command window, and then enter the installation directory of MySQL, for example, my installation directory is c: MySQL, and enter c: mysqlbin
4. Skip the permission check to start MySQL,
C: mysqlbin> Mysqld - nt - skip - grant - tables
5. Reopen a window, enter the c:mysqlbin directory, and set a new password for root
C: mysqlbin> Mysqladmin-u root lave-privileges password" newpassword"
C: mysqlbin> Mysqladmin-u root-p shutdown
Replace newpassword with the root you want to use, and the second command prompts you for a newpassword, repeating the password from the first command.
6. Stop MySQL Server and start MySQL in normal mode
7. You can now use the new password to link to Mysql. :)