Blog Archives

Amazon RDS – MySQL – Creating new user Error #1045

On Amazon RDS MySQL creating a new database user with all priviledges results in an error of #1045 – Access denied for user ‘mastername’@’%’ (using password: YES) Using: GRANT ALL PRIVILEGES ON *.* TO ‘testuser’@’localhost’ REQUIRE NONE WITH GRANT OPTION

Posted in Database, servers Tagged with: , , , , , ,

MySQL Latin1 to UTF8 conversion

Many people think it’s as simple as doing a mysqldump->sed->mysql command (or clicking Change->Collation in PhpMyAdmin) but that only changes the encoding for NEW data, while leaving the old data intact and possibly coming out dirty. Luckily there is a

Posted in bash, Database, linux, servers Tagged with: , , , , , , , , , ,