My db-class.org notes

Useful links

MySQL Reference Manual

Install MySQL on Fedora

Installing required software on Fedora Core 15

xmllint

My Fedora Core 15 had xmllint installed. To confirm you have the software installed:

[ptay@robot logs]$ xmllint --version
xmllint: using libxml version 20707
   compiled with: Threads Tree Output Push Reader Patterns Writer SAXv1 FTP HTTP DTDValid HTML Legacy C14N Catalog XPath XPointer XInclude Iconv ISO8859X Unicode Regexps Automata Expr Schemas Schematron Modules Debug Zlib 
[ptay@robot logs]$

Kernow

Download Kernow

[ptay@robot Kernow]$ wget http://downloads.sourceforge.net/project/kernowforsaxon/Kernow/Kernow%201.7.2/Kernow%201.7.2.zip?r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fkernowforsaxon%2F&ts=1318016634&use_mirror=iweb

Unzip Kernow file

[ptay@robot Downloads]$ unzip "Kernow 1.7.2.zip" 
Archive:  Kernow 1.7.2.zip
   creating: Kernow 1.7.2/
   creating: Kernow 1.7.2/ant/
  inflating: Kernow 1.7.2/ant/kernow_sample_buildfile.xml  
   creating: Kernow 1.7.2/cache/
  inflating: Kernow 1.7.2/cache/catalog.xml  
  inflating: Kernow 1.7.2/cache/readme.txt  
  inflating: Kernow 1.7.2/cache/xhtml-lat1.ent  
  inflating: Kernow 1.7.2/cache/xhtml-special.ent  
  inflating: Kernow 1.7.2/cache/xhtml-symbol.ent  
  inflating: Kernow 1.7.2/cache/xhtml1-frameset.dtd  
  inflating: Kernow 1.7.2/cache/xhtml1-strict.dtd  
  inflating: Kernow 1.7.2/cache/xhtml1-transitional.dtd  
   creating: Kernow 1.7.2/extensions/
  inflating: Kernow 1.7.2/extensions/readme.txt  
  inflating: Kernow 1.7.2/Kernow.bat  
  inflating: Kernow 1.7.2/Kernow.exe  
  inflating: Kernow 1.7.2/kernow.jar  
  inflating: Kernow 1.7.2/Kernow.sh  
   creating: Kernow 1.7.2/lib/
  inflating: Kernow 1.7.2/lib/ant-launcher.jar  
  inflating: Kernow 1.7.2/lib/ant.jar  
  inflating: Kernow 1.7.2/lib/autocomplete.jar  
  inflating: Kernow 1.7.2/lib/AutoComplete.License.txt  
  inflating: Kernow 1.7.2/lib/cupv10k-runtime.jar  
  inflating: Kernow 1.7.2/lib/icu4j.jar  
  inflating: Kernow 1.7.2/lib/org.eclipse.wst.xml.xpath2.processor_1.1.0.jar  
  inflating: Kernow 1.7.2/lib/resolver.jar  
  inflating: Kernow 1.7.2/lib/rsyntaxtextarea.jar  
  inflating: Kernow 1.7.2/lib/saxon9he.jar  
  inflating: Kernow 1.7.2/lib/serializer.jar  
 extracting: Kernow 1.7.2/lib/splash.gif  
  inflating: Kernow 1.7.2/lib/swing-layout-1.0.4.jar  
  inflating: Kernow 1.7.2/lib/xercesImpl.jar  
  inflating: Kernow 1.7.2/lib/xercesSamples.jar  
  inflating: Kernow 1.7.2/lib/xml-apis.jar  
  inflating: Kernow 1.7.2/readme.txt

Optional, remove .zip file by using rm -f "Kernow 1.7.2.zip" command.

Launch Kernow

Navigate to directory where Kernow is located (or create symbolic link and use symbolic link). This command will launch a Kernow java window.

[ptay@robot Downloads]$ cd Kernow1.7.2/
[ptay@robot Kernow1.7.2]$ ls
ant    extensions  Kernow.exe  Kernow.sh  readme.txt
cache  Kernow.bat  kernow.jar  lib
[ptay@robot Kernow1.7.2]$ java -jar kernow.jar &
[1] 3370
[ptay@robot Kernow1.7.2]$

