Linux XAMPP integrated environment mysqlroot password reset

1. Stop MySQL server

Sudo/opt/lampp/lampp Stopmysql

2, use the '--skip-grant-tables ' parameter to start the MYSQLD

Sudo/opt/lampp/sbin/mysqld--skip-grant-tables

3, then open a terminal (in the terminal directly right-click +b) into MySQL

Sudo/opt/lampp/bin/mysql-uroot

Will now go straight into MySQL

4. Connect MySQL Permissions Database

Use MySQL;

5. Change the password of the root user

Update user set Password=password ("123456") where user= "root";

6. Refresh the Permissions table (this step is required)

Flush privileges;

7. Quit MySQL

Quit

8. Restart MySQL Service

Sudo/opt/lampp/lampp Startmysql

Linux XAMPP integrated environment mysqlroot password reset