Access to MySQL server via VirtualBox
Solution 1:
The root account's localhost-only in the vast majority of default installations, are you certain you've allowed it to log in from the other system? From the MySQL reference manual:
it means that there is no row in the user table with a Host value that matches the client host
So, there's no %
or 10.0.2.2
in the Host
column at all. Check your current config:
select user,host from mysql.user where user='root';
You likely want to create a new root entry with the same password as you have now.
create user 'root'@'10.0.2.2' identified by 'yourpassword';
grant all privileges on *.* to 'root'@'10.0.2.2' with grant option;
flush privileges;