PHPMyAdmin – Run Slow When Loading List of Databases

If you have lots of databases, especially if some of your database names share certain prefixes it could take quite long time for the database list to load. Add this to config.inc.php

$cfg[‘LeftFrameDBTree’] = false;

Now PHPMyAdmin display the list faster 🙂

MySQL – Unable to connect to system bus

this error occured when invoking this command on my ubuntu server: service mysql start

solution: sudo service mysql start

conclusion: you need to be root to run this command

MySQL – Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed

• stop mysql
• delete “ib_logfile0″ and “ib_logfile1″
• start mysql

MySQL – InnoDB One File Per Table

on my.cnf:

[mysqld]
innodb_file_per_table