MySQL setting to approve access from other client

(Server)

mysql>use mysql

mysql>INSERT INTO user (Host, User, Password) VALUES ('localhost','new_id',password('passwd'));

mysql>INSERT INTO user (Host, User, Password) VALUES ('%','new_id',password('hadoop'));

mysql> create database hadoop;

mysql> grant all privileges on hadoop.* to new_id@localhost identified by 'passwd';

mysql> grant all privileges on hadoop.* to new_id@'%' identified by 'passwd';

mysql> flush privileges;

done!!!

(Client)
# mysql -h server_ip -u new_id -p

Now you should be able to access to MySQL server.