This is an old link ... let me redirect you ...

(... or click here if the page does not automatically redirect)

Lost Weekend: Troubleshooting a MySQL Installation

Spurred on by Blogger's decision to stop supporting FTP for publishing blogs, I have finally started the long process to implement a WordPress blog - hosted by myself, not Wordpress.com . To be fair, I am making this longer than it necessarily needs to be, but I am continuing my efforts to maintain a comprehensive Admin guide for all of my development efforts - configuring servers, installing software, etc.

Needless to say, this adds overhead and time, but it's worth the effort. I have invested around 40 hours of effort over the past four years on the document (an indicator of how often I get back to my development projects). Still, it pays off every time, because I have a reasonably well-developed SDLC and publishing process implemented, and I need to make sure each new project follows established standards - and adds to the standards when necessary.

Enter MySQL and WordPress - since I will be hosting my own blog, I need a new and different flavor of Development, Test, and Production environments. No more dabbling - I need to tighten up security and document the installation and maintenance processes for the database.

Which is where I hit a wall, of sorts; I could not successfully change the root password on the MySQL database, kept on getting the UPDATE command denied to user ''@'localhost' for table 'user' message.

Hours of surfing, searching, starting and stopping, installing and reinstalling, to no avail. However, I had seen the AppArmor framework mentioned a few times, and had seen error and warning messages in the system logs that kept hinting at something in that direction. So I finally followed the advice noted in this thread , and disabled AppArmor during the MySQL installation process. A few notes:
A quick validation that I could use the MySQL graphical admin tools and phpMyAdmin , and I was back to getting the Dev instance of WordPress going.

Ah, but now I have to get ready for the work week, and time is ticking away ...