MySQL

Ubuntu commands:

$ sudo apt-get install mysql-server mysql-common mysql-client

Fedora Core 15 commands:

[ptay@robot logs]$ sudo yum groupinstall "MySQL Database"
[sudo] password for ptay: 
Loaded plugins: langpacks, presto, refresh-packagekit
Adding en_US to language list
Setting up Group Process
updates/group_gz                                         | 420 kB     00:00     
Resolving Dependencies
--> Running transaction check
---> Package MySQL-python.x86_64 0:1.2.3-1.fc14 set to be installed
---> Package libdbi-dbd-mysql.x86_64 0:0.8.3-6.fc14 set to be installed
--> Processing Dependency: libdbi-drivers = 0.8.3-6.fc14 for package: libdbi-dbd-mysql-0.8.3-6.fc14.x86_64
--> Processing Dependency: libdbi.so.0()(64bit) for package: libdbi-dbd-mysql-0.8.3-6.fc14.x86_64
---> Package mysql.x86_64 0:5.1.58-1.fc14 set to be installed
---> Package mysql-connector-odbc.x86_64 0:5.1.5r1144-7.fc13 set to be installed
---> Package mysql-server.x86_64 0:5.1.58-1.fc14 set to be installed
--> Processing Dependency: perl(DBI) for package: mysql-server-5.1.58-1.fc14.x86_64
--> Processing Dependency: perl-DBI for package: mysql-server-5.1.58-1.fc14.x86_64
---> Package perl-DBD-MySQL.x86_64 0:4.017-1.fc14 set to be installed
---> Package unixODBC.x86_64 0:2.2.14-12.fc14 set to be installed
--> Running transaction check
---> Package libdbi.x86_64 0:0.8.3-4.fc14 set to be installed
---> Package libdbi-drivers.x86_64 0:0.8.3-6.fc14 set to be installed
---> Package perl-DBI.x86_64 0:1.613-1.fc14 set to be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package                  Arch       Version                  Repository   Size
================================================================================
Installing:
 MySQL-python             x86_64     1.2.3-1.fc14             updates      79 k
 libdbi-dbd-mysql         x86_64     0.8.3-6.fc14             fedora       14 k
 mysql                    x86_64     5.1.58-1.fc14            updates     883 k
 mysql-connector-odbc     x86_64     5.1.5r1144-7.fc13        fedora      114 k
 mysql-server             x86_64     5.1.58-1.fc14            updates     8.1 M
 perl-DBD-MySQL           x86_64     4.017-1.fc14             fedora      136 k
 unixODBC                 x86_64     2.2.14-12.fc14           fedora      383 k
Installing for dependencies:
 libdbi                   x86_64     0.8.3-4.fc14             fedora       39 k
 libdbi-drivers           x86_64     0.8.3-6.fc14             fedora      372 k
 perl-DBI                 x86_64     1.613-1.fc14             fedora      776 k

Transaction Summary
================================================================================
Install      10 Package(s)

