Im currently writing a small bash script that will automatically create databases, grant privileges, unzip a file and then import a sqldump...
Im having problems granting permissions to databases using cPanel
users, rather than root..
As I dont have root access to my companies servers, everything needs to be done using the cpanel users password.
Logging into MySQL (Using a cpanel users details) via ssh and running
GRANT ALL PRIVILEGES ON cpaneluser_db.* TO cpaneluser_dbuser@localhost IDENTIFIED BY 'dbuserpassword';
Always gives me Access Denies cpaneluser@localhost to cpaneluser_db (I have also tried GRANT SELECT, INSERT etc.)
Is there any way of granting persimissions to a database without logging in as root, and without having to go through cPanel itself? (As I dont have root access, I cant modify the mysql.user table).