Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Password from conf file never read #218

Open
jpietarinen opened this issue Mar 26, 2024 · 0 comments
Open

Password from conf file never read #218

jpietarinen opened this issue Mar 26, 2024 · 0 comments

Comments

@jpietarinen
Copy link

jpietarinen commented Mar 26, 2024

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 jpietarinen changed the title Password from conf file newer read Password from conf file never read Mar 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant