Red Antigua - MySQL setup

Search this site (by Google)

Home
About
Tools
Perl modules
Perl tutorials
C tutorials
Server configurations
UNIX on Windows
Misc. FreeBSD/UNIX
Redirect a web page
JavaScript
Virus list
Old stuff
Off topic

Tools (top)

Your IP
Check a site for broken links
(W3C)

Perl modules (top)

Tree::Numbered::Tools
(CPAN)

Perl tutorials (top)

Perl modules
HTML::Template
CGI::Application
Mail::POP3Client
Mail::Send
MIME::Tools
Cookies with CGI::Application
Upload files with CGI::Application
Download files with CGI::Application
Redirect with CGI::Application
CPAN shell
Install DBD::mysql from the CPAN shell
Perl trim function
Validate an IP with Perl
Run suid Perl scripts under Apache
Perl taint mode
Perl date functions with Date::Calc

In Spanish
Curso de Perl

C tutorials (top)

C - Introduction
C - Absolute beginner's Emacs
C - Examples for beginners
C - Makefile examples
C - Autotools examples

Server configurations (top)

DNS
Apache
Apache Authentication and Access Control
mod_perl on FreeBSD
MySQL
MySQL add account
phpMyAdmin
Squid
DHCP

UNIX on Windows (top)

Apache setup on Windows
MySQL setup on Windows
PHP setup on Windows
Perl setup on Windows
Emacs setup on Windows
UnxUtils
PuTTY
WinSCP
GIMP on Windows
MinGW - gcc on Windows
MSYS - make-in-a-shell on Windows
msysDTK - autotools on Windows
GDB for MinGW on Windows

Misc. FreeBSD/UNIX (top)

CD and DVD creation on FreeBSD using 'k3b' on FreeBSD
'ipf' on FreeBSD
'pf' on FreeBSD
'su' on FreeBSD
Mount an ISO image under FreeBSD
Load the correct sound driver under FreeBSD without knowing what sound card you are using
Simultaneous sound channels on FreeBSD
Boot floppies for FreeBSD
Problems with old disks/controllers and the 'ata' driver
FreeBSD network stuff
DOS-to-UNIX file conversion
favicon.ico on UNIX
Emacs tips
Sendmail tips
GKrellm
Command Line Calculator
Save multimedia streams with 'mplayer'
xargs - solution to 'Argument list too long'
Process multiple images from the command line using 'ImageMagick'
Turn the system bell off under X Windows
Process each line in an input file from the command line (or in a shell script)
How to keep a program running in the background using 'nohup'
How to remove symbolic links in the current directory using 'find' and 'rm'
How to remove Emacs backup files in the current directory and all subdirectories using 'find' and 'rm'
How to execute .profile without logging in

Redirect a web page (top)

Redirect to another web page
Apache redirect
C redirect
Perl redirect
PHP redirect
HTML redirect
JavaScript redirect

Javascript (top)

Trim function
Login form
Register form
Popup window

Virus list (top)

Latest viruses - Computer Virus HQ (external)
Latest 10 viruses - Sophos

Links (top)

HTML and PHP Scripts - Html Web Template

Old stuff (top)

POP3 server setup
About AnyMail
AnyMail downloads

Off topic (top)

Personal links

Validated by

MySQL - install

Added 2007-08-10:
How to setup phpMyAdmin (Apache 2.2.4, MySQL Server 5.0.45, PHP 5.2.3, phpMyAdmin 2.10.3):
http://caffetine.org/freebsd-amp.php

How to configure phpMyAdmin:
phpmyadmin.html

Added 2005-03-31:
If you are on FreeBSD, ignore this tutorial.
Install MySQL from the ports collection instead.
At the time of this writing the port is in /usr/ports/databases/mysql40-server. Just do the following:

cd /usr/ports/databases/mysql40-server
make install clean
/usr/local/etc/rc.d/mysql-server.sh start

Optionally, but highly recommended, is the phpMyAdmin web interface (it installs both Apache and PHP if missing, so it can take some time to build this port):

cd /usr/ports/databases/phpmyadmin
make install clean
/usr/local/etc/rc.d/apache.sh start

Point your browser to http://localhost/phpMyAdmin (don't be surprised if this link doesn't work at the time of reading!), enter with the root user and password, and you are ready to administrate your database in a very flexible manner.
Check out the tiny tutorial about adding a MySQL account from the command line.

Here goes the original tutorial (2002-08-18):

This is a MySQL install how-to.
Download the mysql tarball from www.mysql.com.
Install mysql:

    # gunzip -c mysql-X.XX.XX.tar.gz |tar -xf -
    # cd mysql-X.XX.XX
    # ./configure
    # make
    # make check (this is optional)		    
    # make install

Check the documentation (from the same directory):

    # opera ./Docs/manual_toc.html

Install the grant tables (from the same directory):

    # ./scripts/mysql_install_db

Check where the safe_mysqld binary was installed:

    # whereis safe_mysqld
    safe_mysqld: /usr/local/bin/safe_mysqld

Change to the mysql install directory and start the server:

    # cd /usr/local		    
    # ./bin/safe_mysqld &
    Starting mysqld daemon with databases from /usr/local/var

Enter the mysql client (quit to exit):

    # mysql
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 1 to server version: X.XX.XX

    Type 'help' for help.

    mysql>

To start mysql automatically at boot, create the script /usr/local/etc/rc.d/mysql.sh as root:




    #!/bin/sh

    #

    case $1 in

     start)

        cd /usr/local

        ./bin/safe_mysqld &
		    
        ;;

     stop)

        ;;

     *)

       echo "usage: $0 (start|stop)"

        ;;

    esac

Last modified: Fri Aug 10 20:30:17 CEST 2007