MySQL rookie guide to Getting Started

Source: Internet
Author: User
Tags mysql mysql database
MySQL MySQL is a fully networked Cross-platform relational database system, a real multi-user, multi-threaded SQL database server, and a client/server architecture of the distributed database management system. The utility model has the advantages of strong function, simple use, easy management, easy use, fast operation, high security and reliability, etc., and the user can write the program of accessing the MySQL database by using many languages. In addition to supporting standard ANSI SQL statements, it supports multiple platforms: the software supports multithreading on UNIX systems, operates as a system service on Windows NT systems, and runs as a normal process on Windows 95/98 systems. MySQL is an open source software, its official pronunciation is "my Ess Que Ell" (Not My-sequel my-sequel.

MySQL must be downloaded first. The official website of MySQL is: http://www.mysql.com, the Mirror in China is: http://www.freecode.net.cn/mirror/mysql/or http://www2.linuxforum.net/ mirror/mysql/, you 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".

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:mysqlbin 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:mysqlbin.

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, when prompted for a new password, there will normally be a few lines of prompt information and a hint sign:

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.


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.