5kits


 Powered by Max Banner Ads 

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

Leave a Reply