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