MySQL Forums
Forum List  »  Connector/ODBC

Re: Test with auth_test_plugin
Posted by: Bogdan Degtyariov
Date: October 22, 2018 12:42AM

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.

Options: ReplyQuote

Written By
October 05, 2018 01:39AM
Re: Test with auth_test_plugin
October 22, 2018 12:42AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.