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:
Tag Archives: mySQL
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.