Mysql Client

We can either use "mysql" command or PhpMyAdmin to connect with mysql database. For installing PhpMyAdmin follow the steps below

# mysql -uroot -p

Or

Download phpMyAdmin-2.11.10-english.tar.gz package

# tar -xvf phpMyAdmin-2.11.10-english.tar.gz 

# mv phpMyAdmin-2.11.10-english /var/www/html/db

# cd /var/www/html/db/

db]# cp config.sample.inc.php config.inc.php

db]# vim config.inc.php

$cfg['blowfish_secret'] ='  ';      /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */  edit the following line

$cfg['blowfish_secret'] = 'php';  

if you can give any name instead of php and save the file and open the url in browser and give mysql username and passwor.

 

browser : localhost/db

or ip instead of localhost.