MySQL setup

Search this site (by Google)

Tools (top)

Perl modules (top)

Perl tutorials (top)

Perl modules
HTML::Template
CGI::Application
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)

MSYS2 - UNIX environment for MS Windows 32/64 bits
Apache setup on Windows
MySQL setup on Windows
PHP setup on Windows
Perl setup on Windows
Emacs setup on Windows
PuTTY
WinSCP
GIMP on Windows
MinGW - gcc on Windows
MSYS - UNIX-styled shell on Windows
msysDTK - autotools on Windows
GDB for MinGW on Windows

Misc. FreeBSD/UNIX (top)

'portupgrade' 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
FreeBSD network stuff
DOS-to-UNIX file conversion
favicon.ico on UNIX
Emacs tips
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
Configure X to handle non-English characters
How to move /var to /usr/var

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

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