MySQL 1044 workaround

Today, when I was learning MySQL, I found a problem;

I authorized a tiger user with the root user;

But the landing time reported 1044 error;

I started the authorization when this:

GRANT all privileges in root. * to [e-mail protected] identified by ' 123456 ';

Root is the name of the current database;

Then I landed normal, but the new database when the error 1044;

Later, Baidu found the original name of the database has been written wrong;

Re-authorize once

GRANT all privileges in *. * to [e-mail protected] identified by ' 123456 ';

On the OK pull;

Note:

You can also authorize a single table Root.user

GRANT all privileges on root.user to [email protected] identified by ' 123456 ';