MySQL Error 1045 – Access Denied

I’ve had quite a headache couple of days ago with the Access Denied 1045 error with remote access to MySQL, so I’ve created a step-by-step guide to debugging this:

Error 1045 Access Denied Troubleshooting Guide

Create User in MySQL if It Does Not Exist

MySQL does not support create user if not exists syntax as it does with create table and create procedure. This is pretty weird, as it just boils down to checking whether single row exists in the `mysql`.`user` table.

How to enable mySQL in PHP5 on Windows

Apache+mySQL+PHP is for sure among the best and the most popular combinations of web-development products; but sometimes a proper setup is a tricky bit.