I have a MySQL database (not a MariaDB).
My configuration file is:
[Client]
user=root
password="qwerty123"
database=testdb
host=127.1
When connecting with DBInterface.connect(MySQL.Connection, "", "", ""; option_file="/home/me/.my.cnf", option_group="Client") I get the following error: LoadError: (1045): Access denied for user 'root'@'localhost' (using password: NO).
With command line mysql --table -e "SELECT * FROM Blahblah ORDER BY id ASC;"works as expected.
Also it seems to be that contrary to mysql command line utility, MySQL.jl reads configuration file case-sensitively, since I must specify option_group parameter for the Client group. Is it a bug or feature? Without that parameter I get the following error: LoadError: (2002): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2), which is worse than a normal access denied error.
I have a MySQL database (not a MariaDB).
My configuration file is:
When connecting with
DBInterface.connect(MySQL.Connection, "", "", ""; option_file="/home/me/.my.cnf", option_group="Client")I get the following error:LoadError: (1045): Access denied for user 'root'@'localhost' (using password: NO).With command line
mysql --table -e "SELECT * FROM Blahblah ORDER BY id ASC;"works as expected.Also it seems to be that contrary to
mysqlcommand line utility, MySQL.jl reads configuration file case-sensitively, since I must specifyoption_groupparameter for the Client group. Is it a bug or feature? Without that parameter I get the following error:LoadError: (2002): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2), which is worse than a normal access denied error.