Problems connecting to database

Web hosting discussion, programming, and shared and dedicated servers.
3 posts Page 1 of 1
by brauerhaus » Sat Nov 25, 2017 12:13 pm
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
by drew.phillips » Mon Nov 27, 2017 10:17 am
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.
Drew Phillips
Programmer / System Operations, Sonic.net
by brauerhaus » Mon Nov 27, 2017 9:39 pm
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!
3 posts Page 1 of 1

Who is online

In total there are 25 users online :: 0 registered, 0 hidden and 25 guests (based on users active over the past 5 minutes)
Most users ever online was 999 on Mon May 10, 2021 1:02 am

Users browsing this forum: No registered users and 25 guests