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

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.