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.

Close

Syntax error when creating user

Help
2012-06-25
2013-06-06
  • 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
    Paul
    2012-06-26

    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
    2012-06-29

    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.