Access mysql from windows host

[billiam]

I'm trying to access the mysql server on my debian guest from a windows 7 host, and only recently stumbled on the 'make sure you use a host-only network to access mysql' tip, but have not gotten any further with it since. Currently getting this error:

Code: Select all

Access denied for user root@<hostip> (using password: Yes)

• The guest has both a nat and host-only network.
• Access denied when accessing over host-only network interface.
• Mysql's bind address is set to 0.0.0.0.
• I've tried setting root allow privileges for both % and my host ip in mysql.

Any suggestions, or any other information that would be helpful?

[vbox4me2]

The root user must be added with the Host ip address or bind to all IP interfaces and add root as root@%