How to change the phpMyAdmin Password

Source: Internet
Author: User

The phpMyAdmin account is actually the account you use to access the MySQL database. What you need to know now is that phpMyAdmin, your website, and website database may not be on the same machine. If you only want to change the password, you can directly use phpMyAdmin to modify it. On the right-side page of phpMyAdmin, select "permission", find your users in the list, and click "edit" to modify them. However, if it is convenient, you can modify it on the MySQL database server. In this way, you can change the user name or password. You can log on to the MySQL database locally or remotely. In short, you can log on to the database as an administrator and then enter the following commands in sequence:> use MySQL; // open the database> Update user set user = 'new username 'where user = 'old Username ';> Update user SET Password = PASSWORD ("new password ") where user = 'new username';> flush privileges; // refresh the user permission table and the modification is successful.

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.