|
|
| (5 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| == Useful links == | | == Class setup == |
|
| |
|
| [http://dev.mysql.com/doc/refman/5.6/en/index.html MySQL Reference Manual] | | [[Software setup for db-class]] |
|
| |
|
| [http://www.if-not-true-then-false.com/2010/install-mysql-on-fedora-centos-red-hat-rhel/ Install MySQL on Fedora]
| | == XML == |
|
| |
|
| == Installing required software on Fedora Core 15 == | | === Useful resources === |
|
| |
|
| === xmllint ===
| | W3Schools online introductions |
|
| |
|
| My Fedora Core 15 had xmllint installed. To confirm you have the software installed:
| | [http://www.w3schools.com/xml/xml_whatis.asp Introduction to XML] |
| <pre>[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]$</pre>
| |
|
| |
|
| === Kernow ===
| | [http://www.w3schools.com/dtd/dtd_intro.asp Introduction to DTD] |
|
| |
|
| '''Download Kernow'''
| | [http://www.w3schools.com/Schema/schema_intro.asp Introduction to XML Schema] |
| <pre>[ptay@robot Kernow]$ wget http://sourceforge.net/projects/kernowforsaxon/files/Kernow/Kernow%201.7.2/Kernow%201.7.2.zip/download?use_mirror=iweb</pre>
| |
|
| |
|
| '''Unzip Kernow file'''
| | [http://www.zvon.org Zvon.org] online course |
| <pre>[ptay@robot Downloads]$ unzip "Kernow 1.7.2.zip"
| |
| Archive: Kernow 1.7.2.zip
| |
| creating: Kernow 1.7.2
| |
|
| |
|
| //////////////omitting text/////////////////////
| | [http://www.zvon.org/comp/r/tut-XML.html XML Tutorial] |
|
| |
|
| inflating: Kernow 1.7.2/readme.txt</pre>
| | [http://www.zvon.org/comp/r/tut-DTD.html DTD Tutorial] |
|
| |
|
| Optional, remove .zip file by using <code>rm -f "Kernow 1.7.2.zip"</code> command.
| | W3C XML & XML Schema specifications |
|
| |
|
| Launch Kernow
| | [http://www.w3.org/TR/xml/ XML] |
|
| |
|
| Navigate to directory where Kernow is located (or create symbolic link and use symbolic link). This command will launch a Kernow java window.
| | [http://www.w3.org/TR/xmlschema-0/ XML Schemas] |
| <pre>[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]$</pre>
| |
|
| |
|
| === MySQL === | | == Relational Algebra == |
|
| |
|
| Ubuntu commands:
| | [http://en.wikipedia.org/wiki/Relational_algebra Relational algebra] on Wikipedia |
| <pre>$ sudo apt-get install mysql-server mysql-common mysql-client</pre>
| |
|
| |
|
| Fedora Core 15 commands:
| | A commercially failed relational algebra database called [http://en.wikipedia.org/wiki/Business_System_12 Business System 12] on Wikipedia |
| <pre>[ptay@robot logs]$ sudo yum groupinstall "MySQL Database"
| |
| [sudo] password for ptay:
| |
|
| |
|
| //////////////omitting text///////////////////// | | [http://en.wikipedia.org/wiki/Rel_%28DBMS%29 Rel] an open source relational database management system primarily used in teaching. |
|
| |
|
| Installed:
| | [http://db.grussell.org/section010.html Relational Algebra] portion of a [http://db.grussell.org/index.html database eLearning site]. |
| 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:
| | == Other Useful links == |
| 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!</pre>
| | [http://dev.mysql.com/doc/refman/5.6/en/index.html MySQL Reference Manual] |
|
| |
|
| '''Enable MySQL at specific run levels (I did 3 & 5)'''
| | [http://www.if-not-true-then-false.com/2010/install-mysql-on-fedora-centos-red-hat-rhel/ Install MySQL on Fedora] |
| <pre>[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</pre>
| |
| | |
| '''Start MySQL daemon (mysqld)'''
| |
| As root
| |
| <pre>
| |
| [root@robot ~]# service mysqld restart | |
| Stopping mysqld: [ OK ]
| |
| Initializing MySQL database: Installing MySQL system tables...
| |
| OK
| |
| | |
| //////////////omitting text/////////////////////
| |
| | |
| Starting mysqld: [ OK ]</pre>
| |
| | |
| '''Run MySQL secure installation script'''
| |
| As root
| |
| <pre>[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!</pre>
| |
| | |
| '''Test MySQL'''
| |
| As any user
| |
| <pre>[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</pre>
| |
|
| |
|
| <center>[[Education|To Education]]</center> | | <center>[[Education|To Education]]</center> |