Heya. I just put phpMyAdmin up to check up on the databases for the wiki and web bans system I have running on my webspace. Though, it says to enable extended functions and saving preferences, I need to make another SQL user that has limited privileges to a seprate DB. Well, I made one, tntspacebuild_phpmyadmin, and tried to run this series of queries on it:
Code:
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';
However, it throws this on the first line:
#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
Login
Register
FAQ
Search
