You will need to give root@localhost a password
Since you just installed mysql, you are running with default settings, this means you have no my.cnf. You will have to create one.
Run the following at a DIS Prompt
cd C:\Program Files\MySQL\MySQL Server 5.5
dir *.ini
There, you will see sample .ini
files. Let's pick my-small.ini
net stop mysql
cd C:\Program Files\MySQL\MySQL Server 5.5
copy my-small.ini my.ini
cd data
del ib*
notepad my.ini
Once you open notepad, add this under the [mysqld] header
[mysqld]
skip-grant-tables
Close notepad and Save my.ini
Next, run these lines
net start mysql
mysql (hit enter)
You will get a mysql prompt. Now run this:
mysql> UPDATE mysql.user SET PASSWORD=PASSWORD('mysecretpassword') WHERE user='root' AND host='localhost';
exit
Back at the DOS Prompt, do this:
net stop mysql
notepad my.ini
Once Notepad is open, delete the line skip-grant-tables
from my.ini
Close notepad and Save my.ini
net start mysql
Once mysql is back up, test the password at the DOS prompt
mysql -uroot -p (hit enter)
Password: (type mysecretpassword and hit enter)
If you get the mysql prompt, CONGRATULATIONS !!! You installed a password for root@localhost
Go back to MySQL Workbench and user mysecretpassword
as the password
Give it a Try !!!
Thanks Mika, I tried your solution in workbench (5.2.41). It worked after I cleared the passwords in the vault (click Manage Connections
) and restarted the WorkBench.
To clear passwords stored in the vault, I did the following:
- Open MySQL WorkBench the you will see the home page
- Click Manage Connection at bottom left corner.
- In Manage DB Connections, click Clear button besides Store in Vault...
- Close it and restart WorkBench.
- Double click Local instance mysql in home page, now you db will popup.
Best Answer
It looks like you are creating a New Server Instance Profile, not a New Server Instance.
If you installed MySQL already, then go to the DOS Prompt and run
or
Start Service
To verify that MySQL is running on the Windows 7 machine,
Start Task Manager
Processes
Tabmysqld
Once you have MySQL running on the Windows machine, you can go to to create a Server Instance Profile. The key here is to install MySQL first.