MySQL Create user authorization

A lot of libraries on the server, in order not to let a user mistakenly manipulate someone else's database, give him to build a separate user and authorization.

Insert into Mysql.user (Host,user,password, Ssl_cipher, X509_issuer, X509_subject) VALUES ("192.168.1.2", "Test", Password ("123"), ', ', ', ');

FLUSH privileges;
Grant all privileges the test.* to [e-mail protected] identified by ' 123 ';

How to get him to log in, can't let him on sh, install a phpmyadmin on his web, config file plus $cfg[' Servers ' [$i] [' host '] = ' 192.168.1.2 ';

Let him log in with Test 123 to manipulate the test library.

　　

MySQL Create user authorization