Is setting up MySQL much harder on Windows than Linux?

Question

I have spent hours just trying to set up MySQL and still no success(on windows). I am starting to doubt my very name.

When I try to configure it says:

"The security settings could not be applied. Error Number 1045. Access denied for user 'root'@'localhost' (usin passwrd: NO)

And before it kept rejecting my password.

mysql-5.5.11-win32 + mysql-workbench-gpl-5.2.33b-win32 (for windows) — Adam, Apr 23 '11 at 01:26
I keep having issues with it. It's asking about this/that/etc. and in the end it chokes. I guess I might have to read all I can online.. — Adam, Apr 23 '11 at 01:33

score 1 · Answer 1 · edited May 23 '17 at 12:18

Use it, love it, stop wasting time and get programming!

OR YOU CAN TRY THIS....

If you actually have set a root password and you've just lost/forgotten it:

Stop MySQL Restart it manually with the skip-grant-tables option: mysqld_safe --skip-grant-tables

Run the MySQL client: mysql -u root

Reset the root password manually with this MySQL command: UPDATE mysql.user SET

Password=PASSWORD('password') WHERE User='root';

Flush the privileges with this MySQL command: FLUSH PRIVILEGES;

score 0 · Answer 2 · answered Apr 27 '11 at 08:40

0

I had this (frustrating) issue as well. What I did was:

Hope it works for you as well.

answered Apr 27 '11 at 08:40

Galz

2 Answers2