MySQL.jl icon indicating copy to clipboard operation
MySQL.jl copied to clipboard

Password from conf file never read

Open jpietarinen opened this issue 1 year ago • 0 comments

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.

jpietarinen avatar Mar 26 '24 14:03 jpietarinen