Do I need additional rights to connect to mysql?

Question

MySQL

There is ubuntu14.04 it has mysql server installed, all default settings. I want to create a user in ubuntu and I need him to have access to mysql (in mysql he knows login/password). Question: will I need to additionally configure something or will it be able to do it automatically after creation?

Answer 1

You need to create a user in MySQL and give him rights to a specific database: https://dev.mysql.com/doc/refman/5.7/en/grant.html

Answer 2

After creating and restarting the server orFLUSH PRIVILEGES;