MYSQL Server

Install mySQL server

1. Check the most stable mysql server (usually high number)

2. Install mysql**-server

eg: install mysql55-server

#cd /usr/ports/database/mysql55-server

#make install

3. Start mysql-server

#/usr/local/etc/rc.d/mysql-server start

#echo "mysql_enable"="YES">>/etc/rc.conf

kalau >> means akan tambah lines kat rc.conf tuh

kalau > means akan replace line itu jerk -> so be careful

4. Check mysql status

#ps ax

atau

#sockstat -4 -> check port mysql 3306

5. Login mysql

#mysql -uroot -p

6. Admin password

mysqladmin -uroot password "*********"

7. Create dB

create database coursework;