The reason that we get this error in mysql when a remote machine tries to connect to mysql server is that by default mysql does not support remote access.

So, we need to specify the details of the host machine in the mysql server (the actual machine where mysql runs).

So, my machine’s IP is 192.168.1.10 and my friend’s machine (in which mysql runs is 192.168.1.20)

$ mysql -u root -p mysql> use mysql; mysql> grant all privileges on *.* to arun@192.168.1.10 identified by 'orange' with grant option; mysql> exit

If you are not sure of the hostname, just replace the 192.168.1.10 with ‘%’