Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Installing MySQL and checking root password fails?

I recently uninstalled and reinstalled MySQL (on Windows 7) using the installer. When I try to set up the MySQL Server, it won't let me continue unless I enter the "current" root password??? I don't understand how there can be a current root password if I completely uninstalled and reinstalled the program.

I've tried with a blank password as well as every password I can possibly think of that I would have used and nothing works. Google is completely unhelpful as every result I've found either refers to a "homebrew" installation, whatever that is, or refers to installations on Linux. Is there some folder of config files that the uninstallation refuses to delete that I need to remove manually? Or am I missing something else?

image of problem because SO won't let you have pictures until you're popular

like image 961
Jess Avatar asked Jan 29 '19 19:01

Jess


People also ask

What is the root password for MySQL while installing?

The default user for MySQL is root and by default it has no password. If you set a password for MySQL and you can't recall it, you can always reset it and choose another one.

Could not connect to MySQL with the given password while installing?

Have you tried completely removing the software (from your drive, Firewall, the relevant ProgramData files, the registry), and then reinstalling it? Please do so, reboot your system and try starting the software.

Why MySQL is not working after entering password?

That could mean that the password is failing. Check CapsLock key.


1 Answers

After uninstallation process, please check following directories if it exists and remove:

  • C:\Program Files\MySQL
  • C:\Program Files (x86)\MySQL
  • C:\ProgramData\MySQL
  • C:\Users[User-Name]\AppData\Roaming\MySQL

PS: Please keep in mind that If you have multiple MySql Instances installed on your workstation, you need to go into each directory and delete only the relevant instance.

like image 87
Derviş Kayımbaşıoğlu Avatar answered Oct 14 '22 13:10

Derviş Kayımbaşıoğlu