Install mysql
root@xinot-edu:~# groupadd mysql
root@xinot-edu:~# useradd -g mysql mysql
root@xinot-edu:~#cd /usr/
root@xinot-edu:~# tar -zxvf /path/to/mysql-VERSION-OS.tar.gz
root@xinot-edu:~#ln -s full-path-to-mysql-VERSION-OS mysql
root@xinot-edu:~#cd mysql
root@xinot-edu:~#scripts/mysql_install_db –user=mysql
root@xinot-edu:~#chown -R root .
root@xinot-edu:~#chown -R mysql data
root@xinot-edu:~#chgrp -R mysql .
root@xinot-edu:~#bin/mysqld_safe –user=mysql &
root@xinot-edu:/usr/mysql# cp /usr/mysql/support-files/mysql.server /etc/rc.d/rc.mysqld
root@xinot-edu:/usr/mysql# chmod +x /etc/rc.d/rc.mysqld
root@xinot-edu:/usr/mysql# pico -w /etc/rc.d/rc.mysqld
*Edit kalimat berikut
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
if test “$datadir” != “/usr/local/mysql/data”
*Sesuaikan seperti installan anda
datadir=/usr/mysql/data
basedir=/usr/mysql
if test “$datadir” != “/usr/mysql/data”
root@xinot-edu:/usr/mysql# pico -w /etc/my.cnf
*masukan kalimat berikut
[mysqld]
basedir=/usr/mysql
root@xinot-edu:/usr/mysql# /etc/rc.d/rc.mysqld start
root@xinot-edu:/usr/mysql# ln -s /usr/mysql/bin/mysql /usr/bin/mysql
root@xinot-edu:/usr/mysql# ln -s /usr/mysql/bin/mysqladmin /usr/bin/mysqladmin
Agar lebih aman berikan passwd pada mysql, caranya
root@xinot-edu:/usr/mysql# mysqladmin -u root password password-anda
untuk login gunakan command
root@xinot-edu:/usr/mysql# mysql -u root -p
Enter password:
Install PHPMyadmin
root@xinot-edu:/var/www/htdocs# tar -jxvf /home/tonix/phpMyAdmin-2.7.0-pl2.tar.bz2
root@xinot-edu:/var/www/htdocs# mv phpMyAdmin-2.7.0-pl2/ idman
root@xinot-edu:/var/www/htdocs# cd idman/
root@xinot-edu:/usr# cp config.default.php config.inc.php
root@xinot-edu:/var/www/htdocs# pico -w config.inc.php
*Edit kalimat berikut
$cfg['Servers'][$i]['auth_type'] = ‘config’; // Authentication method (config, http or cookie based)?
*menjadi
$cfg['Servers'][$i]['auth_type'] = ‘http’; // Authentication method (config, http or cookie based)?
Buka pake web browser
http://[alamat-web-Anda]/idman/
