aluminum
Forum Replies Created
-
Forum: Installing WordPress
In reply to: Debugging MySQL connection on my own server?Well, how important is the index when running WordPress? Is it a nicety that you’d notice a bit of speed increase on a hugely succesful blog or is it of vital importance that even the most obscure blog will need/want to have for it to run decently?
Forum: Installing WordPress
In reply to: Debugging MySQL connection on my own server?A clarification…it still creates all the tables, I just get the access denied for each table when ALTERing them by the ADD INDEX command.
AND, it appears that everything works. Ie, I can now log in as admin, and create a new post, and it shows up.
So…are those red herring errors, or is something going to break down the road?
Forum: Installing WordPress
In reply to: Debugging MySQL connection on my own server?More progress!
OK, so I went in and remade a completely new user and a completely new DB via Webmin. NOW I can connect and get the installation script to load.
So far so good.
However, when I get to step-2, I still get access errors:
WordPress database error: [Access denied for user: ‘username@localhost’ to database ‘databasename’]
ALTER TABLEwp_postsADD INDEX (post_name)The user I am using right now has ALL permissions. I’ve set the db to grant this users ALL permissions as well.
Stumped again. 😉
Forum: Installing WordPress
In reply to: Debugging MySQL connection on my own server?Oh…WAIT!
Progress…
I *can* log in if I use the username/pwd that mambo uses. That appears to be the ONLY user that can get into the mysql command line.
However, even that user can’t log into mysqladmin
I have a hunch that I need to run ‘mysqladmin reload’ to reset those permissions, but, alas, I have no way to get into mysqladmin. Anyone know of a way to get around this?
Forum: Installing WordPress
In reply to: Debugging MySQL connection on my own server?Hmm…I can’t get into mysql that way, either. I’m getting 1045 errors no matter which user I try to log in as (even the DB user that Mambo is using…)
Something is not right on this box.
Forum: Installing WordPress
In reply to: Debugging MySQL connection on my own server?;o) That’d work, I suppose.
Well, here’s some more info. I tried running the ‘mysqladmin reload’ command via the command line. I also get an error of there of ‘not allowe to connect via localhost’. So it seems like a permissions issue with something somewhere.
Where does one grant a user permission to connect to the DB via localhost? I use webmin and it looks like I have the DB user set up for that.