Apache HTTP

MySQL

PHP

Java JDK

Java Servlets

Apache JServ

ht://Dig

MySQL

URL
http://www.mysql.org

Sample Compile and Installation

# tar xzvf mysql-3.22.23b.tar.gz 
# cd mysql-3.22.23b
# more README 
# more INSTALL-SOURCE
# ./configure --help
# ./configure --prefix=/opt/mysql --with-mysqld-user=mysql
# make
# make -n install
# make install
# scripts/mysql_install_db 
# /opt/mysql/bin/safe_mysqld &
# /opt/mysql/bin/mysqladmin -u root password 'rootPassword'
# /opt/mysql/bin/mysqladmin -p shutdown
# chown -R mysql:mysql /opt/mysql/var/
# sh /opt/mysql/share/mysql/mysql.server start
# /opt/mysql/bin/mysqlshow -p
# /opt/mysql/bin/mysqlshow -p mysql
# /opt/mysql/bin/mysql -p -e "select host,db,user from db" mysql


I had to install the following packages before running the tests:
(Available from: http://www.mysql.org/Contrib/)

DBI-1.08
# tar xvzf DBI-1.08.tar.gz 
# cd DBI-1.08
# more README 
# perl Makefile.PL
# make
# make test
# make install



Msql-Mysql-modules-1.2018
# tar xzvf Msql-Mysql-modules-1.2018.tar.gz 
# cd Msql-Mysql-modules-1.2018
# more README 
# perl Makefile.PL 

From the output of perl Makefile.PL...
Checking for DBI, 0.93 or later ... ok
Checking for Data::Dumper ... ok
Checking for Data::ShowTable ... 
Which DBMS do you want to use?

  1) MySQL
  2) mSQL (1 or 2)
  3) Both MySQL and mSQL

  4) mSQL1 and mSQL2
  5) Everything (MySQL, mSQL1 and mSQL2)

Enter your choice:  [3] 1


Do you want to install the MysqlPerl emulation? You might keep your old
Mysql module (to be distinguished from DBD::mysql!) if you are concerned
about compatibility to existing applications! [n] 
Which database should I use for testing the Mysql drivers? [test] 
On which host is database test running (hostname,  ip address or host:port)
 [localhost] 
User name for connecting to database test? [undef] test
Password for connecting to database test? [undef] 
Where is your mysql installed? Please tell me the directory that contains
the subdir include/. [/opt/mysql] 
Creating Mysql files .....................
Checking if your kit is complete...
Looks good
Writing Makefile for DBD::mysql
Writing Makefile for Msql-Mysql-modules


# make
# make test
# make install



# cd /opt/src/mysql-3.22.23b/bench/
# ./run-all-tests --password='rootPassword'
    

Sample MySQL Session

# mysqladmin -p create matthew
# mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 23 to server version: 3.22.23b

Type 'help' for help.

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> delete from user where user=''\g
Query OK, 2 rows affected (0.01 sec)

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON matthew.* TO matthew@localhost IDENTIFIED BY 'matthewPassword';
Query OK, 0 rows affected (0.03 sec)

mysql> use matthew;
Database changed
mysql> CREATE TABLE birthdays ( firstname char(32), lastname char(32), birthday date );
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO birthdays VALUES ( 'Matthew', 'Feldt', '1968-06-23' );
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO birthdays VALUES ( 'Bob', 'Barker', '0001-06-30' );
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO birthdays VALUES ( 'Pat', 'Sajak', '0001-10-15' );
Query OK, 1 row affected (0.00 sec)

mysql> \q
Bye