Select a Category

Common MySQL Operations

Here are some common MySQL Operations

Log into MySQL with following command: mysql -u root -p

Create a new database name sample: create database sample;

Create a sample user in local host with password ‘secret’: create user sample@localhost identified by ‘secret’;

Grant all Privileges to sample user on database sample: grant All Privileges on sample.* […]

phpMyAdmin needs a secret passphrase (blowfish_secret)


phpMyAdmin indicates “configuration files now needs a secret passphase (blowfish_secret)”.

Solution copy the sample php configuration file in the phpMyAdmin directory to modify and add your secret password in the line: $cfg[‘blowfish_secret’]=’my_secret’ The alarm goes away after you refresh your web page.


How to Install mycrypt for phpMyAdmin in Ubuntu 9.10


phpMyAdmin is a popular open source package for web database administration. However, I notice that my phpMyAdmin showed a message on its home page “Cannot load mcrypt extension. Please check your PHP configuration”.

Steps to Solve this Problem

Need to install php5-mcrypt package with:

sudo apt-get install php5-mcrypt

then update the software package with: