Page 1 of 1

Problems connecting to database

Posted: Sat Nov 25, 2017 12:13 pm
by brauerhaus
Hello,

I recently set up a database and while I can connect using the phpMyAdmin tool, I am unable to connect remotely using a python script. (The script works when connecting to an identical remote database.) The error I'm getting looks like a permissions error, and when I look at privileges for my database I see that there are no privileges for any of my db accounts . Attempts to grant privileges are not allowed. Can anyone help me resolve this?

Thanks,
Matt

Re: Problems connecting to database

Posted: Mon Nov 27, 2017 10:17 am
by drew.phillips
Hi Matt,

From where are you running the Python script? Database connections to our MySQL server are only permitted from the hosting platform and shell server. If you're trying to connect from anywhere else, it will not work.

Re: Problems connecting to database

Posted: Mon Nov 27, 2017 9:39 pm
by brauerhaus
Ah, that explains it.

I was hoping to store some data on a Sonic db as a backup, but I think I'll need to get more creative to do this.

Thanks!