Search code examples
mysqlmariadbpymysql

mariadb refuses connection with laptop in home network

I have MariaDB running on a Raspberry pi. My desktop that is connected by cable can access and manipulate data but my Laptop gets a:

OperationalError: (1045, "Access denied for user 'root'@'192.168.0.18' (using password: YES)")

I modified my.cnf to involve:

skip-networking=0
skip-bind-address

and configured mysql.user to listen to 192.168.0.%:

MariaDB [(none)]> select user, host from mysql.user where host <> 'localhost'
    -> ;
+------+---------------+
| user | host          |
+------+---------------+
| root | 192.168.0.%   |
+------+---------------+

Why am I still getting denied? (I have no Firewall running on the Raspberry Pi)

Solution

  • Mostly likely, connectionis denied because you mistyped the password. "Access denied for user 'root'@'192.168.0.18' (using password: YES)" , that message comes from the server.