Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.


Syntax error when creating user

  • 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.

  • Paul

    There should be a database name after the ON:  (before the period)

    GRANT ALL PRIVILEGES ON testdb.* TO 'test'@'localhost';

  • Jakub Vrána
    Jakub Vrána

    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.