MySQL Archives – Techonia

Sample config of FreeRadius as a Mobile authentication

By Fuad NAHDI April 25, 2015

This article shows you a sample configuration of FreeRadius as a mobile authentication to assign static IP address to the clients. In previous post, we have installed and configured FreeRadius on various operating systems such as Linux (CentOS, Ubuntu), FreeBSD, and OpenBSD. The Radius is ready to process requests.

This sample setup is based-on my project on a company which is serving hundred of customers around the country (Indonesia) using Telkomsel as the mobile operator. The customers are using a USB modem with a SIM card to connect to intranet.

Apache / PHP

Install Apache, PHP with SSL and MySQL support on PC-BSD 8.0 / FreeBSD 8.0

By Fuad NAHDI March 6, 2010

I want to share you on how to install Apache and PHP with SSL support on PC-BSD 8.0. I use the current stable version of Apache (version 2.2.14) and PHP (version 5.3.2) using PC-BSD 8.0 as the operating system. This article should be applicable to install them on Linux (Slackware, Centos, Ubuntu, Fedora, Redhat, etc) or other BSD varian (NetBSD, OpenBSD). The MySQL database was installed during system installation.

MySQL

How to backup a table in MySQL database and copy to another database

By Fuad NAHDI December 10, 2009

Sometime you want to backup a table and all its contents in MySQL Database and then you might want to restore or copy the table to different MySQL database

MySQL

How to change MySQL root password

By Fuad NAHDI December 10, 2009

In some cases you might want to change or reset MySQL root password. To do this there are two ways, using mysqladmin command or using UPDATE sql command

MySQL

Quick Install MySQL from source distribution

By Fuad NAHDI August 3, 2009

This tutorial will show you on how to install MySQL server from source distribution. I use Slackware for this tutorial but it should be application in other Linux distros (Centos, Ubuntu, Redhat, Fedora, Debian, etc) and BSDs varian (FreeBSD, PC-BSD, NetBSD, and OpenBSD).

Basically the explanation on how to install MySQL is already explained the INSTALL-* files included in the source file. This tutorial is only a quick step and straightforward way because if you are a newbie you will take some times to read the INSTALL-* files.