MySQL Forums
Forum List  »  Install & Repo

Re: Need Help w. MYSQL 5.6 Install.
Posted by: Barry Galbraith
Date: March 18, 2014 04:59PM

The first time you install mysql, it creates a new mysql database.
Each successive time, it uses the old database and doesn't replace it with a new one.

What this means is, the first time you install mysql, and set a password for root, that root password will always remain there, so you will need to know/remember the root password to be able to change the root password.

If you can't remember the root password you have two options.

1. delete your existing mysql database and place a new fresh default mysql database in it's place, losing any data it contained, like usernames and passwords. By default, the mysql database is in c:\ProgramData\mysql\mysql server 5.6\data\ The c:\ProgramData folder is hidden by default. You'll need to unhide it. A fresh copy of the mysql database is provided in c:\Program files\MySQL\MySQL Server 5.6\data\mysql. It will contain root@localhost user with no password.

OR

2. reset root password. http://dev.mysql.com/doc/refman/5.6/en/resetting-permissions.html

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Need Help w. MYSQL 5.6 Install.
March 18, 2014 04:59PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.