Hi. I might be completely illiterate here, but I'm getting this whenever I'm creating a new user for my MySQL database:
Running Adminer 3.3.4 on Debian 5 64-bit
MySQL version: 5.1.63-0+squeeze1 through PHP extension MySQLi
Thanks for any help.
There should be a database name after the ON: (before the period)
GRANT ALL PRIVILEGES ON testdb.* TO 'test'@'localhost';
You should fill the object you are giving privileges to in the Privileges input (prefilled by .*), e.g. testdb.* for database testdb or testdb.testtable for a single table. If you use the link Privileges from the database overview then this field is prefilled.