Hello caspersql,
I am in the same situation you were with verio, except I have not used a local connection set up and I wanted to ask how you to make that happen.
And I have spent 90 minutes on hold with them multiple occasions, so I feel that pain.
I have just installed mysql on my local system.
Any shortcuts or instructions you can supply for a complete newbie on how to connect to the VCNSQL102 verio database from a local computer would be very appreciated.
Thank you.
Hi Tatay,
Yes their customer support is the worst I've ever experienced. As soon as I find time to move I'll be gone to another provider.
With regard to connection to the database, unfortunately the final answer I got was that a connection from a program running on your local system (e.g. mysql) is not possible. That was for a MS SQL database not a mysql database so it could be different for mysql, worth checking.
The way they require users to work with MS SQL databases is: log into the verio control panel at https://www.verio.com/controlpanel/beta/ you can see there are two different options for MySQL and MS SQL. I'm guessing if you're using mysql you'll want the former but I was working with the latter.
- Login to https://www.verio.com/controlpanel/beta/
- Click "MS SQL Database" under "Website"
- If you've created your database you should see it here (this is where I see the server name VCNSQL102).
- Click the login name for your database which is a hyperlink
- That brings you to a site where you can manage your MS SQL database. You can run scripts on it in the browser using the tools there.
However when I do the above right now it says 'service unavailable' - Verio just sucks. I'll submit a ticket about this now, bet there'll be no reply in 3 months time like with my other tickets. I did come across a few mysql articles on the Verio help site before which might be of use to you by searching for sql here - http://www.verio.com/knowledgebase/beta/
Hello caspersql,
Thank you for the reply.
Yes we were running mssql at Verio (still are but we are moving out and over to mysql as we speak), however we still need to access that database in the short term until we get all set up elsewhere. That's part of my project.
Did the script you posted above here work for you at Verio? (when the link was working, that is) I was not aware that was the only way to access the database, so thanks for that info that helps.
Also, We are moving to 1and1 hosting. They were rated among the top three of 2016 for hosting on several review sites, they have good pricing, equal or better services, AND they answer their phones. 🙂
PS the first week verio moved us over to the new platform, I put in two service tickets dated a week apart. In between my service ticket numbers were 8,200 other service ticket numbers. We are not alone.