Total download size: 11 M
Installed size: 30 M
Is this ok [y/N]: y
Downloading Packages:
Setting up and reading Presto delta metadata
Processing delta metadata
Package(s) data still to download: 11 M
(1/10): MySQL-python-1.2.3-1.fc14.x86_64.rpm             |  79 kB     00:00     
(2/10): libdbi-0.8.3-4.fc14.x86_64.rpm                   |  39 kB     00:00     
(3/10): libdbi-dbd-mysql-0.8.3-6.fc14.x86_64.rpm         |  14 kB     00:00     
(4/10): libdbi-drivers-0.8.3-6.fc14.x86_64.rpm           | 372 kB     00:00     
(5/10): mysql-5.1.58-1.fc14.x86_64.rpm                   | 883 kB     00:00     
(6/10): mysql-connector-odbc-5.1.5r1144-7.fc13.x86_64.rp | 114 kB     00:00     
(7/10): mysql-server-5.1.58-1.fc14.x86_64.rpm            | 8.1 MB     00:02     
(8/10): perl-DBD-MySQL-4.017-1.fc14.x86_64.rpm           | 136 kB     00:00     
(9/10): perl-DBI-1.613-1.fc14.x86_64.rpm                 | 776 kB     00:00     
(10/10): unixODBC-2.2.14-12.fc14.x86_64.rpm              | 383 kB     00:00     
--------------------------------------------------------------------------------
Total                                           1.0 MB/s |  11 MB     00:10     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : libdbi-0.8.3-4.fc14.x86_64                              1/10 
  Installing     : mysql-5.1.58-1.fc14.x86_64                              2/10 
  Installing     : perl-DBI-1.613-1.fc14.x86_64                            3/10 
  Installing     : unixODBC-2.2.14-12.fc14.x86_64                          4/10 
  Installing     : mysql-connector-odbc-5.1.5r1144-7.fc13.x86_64           5/10 
  Installing     : MySQL-python-1.2.3-1.fc14.x86_64                        6/10 
  Installing     : perl-DBD-MySQL-4.017-1.fc14.x86_64                      7/10 
  Installing     : libdbi-drivers-0.8.3-6.fc14.x86_64                      8/10 
  Installing     : libdbi-dbd-mysql-0.8.3-6.fc14.x86_64                    9/10 
  Installing     : mysql-server-5.1.58-1.fc14.x86_64                      10/10 

Installed:
  MySQL-python.x86_64 0:1.2.3-1.fc14                                            
  libdbi-dbd-mysql.x86_64 0:0.8.3-6.fc14                                        
  mysql.x86_64 0:5.1.58-1.fc14                                                  
  mysql-connector-odbc.x86_64 0:5.1.5r1144-7.fc13                               
  mysql-server.x86_64 0:5.1.58-1.fc14                                           
  perl-DBD-MySQL.x86_64 0:4.017-1.fc14                                          
  unixODBC.x86_64 0:2.2.14-12.fc14                                              

Dependency Installed:
  libdbi.x86_64 0:0.8.3-4.fc14        libdbi-drivers.x86_64 0:0.8.3-6.fc14     
  perl-DBI.x86_64 0:1.613-1.fc14     

Complete!

Enable MySQL at specific run levels (I did 3 & 5)

[ptay@robot logs]$ sudo chkconfig --level 35 mysqld on
[ptay@robot logs]$ chkconfig --list | grep -i mysqld
mysqld          0:off   1:off   2:off   3:on    4:off   5:on    6:off

Start MySQL daemon (mysqld) As root

[root@robot ~]# service mysqld restart
Stopping mysqld:  [  OK  ]
Initializing MySQL database:  Installing MySQL system tables...
OK

//////////////omitting text/////////////////////

Starting mysqld:  [  OK  ]

Run MySQL secure installation script As root

[root@robot ~]# /usr/bin/mysql_secure_installation

//////////////omitting text/////////////////////

Set root password? [Y/n] y
Remove anonymous users? [Y/n] y
Disallow root login remotely? [Y/n] y
Remove test database and access to it? [Y/n] y
Reload privilege tables now? [Y/n] y
Cleaning up...

All done!  If you've completed all of the above steps, your MySQL
installation should now be secure.

Thanks for using MySQL!

Test MySQL As any user

[root@robot ~]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.1.58 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
+--------------------+
2 rows in set (0.00 sec)

mysql> create database test;
Query OK, 1 row affected (0.01 sec)
mysql> use test
Database changed
mysql> use test;
Database changed
mysql> drop table if exists T;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> create table T (A text, B text);
insert into T values ('Hello,', 'world!');
select * from T;Query OK, 0 rows affected (0.06 sec)

mysql> insert into T values ('Hello,', 'world!');
Query OK, 1 row affected (0.00 sec)

mysql> select * from T;
+--------+--------+
| A      | B      |
+--------+--------+
| Hello, | world! |
+--------+--------+
1 row in set (0.00 sec)

mysql> \q
Bye

To Education