Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

Wednesday, December 7, 2011

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;