calvinfold
Forum Replies Created
-
Forum: Installing WordPress
In reply to: WordPress Database Error (drop command)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.
Forum: Installing WordPress
In reply to: WordPress Database Error (drop command)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…
Forum: Installing WordPress
In reply to: WordPress Database Error (drop command)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.
Forum: Installing WordPress
In reply to: WordPress Database Error (drop command)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?
Forum: Installing WordPress
In reply to: WordPress Database Error (drop command)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.” π
Forum: Installing WordPress
In reply to: WordPress Database Error (drop command)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*
Forum: Installing WordPress
In reply to: WordPress Database Error (drop command)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?
Forum: Installing WordPress
In reply to: WordPress Database Error (drop command)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.
Forum: Installing WordPress
In reply to: Error Establishing Database Connection (Speakeasy.net)Connection established, yay! But new problem, starting new thread for that.
Forum: Installing WordPress
In reply to: Error Establishing Database Connection (Speakeasy.net)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. π
Forum: Installing WordPress
In reply to: Error Establishing Database Connection (Speakeasy.net)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.
Forum: Installing WordPress
In reply to: Error Establishing Database Connection (Speakeasy.net)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.
Forum: Installing WordPress
In reply to: Error Establishing Database Connection (Speakeasy.net)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…
Forum: Installing WordPress
In reply to: Error Establishing Database Connection (Speakeasy.net)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.)
Forum: Installing WordPress
In reply to: Error Establishing Database Connection (Speakeasy.net)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*