Re: ERROR 1045 (28000): Access denied for user '=root'@'localhost'

[Peter Brawley]

Your "home computer" is the Surface Pro 3? Running Win 10 Pro?

You installed what version of MySQL? Using the MySQL Windows installer? Did it give you any error messages? If so what were they? Otherwise, is the MySQL service running, ie is it listed as running in services.msc?

If it is running, let's see the command you are using to start the mysql client program.

> 4. Started MySQL in command mode: MySQL -u=root -p

That is not starting MySL in command mode. That is starting the MySQL client program mysql.exe.

And IAC the syntax would be wrong for the client program. If the server has been started with --skip-grant-tables. syntax is ...

mysql -uroot

...or...

mysql -user=root

If the server is not running with --skip-grant-tables, add -p to the cmd.

To start the MySQL server with --skip-grant-tables via commandline ...

mysqld --defaults-file="full_path_to_my.ini" --skip-grant-tables

More detailed instructions at