MySQL Database learning experience (1)

MySQL is a fully networked Cross-platform relational database system, a real multi-user, multithreaded SQL database server, and a distributed database management system with client/server architecture. It has a strong function, so that

Easy to use, easy to manage, fast operation, security and reliability of the advantages, users can use many languages to write access to the MySQL database program, for medium and small application system is very ideal. In addition to supporting standard ANSI SQL statements, and more importantly, it supports a variety of platforms, while on UNIX systems the software supports multithreading and can achieve fairly good performance. For users who do not use UNIX, it can be run as a system service on a Windows NT system, or run as a normal process on a Windows 95/98 system. On the unix/linux system, MySQL supports multi-threaded operation, which can achieve fairly good performance, and it belongs to the open source code soft.

MySQL is a client/server architecture implementation, it consists of a server daemon mysqld and a number of different client programs and libraries, MySQL performance is very high, running very fast, and very easy to use, is a very good database. The official pronunciation of MySQL is "my Ess Que Ell" (not My-sequel).

A. Get MySQL

MySQL must be downloaded first. The official website of MySQL is: www.mysql.com, the Mirror in China is: www.freecode.net.cn or: http://www2.linuxforum.net/, can download the stable version of MySQL 3.22.32 ( As of the author so far. Its version name is Mysql-shareware-3.22.32-win, not only for free, but not for the so-called "30-day use period".

Two. Installation of MySQL

(i) installation under Win98/winnt

To a directory, running the Setup program prompts the entire installation process. It is installed by default to the C:mysql, if you want to install to other directories there are changes to some things, as beginners, you can ignore, with the default directory installation. OK, after installation, enter the C:mysqlin directory, run the Mysqld-shareware.exe file under the Win98 directly run, under normal circumstances, no hint of information.

1. Unzip the downloaded file to a temporary directory.

2. Click setup.exe to install to C:mysql (default).

3. Copy the MYSQL_EXAMPLE.CNF to C:MY.CNF and change the #basedir=d:/mysql/in the file to Basedir=c:mysql.

4. Enter the MSDOS, to the directory C:mysqlin.

5. Enter Mysqld-shareware-install, which starts the MySQL database service.

6. Mysqladmin-u root-p Password The new password, which modifies the root user's password (the original default password is blank.) )

7. Enter Mysql-u root-p.

8. Then, according to the prompts to enter a new password, the normal situation will appear a few lines of information and prompt signs:

Welcome to the MySQL Monitor. Commands End With; or G.

Your MySQL Connection ID is 6268 to server version:3.22.32

Type ' help ' for help.

Mysql>

By this, you have successfully installed MySQL.