Re: Test with auth_test_plugin

[Bogdan Degtyariov]

Hi VID Vuong,

Have you been able to log in using the same account from mysql command line on the same machine (assuming "localhost")?

Please remember that in MySQL the user account always has two parts:

- user name (in your case 'jtest1')
- host name (depends on the client host machine you use for connecting to MySQL Server)

Therefore, if the user 'jtest1' is intended to connect only from local host the account name should be 'jtest'@'localhost'.
The correct command for creating the user should be:

CREATE USER `jtest1`@`localhost` IDENTIFIED WITH test_plugin_server AS '123';

It also means that unless you create another user `jtest1`@`network_machine_name` trying to connect using TCP instead of localhost will not succeed even if machine is the same.