mySQL – The FreeBSD Diary

Phorum – installation, upgrade, and conversion from MySQL to PostgreSQL

6 Comments / mySQL, Phorum, PostgreSQL / Dan Langille

Phorum – installation, upgrade, and conversion from MySQL to PostgreSQL Phorum and PostgreSQL represent the most stable and robust tools in their respective classes. Phorum is a “web based message board written in PHP”. PostgreSQL is the most advanced open source database available. Both are tools which I have used for several years and which […]

Phorum – installation, upgrade, and conversion from MySQL to PostgreSQL Read More »

Introduction to C++ API for mySQL

4 Comments / databases, mySQL / Murat Balaban

Introduction to C++ API for mySQL Murat Balaban wrote this article. We will try to make a brief introduction to the `complex` C++ API for Mysql on FreeBSD. We are going to explain the installation procedure and introduce the API in light of three samples…Recent version of this document can be found on ; http://www.enderunix.org/documents/eng/mysql++.html

Introduction to C++ API for mySQL Read More »

Samba authentication through PAM with MySQL

4 Comments / databases, mySQL, samba / Randall S. Ehren

Samba authentication through PAM with MySQL Ed. note: Randall actually wrote this article back in November, but I’ve only just put it on the site today. Note: this assumes you have Samba, mySQL and pam_mysql already installed and running on FreeBSD 4.0 or greater The following describes how to setup Samba, PAM, and mySQL such

Samba authentication through PAM with MySQL Read More »

Keeping mysql passwords secure

Leave a Comment / databases, mySQL, Security / Dan Langille

Keeping mysql passwords secure Regular readers will remember my article about installing and configuring mysql. In that article you’ll see how I did a database backup. I’ve found a way to improve that script. ~/.my.cnf The script I use for backing up my database is available from: samples/database_dump2.sh.txt In that script, I include the password

Keeping mysql passwords secure Read More »

Accessing a mysql database from perl

1 Comment / databases, mySQL / Dan Langille

Accessing a mysql database from perl In previous articles I wrote about how to install and configure mysql (a very popular database). In this article, I write about how to access a mysql database from within a perl program. This will not be a full tutorial on the perl/mysql interface. Rather, it just shows you

Accessing a mysql database from perl Read More »

Installing and configuring mySQL

6 Comments / Apache, databases, mySQL / Dan Langille

Installing and configuring mySQL This article describes how I installed mySQL, a very popular relational database, especially as a back-end database for web servers. I won’t be teaching you how to use SQL. Sorry, but that is way beyond the scope of this website let alone this article. Resources I have found These are the

Installing and configuring mySQL Read More »