Forum Replies Created

Viewing 15 replies - 1 through 15 (of 16 total)
  • Thread Starter calvinfold

    (@calvinfold)

    Due to a lack of info/support for Mac users for mySQL, and me just not finding time to learn to do it myself, I’ve had to abandone the idea of a blog for now.

    Thanks to everyone for your attempts to help.

    Thread Starter calvinfold

    (@calvinfold)

    I hate to be a pest but I’m kinda outa my league here. So there is no secure way to access MySQL remotely unless your ISP provides cpanel? I find that a tad hard to believe…

    Thread Starter calvinfold

    (@calvinfold)

    No, no admin provided. It’s up to the user to provide their own interface.

    I had one recommended in another thread but was advised to install it (server-side), use it, then delete it immediately for security reasons. I was hoping to find something less tedious, like a “mySQL client” I could install on my local machine that could “log in” remotely to do admin functions.

    Heck, I’ll even entertain PC-based software for this, but would prefer Mac-based.

    Thread Starter calvinfold

    (@calvinfold)

    In that vein, anybody want to venture a quick way to wipe my SQL database of all tables (including some web-based or Mac-based SQL admin software) so I can try the WordPress installation again?

    Thread Starter calvinfold

    (@calvinfold)

    Oh goodness no. Speakeasy has been the most reliable connection and tech support I’ve had since Best Communications way back when (which Verio bought then promptly destroyed).

    They don’t claim SQL hand-holding, only provisioning of service. The problem is I don’t understand MySQL very well (or at all, FileMaker is my forté). So I have to learn a few things, no biggie. Just means “5 minute installation” is more like “5 minutes after you learn basic SQL administration.” πŸ˜‰

    Thread Starter calvinfold

    (@calvinfold)

    Well since no replies, starting over. They did enable the “drop” functionality for me, so it was definitely disabled.

    Of course, I just discovered that I can’t just delete the old files, I have to clear the database somehow. Yet another service ticket in with my ISP (gonna drive them and me nuts with this). They don’t provide a “cpanel” and their own link is some PC-based software (I need web or Mac-based).

    Hopefully they’ll just do it for me. Once the tables are wiped clean I’ll try a fresh install. *crosses fingers*

    Thread Starter calvinfold

    (@calvinfold)

    I meant to ask…the Blog *seems* to be working…is the error on these four tables bad, can it be tested to see if functionality was lost?

    Thread Starter calvinfold

    (@calvinfold)

    The name in front of the @ is my user name, correct. The name after the @ is *not* db.speakeasy.net (per the syntax it’s “something.something.speakeasy.net”)…seems to be trying to route through the web hosting services, which is not where the database is located, per the config file.

    Why would wordpress be trying to route a database command via the web host when it knows explicitly that is *not* where the database is located?

    I’d like to get back to SpeakEasy ASAP but I need to know why WordPress would be trying to do database commands via the webhost first.

    Thread Starter calvinfold

    (@calvinfold)

    Connection established, yay! But new problem, starting new thread for that.

    Thread Starter calvinfold

    (@calvinfold)

    Leave it to my luck…the engineering folks who created the SQL database can’t even get into it. Must have gotten set-up wrong or corrupted. LOL. They should be nuking it soon and trying again. πŸ˜‰

    Thread Starter calvinfold

    (@calvinfold)

    They guy handling my ticket with SpeakEasy found he couldn’t access it manually either so it’s going back to engineering for troubleshooting. So looks like *I* didn’t do anything wrong but the setup is a bit wonky.

    Oh, and SpeakyEasy doesn’t offer cpanel or the like. As I suspected, I can use whatever I want…they pointed me to MySQLAdministrator.

    Will keep y’all posted.

    Thread Starter calvinfold

    (@calvinfold)

    bob58,

    Well I tried phpMyAdmin from here, but got an access error. Going to try again when I get home since I know Speakeasy does not allow some of these security-sensitive operations from outside their network.

    I’ll keep an eye on this forum for further insights and report back any next steps from Speakeasy.

    Thread Starter calvinfold

    (@calvinfold)

    I’ve re-checked that file like 10+ times now. Even copy-n-pasted the server, login, and password information from the support e-mail, checked for extraneous characters, etc. The error page from WordPress even gives the right database information back (so it’s looking for what it should be).

    As someone who provides tech support (albiet on Macs, but we all share the same headaches with users…PEBCAK! RTFM!), I usually only resort to tech support myself when it’s truly a stumper. πŸ˜‰

    [And a second reason I chose WordPress…forums like this. My goodness y’all respond fast!]

    I’m just in new territory…PHP and MySQL are things I’ve been wanting to learn, so Trial by Fire time…

    Thread Starter calvinfold

    (@calvinfold)

    Stupid question, but again, MySQL newbie here:

    Where do I install it…on my hosted web space? What directory?

    (If I have to install it locally bear in mind I’m on an OS X Mac.)

    Thread Starter calvinfold

    (@calvinfold)

    Just tried that, nothing. Going to ammend the support ticket to see if they have an access tool of some sort.

    Basically I have their “SysAdmin” package. Unlike every other ISP I’ve had, Speakeasy allows a great freedom to do thing as if the servers were mine, or my DSL line as if it was mine. This works for me most times, I can do stuff PacBell, Verio, and others would never let me do (or charge me an arm and a leg for). But times like this it works against me since while I’m not afraid to tinker and get my hands dirty doing code and command line stuff, I’m on my own…it’s assumed I have a clue.

    Don’t get me wrong, Speakeasy has hand-held me on a number of occasions for standard stuff. The road block I’m hitting here is WordPress is not something they support directly. I can see their point: here’s your database, do what you want, and have fun…but we’re not going to troubleshoot your code and software choices unless it might be a problem with our servers.

    Which means if there is some “standard” way to access the MySQL database remotely, that’s probably how it works. *shrug*

Viewing 15 replies - 1 through 15 (of 16 total)