Connect to MySQL on Laptop using Raspberry pi

[Shantanu24]

Hi.
I have a MySQLdb running on my Ubuntu Laptop. I have created a database.
I need to access this database on my laptop from my Raspberry pi.

I have installed PyMySQL on my raspberry pi. I have also configured the mysqld.conf file in my laptop and commented out the bind address line.

But eherytime i use the following command on my RPi

Code: Select all

conn = pymysql.connect(host='192.168.10.7', port='3306', user='root', passwd='password', db='temps')

192.168.10.7 is my laptop ip address. This IP address can be pinged from my RPi.

but i get error

Code: Select all

[code]pymysql.err.InternalError: (1130, "Host '192.168.10.7' is not allowed to connect to this MSQL server")

[/code]

Do I need to make anymore changes in the configuration? If yes, can you please guide me?

[omegaman477]

By default MySQL users are created so that they can only login from localhost. I suspect that is your issue.

Either specify a hostname for the user account, or use the % wildcard for any host.

[url]See: https://dev.mysql.com/doc/refman/5.7/en ... users.html[/url]

[DougieLawson]

You a) need to ensure MySQL is listening on the INADDR_ANY (0.0.0.0) address not localhost and b) that you've got a user defined that can be used from any machine on your LAN.

viewtopic.php?p=1045126#p1045126