MySQL Rights Management

Yesterday just installed MySQL, playing a very happy, today is not linked, the error is:

Root user does not have permissions

Flipping through some articles, looking at the inconvenient, I briefly summed up:

One, add an account

The account is: test; the password is: 123456

Insert into Mysql.user (Host,user,password,ssl_cipher,x509_issuer,x509_subject) VALUES (

After the login is successful, no permissions are found for the target database, next:

Ii. Assigning permissions

Grant all privileges the mydays.* to [e-mail protected] identified by ' 1234 ';

Third, re-login

Mysql-h192.168.1.102-utest-p ' 1234 '

Results:

 for help. Type ' \c ' to clear the current input statement.mysql> show Databases; +--------------------+| Database           |+--------------------+| information_schema | | mydays             | | Test               |+--------------------+3 rows in Set (0.01 sec)