Windows

 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me



Go Back   Tutorialized ForumsOperating SystemsWindows

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old December 8th, 2005, 08:36 PM
mark888 mark888 is offline
Contributing User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Aug 2005
Posts: 10 mark888 New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: < 1 sec
Reputation Power: 0
Installation of MySQL on Windows - Tutorial by Herong

For other tutorials on MySQL, see http://www.herongyang.com/sql/
------------

What is MySQL?

MySQL - An open source database management system developed by MySQL AB, http://www.mysql.com. MySQL was started with mSQL with fast low-level (ISAM) routines. So MySQL and mSQL are having almost the same application programming interfaces and command line interfaces.

Main features of MySQL (extracted from MySQL manual):

Works on many different platforms.

APIs for C, C++, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl are available.

Fully multi-threaded using kernel threads.

Provides transactional and non-transactional storage engines.

Uses very fast B-tree disk tables (MyISAM) with index compression.

Very fast joins using an optimized one-sweep multi-join.

SQL functions are implemented using a highly optimized class library and should be as fast as possible.

Support for aliases on tables and columns as required by SQL-92.

Handles large databases. We use MySQL Server with databases that contain 50 million records. We also know of users that use MySQL Server with 60,000 tables and about 5,000,000,000 rows.

Clients may connect to the MySQL server using TCP/IP sockets on any platform.

The Connector/ODBC interface provides MySQL support for client programs that use ODBC (Open-DataBase-Connectivity) connections.

The Connector/JDBC interface provides MySQL support for Java client programs that use JDBC connections.

Installing MySQL 4.0.18

1. Go to http://dev.mysql.com/downloads and select the latest production release.

2. Go to "Windows downloads" and select "Without installer (unzip in C:\)" entry.

3. Save the downloaded file, mysql-4.0.18-win-noinstall.zip, on your hard disk.

4. Unzip mysql-4.0.18-win-noinstall.zip to "\" and rename "\mysql-4.0.18" to "\mysql".

5. Open a command window and run "\mysql\bin\mysqld" to start MySQL server:
Code:
\mysql\bin\mysqld --console
nnnnnn 22:16:53  InnoDB: Started
\local\mysql\bin\mysqld: ready for connections.
Version: '4.0.18-max-debug'  socket: ''  port: 3306


6. Open another command window and run "\mysql\bin\mysqladmin" to administrate MySQL server:
Code:
\mysql\bin\mysqladmin ping
mysqld is alive

\mysql\bin\mysqladmin shutdown

If everything works correctly, you should see MySQL server printing notice and shutting down in the first command window.

Creating First Table in MySQL

In the previous section, we learned how to start and shutdown MySQL server. Now let's see how we can use MySQL client interface to create a table and run queries. First start the MySQL server in one command window, then run the start the MySQL client interface in another command window, and run the following MySQL client commands:
Code:
\mysql\bin\mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.18-max-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

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

mysql> use test;
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql> create table hello (message varchar(80));
Query OK, 0 rows affected (0.58 sec)

mysql> insert into hello (message) values ('Hello world!');
Query OK, 1 row affected (0.38 sec)

mysql> select * from hello;
+--------------+
| message      |
+--------------+
| Hello world! |
+--------------+
1 row in set (0.04 sec)

mysql> drop table hello;
Query OK, 0 rows affected (0.34 sec)

mysql> quit;
Bye


Conclusions:

MySQL is indeed easy to install and easy to use.

The MySQL server, mysqld, runs as a daemon and listens on IP port 3306 for client program connections.

MySQL offers an administrative client program, mysqladmin, to operate the MySQL server.

MySQL offers a simple client program, mysql, to run SQL statements against the MySQL server.

------------
For other tutorials on MySQL, see http://www.herongyang.com/sql/
__________________
Good tutorials for beginners on PHP, JSP, ASP, SQL, ...
--> http://www.herongyang.com/

Reply With Quote
Reply

Viewing: Tutorialized ForumsOperating SystemsWindows > Installation of MySQL on Windows - Tutorial by Herong


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.

© 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap