Skip to content

Techonia.com

News, Tutorials, and How tos about Technology

Archive

Tag: MySQL

In this article, I want to share you on how to install Apache and PHP with SSL and MySQL 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 server was installed during system installation. If you want to install MySQL server from source distribution, follow my previous tutorial here.
continue reading…

Incoming search terms for this post:

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.
To do this you need to dump the table first and then restore to the target database. continue reading…

Incoming search terms for this post:

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.

1. Using mysqladmin command.
Login to the server where the MySQL database is installed. From the current shell run mysqladmin command below:
continue reading…

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. continue reading…

Incoming search terms for this post: