Thanks for the help. After trying what you suggested, I still couldn't connect to it. Neither cloud my python application. But I can connecct to MariaDB within terminal.
EDIT: When I use the connecter provided by MariaDB, I can connect to the database from my Python app. But when I use the method described here, I got connection refused error.
Have you ever worked with MariaDB+SQLAlchemy? Love to hear how you work arond with it.
Just to be clear, is your python app running in WSL or Windows?
Also, did you add the line bind-address=0.0.0.0 in your /etc/mysql/my.cnf?
I don't know your connection config, but double-check you are using the same host. 127.0.0.1 and localhost is not the same nor always interchangeable.
It's hard to tell what the problem is based on what you described, but I can try and replicate if that's also the case on my machine.
Update: OK I just tried, and it seems that with the latest WSL2 and MariaDB the bind-address=0.0.0.0 in /etc/mysql/my.cnf is no longer necessary. I can connect to my MariaDB from both WSL and Windows app with sqlalchemy and pymysql.
OK. I think not being able to connect from datagrip and sqlalchemy is related.
MariaDB is running on WSL2 and I am able to connect to it from the terminal. I created admin user with root privilege.
MariaDB [(none)]> select user, host from information_schema.processlist;
+-------+-----------+
| user | host |
+-------+-----------+
| admin | localhost |
+-------+-----------+
1 row in set (0.000 sec)
I'd love to provide you with more detail. Here is my my.cnf:
[client-server]
# Port or socket location where to connect
# port = 3307
socket = /run/mysqld/mysqld.sock
# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
I tried both what you described in this blog post and not binding the address. Both not working.
Would you mind share your my.cnf with me?
Thanks for the help. After trying what you suggested, I still couldn't connect to it. Neither cloud my python application. But I can connecct to MariaDB within terminal.
EDIT: When I use the connecter provided by MariaDB, I can connect to the database from my Python app. But when I use the method described here, I got connection refused error.
Have you ever worked with MariaDB+SQLAlchemy? Love to hear how you work arond with it.
Just to be clear, is your python app running in WSL or Windows?
Also, did you add the line
bind-address=0.0.0.0
in your/etc/mysql/my.cnf
?I don't know your connection config, but double-check you are using the same host.
127.0.0.1
andlocalhost
is not the same nor always interchangeable.It's hard to tell what the problem is based on what you described, but I can try and replicate if that's also the case on my machine.
Update: OK I just tried, and it seems that with the latest WSL2 and MariaDB the
bind-address=0.0.0.0
in/etc/mysql/my.cnf
is no longer necessary. I can connect to my MariaDB from both WSL and Windows app with sqlalchemy and pymysql.OK. I think not being able to connect from datagrip and sqlalchemy is related.
MariaDB is running on WSL2 and I am able to connect to it from the terminal. I created
admin
user with root privilege.I'd love to provide you with more detail. Here is my
my.cnf
:I tried both what you described in this blog post and not binding the address. Both not working.
Would you mind share your
my.cnf
with me?Here is my complete setup:
Clean uninstall:
Then
Start the service:
Config by following this
edit
/etc/mysql/my.cnf
(optional)Then restart mariaDB:
sudo service mysql restart