Page 1 of 1

Access mysql from windows host

Posted: 1. Mar 2011, 18:37
by 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?

Re: Access mysql from windows host

Posted: 2. Mar 2011, 16:44
by vbox4me2
The root user must be added with the Host ip address or bind to all IP interfaces and add root as root@%