Adminer – manage MySQL by single file, alternative of phpMyAdmin

Adminer impressed me when I first tested it. It is superb alternative to the most famous MySQL web based administration tool phpMyAdmin. I just counted number of files in my current phpMyAdmin installation and I found there are 642 items. But Adminer is only a single file. You need to download it from there website [...]

How to change MySQL database collation?

Usually you will be interested in changing your MySQL collation in order to solve problems with foreign character encodings. The most common case is to change your MySQL collation from latin1 to utf8. This can be done by using phpMyAdmin and following the instructions below: Enter your cPanel and click on the phpMyAdmin icon in [...]