MySQL is a fully networked cross-platform relational database system, a real multi-user, multi-threaded SQL database server, is also a distributed database management system with client / server architecture. It has the advantages of strong function, simple, easy to manage, fast running, and strong security and reliability, users can use many languages to access the Mysql database, for medium, small application systems is ideal. In addition to supporting standard ANSI SQL statements, it is more important to support a variety of platforms, while the software supports multi-threaded mode on the UNIX system to achieve considerable performance. For users who don't use UNIX, it can run in a system service in the Windows NT system, or run in a normal process on the Windows 95/98 system. On the UNIX / Linux system, MySQL supports multi-threaded operation, so that it can get a considerable performance, and it belongs to the open source code soft.
MySQL is an implementation of a client / server structure, which consists of a server daemnqld and a lot of different client programs and libraries. MySQL performs very high performance, very fast running, and is very good. Database. The official pronunciation of MySQL is "My Ess Que Ell" (not my-sequel).
1. Get mysql
First, you must download MySQL. MySQL's official website is: www.mysql.com, in China's mirroring is: www.freecode.net.cn or: http://www2.linuxforum.net/, you can download mysql's stable version 3.22.32 (as of it The author is published). Its version name is mysql-shareware-3.22.32-win, not only free and there is no so-called "30-day vitality period".
Two. MYSQL installation
(1) Installation under WinXP
To a directory, run the setup program, will prompt the entire installation process. It is installed by default to C: / MySQL. If you want to install some things, as an initiator, you can install it in the default directory. Ok, after installation, enter the c: mysql / bin directory, run the mysqld-shareware.exe file directly under WinXP, normal case, there is no prompt information.
1. Unzip the downloaded file to a temporary directory.
2. Click Setup.exe to install to C: / MySQL (default).
3. Copy mysql_example.cnf to c: my.cnf, turn # basedir = d: / mysql / change to Basedir = C: MySQL.
4. Enter MSDOS to the directory C: mysql / bin.
5. Enter mysqld-shareware -install, this is to start the MySQL database service.
6. MySQLADMIN-U root -p password new password, this is the password to modify the root user (the default password is empty.)
7. Enter mysql -u root -p.
8. Next, enter a new password according to the prompt, and then a few prompt information will appear and the prompt symbol appears:
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>
At this point, you have successfully installed MySQL.
