search

datacharmer / test_db

A sample MySQL database with an integrated test suite, used to test your applications and database servers
4.06k stars 2.59k forks source link

Access/permissions rights denied #11

Closed daddydrac closed 5 years ago

daddydrac commented 5 years ago

After I run:

$ mysql < employees.sql

I get this error:

ERROR 1044 (42000) at line 25: Access denied for user ''@'localhost' to database 'employees'

datacharmer commented 5 years ago

This error means that your database server has anonymous users enabled, which should be removed. Use mysql_secure_installation to remove them and then connect using a named user.