Login phpMyAdmin, change the password accidentally clicked on the generation (mysql4.1+ encryption), and I did not remember the generated password to do?

Source: Internet
Author: User
Tags administrator password mysql login phpmyadmin

There are wood people like Mexico, in the phpMyAdmin to set the administrator password, did not see clearly that the "build" is what to use, the hands of the cheap to click a bit, also instantly closed the browser, and then the tragedy?

When I found that I use the password I set to login not phpMyAdmin, and then the Black frame window can not enter the MySQL when I know just is my special hand cheap, to Baidu said method is to open the DOS window into the mysql/bin and then why do what, But I found out that my MySQL installation directory does not know why only data and ibdata1 are left. Well no nonsense, said the matter, see the data is still at my ease, so directly reload MySQL. The MySQL installation process is no longer said here, said the last step of the card at the start service, the reason is already installed on the MySQL computer already exists registration project, so the next thing to do is:

1. Uninstalling the MySQL application

2. Manually clean up the registration list

Command Window enter regedit to open the registration list (remove the three below to find out)

Hkey_local_machine/system/controlset001/services/eventlog/applications/mysql
Hkey_local_machine/system/controlset002/services/eventlog/applications/mysql
Hkey_local_machine/system/currentcontrolset/services/eventlog/applications/mysql

3, clean up the residual files, especially MySQL data files (this step I used to install WAMP, but this time did not find any residue)
1) The installation directory has remnants, manually deleted
2) Show hidden files and folders (Folder Options, view-and Show hidden files, folders, and drives), this is to avoid you can't find the directory, and then go to the installation directory to find it, Windows 7 Under MySQL data file in a hidden Programdata folder, or in a lazy way, in the search field, enter "MySQL", listing all the files and folders about MySQL.

4, reinstall MySQL, according to the normal process, the installation was successful.

Then there is a place to pay attention to, install to this step when you can choose the MySQL installation directory and data storage directory, such as the choice of data storage directory for D:/server/mysql, the system will automatically generate a folder after the installation, which is the database content , and put the data copy you backed up here. You can log in to your mysql,show databases look at the database you just copied into, can show out instructions on it. And then go with the user name, password you just installed MySQL login phpMyAdmin can also log in normally

Login phpMyAdmin, change the password accidentally clicked on the generation (mysql4.1+ encryption), and I did not remember the generated password to do?

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.