I have setup remote mysql in cpanel with external server but when accessing database from phpmyadmin with user privilleges is very slow. I can access normal phpmyadmin from WHM. Any help apreciated.
Remote database access will always be slow than the normal one. It depends on your connection speed and the intermittent hops as well. With WHM >> phpMyAdmin, the data is fetched locally so it is going to be faster.