install Mysql and Phpmyadmin using yum
yum -y install mysql mysql-server php-mysql
Start mysql service
/etc/rc.d/init.d/mysqld start
You’ll see mysql is being started, keep on watching for following line:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password ‘new-password’
/usr/bin/mysqladmin -u root -h vps-hostname password ‘new-password’
MySQL instruct you to create for mysql root’s password, so do it.
/usr/bin/mysqladmin -u root password ‘new-password’
/usr/bin/mysqladmin -u root -h vps-hostname password ‘new-password’
change new-password to vps password
change vps-hostname to vps hostname you have set up from PMC 124.217.255.10
Test newly set password by log in to mysql
mysql -u root -p
Enter password:
You should be able to log into mysql with the password if set correctly.
Create .my.cnf inside /root folder
vim /root/.my.cnf
add following lines
[client]
user=”root”
pass=”new-password”
Save & exit & change mode that file
chmod 600 /root/.my.cnf
Download phpmyadmin from phpmyadmin’s site, untar it under /var/www/html
cd /var/www/html
wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.4.1/phpMyAdmin-3.4.1-all-languages.tar.gz?r=http%3A%2F%2Fwww.phpmyadmin.net%2Fhome_page%2Findex.php&ts=1306296119&use_mirror=cdnetworks-kr-1
tar xvzf phpMyAdmin-3.4.1-all-languages.tar.gz
ln -s phpMyAdmin-3.4.1-all-languages phpmyadmin
chown -R apache.apache phpMyAdmin-3.4.1-all-languages
chown -R apache.apache phpmyadmin
cd phpmyadmin
cp -p config.sample.inc.php config.inc.php
vim config.inc.php
look for line
$cfg[‘blowfish_secret’] = ”; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
add random text to become like this
$cfg[‘blowfish_secret’] = ‘$5^tY7F3w’; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
random text can be anything
Check phpmyadmin from browser
http://vps-ip-address/phpmyadmin
Done