Code: Select all
GRANT USAGE ON tntspacebuild_phpmyadmin.* TO 'pma'@'localhost' IDENTIFIED BY '[redacted]';
GRANT SELECT (
Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
Execute_priv, Repl_slave_priv, Repl_client_priv
) ON tntspacebuild_phpmyadmin.user TO 'pma'@'localhost';
GRANT SELECT ON tntspacebuild_phpmyadmin.db TO 'pma'@'localhost';
GRANT SELECT ON tntspacebuild_phpmyadmin.host TO 'pma'@'localhost';
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
ON tntspacebuild_phpmyadmin.tables_priv TO 'pma'@'localhost';
#1044 - Access denied for user 'tntspacebuild'@'localhost' to database 'tntspacebuild_phpmyadmin'
It happens both in phpMyAdmin, and in the mysql CLI program from SSH. I'm not too handy with SQL, I might just be being a derp, thought it seems like my user can't make other users. Is this the case, and should I just plug in the tntspacebuild user into the config storage field?
What I'm trying to do: http://www.phpmyadmin.net/documentation/#linked-tables