Linux system using XAMPP lost MySQL root password can only be accessed remotely, the database cannot be connected locally

If you use XAMPP in this integrated development environment under Ubuntu, forget the MySQL password.

When there is only remote access, local unreachable, usually host changed to% remote access, local access to one is empty shell. This is a matter of permissions

Need to fix the% of host change to localhost

or delete the user table and re-import one to access it normally

Note: The newly installed xampp mysql initial password is empty ...

The steps to retrieve the password are as follows:

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

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

OK now you can log in to mSQL using the password you just set.

Linux system using XAMPP lost MySQL root password can only be accessed remotely, the database cannot be connected locally