When setting up a database for a new cloud server we were told it couldn’t be accessed by Navicat etc, so we were lumped with phpMyAdmin, and that we couldn’t have seperate users, everything had to be in root. Continue reading “Setting MySQL User Passwords and Permissions Via Command Line”