I am quite a beginner with MySQL, but I already got problems with setting up a connection. I tried to use MySQL Workbench, but I can't connect to the server. I use SparkyLinux, a Debian-based distribution. Here is what I did so far :
I created a user and checked that I could log in a console :
adrien@sahelantropus:~$ mysql -u adrien -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 6 Server version: 10.1.23-MariaDB-9+deb9u1 Debian 9.0 Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
(maybe it is interesting to notice I can either give my password or not, and log in with exactly the same output)
I tried to setup a connection with MySQL Workbench, but when I test it, I get the following output :
Failed to Connect to MySQL at 127.0.0.1:3306 with user adrien Access denied for user 'adrien'@'localhost'
I tried to use MySQL Connector in Python, and got the following exception :
1698 (28000): Access denied for user 'adrien'@'localhost'
I am sorry if something obvious is going on and I cannot see it, and I thank anyone who could help me.