MySQL add remote root administration
edit /etc/mysql/my.cnf
sudo vi /etc/mysql/my.cnf;
comment row bind-address = 127.0.0.1
restart mysql server
sudo /etc/init.d/mysql restart
ok, now grand privileges
sudo mysql
GRANT ALL PRIVILEGES ON * . * TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
now you should able to see new root user by
use mysql;
select host,
user from user;
it should be able to logon from other computer. anyway it has a secure concern.