1. How to setup MySQL user privileges in phpMyAdmin?

Never use your root account and password when running databases. The root account is a privileged account which should only be used for admin procedures. And also unadvisable to add global MySQL server ...