Im trying to use the remote function of MYSQL that plesk 8 has. I cannot get it to work. The mysql is on another box and i can telnet via port 3306. Also on plesk i put the logins as root to the other MYSQL server and not matter what it says:

Access denied for user 'root'@'IP' (using password: YES)

Can someone help here? Why doesnt plesk connect? What else should i check or do on the server where mysql is, how the hell doesnt it allow as ROOT user to have all priviligies?

By default remote connections to a mysql db are disabled. To enable it, in the user table in the mysql database, you need to add the user root@remote_ip for it to allow access. In other words... im connecting to 1.1.1.1 FROM 2.2.2.2. So in 1.1.1.1 I would add the user root@2.2.2.2 to mysqld.

You also mentioned its plesk, I believe plesk uses the mysql user admin, not root. So you might want to try that first.

How do i do that on the command line?
Also, just the machine that will access the MYSQL is a Plesk server. The box where the MYSQL is stored is not, and has root as user.

Use phpmyadmin, login with the admin/root user, privileges.....

log into mysql:
mysql -u admin -p

and use:
GRANT USAGE ON *.* to admin@'remote_ip_goes_here' IDENTIFIED BY 'newpassword';
FLUSH PRIVILEGES;

You will need to log in via phpmyadmin and update the grant tables because admin@localhost and admin@remotehost get viewed as separate users.