Tuesday, January 17, 2006

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/

1 comment:

Anonymous said...

...please where can I buy a unicorn?