(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.