Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to install MySQL database, the article is very detailed, has a certain reference value, interested friends must read!

1, Download mysql-3.23.35-win.zip and extract;

2. Run setup.exe; select d:mysql,"tyical install"

3. Start mysql, there are the following methods:

Method 1: Use winmysqladmin

1)Enter d::mysqlin directory, run winmysqladmin.exe, there will be a red icon in the task bar in the lower right corner of the screen

2)Click the icon with the left mouse button, select "show me", and the "WinMySQLAdmin" operation interface will appear; when it runs for the first time, a dialog box will appear in the middle, asking you to input and set your user name and password.

3)Select My.INI setup.

4)Select "mysqld-opt"(win 9x) or "mysqld-nt"(winNT) in "mysqld file"

5)Select "Pick-up or Edit my.ini values" to edit your my.ini file in the right window.

6)Select "Save Modification" to save your my.ini file

7)If you want to quickly use winmysqladmin(which automatically runs on startup), select "Create ShortCut on Start Menu"

8)Testing:

Enter DOS interface;

Run mysql under d: mysql directory to enter mysql interactive operation interface

Enter show databases and enter. The screen displays the two existing databases mysql and test.

Method 2: Do not use winmysqladmin

1)In DOS, go to d:/mysql/bin directory

2), win9X) Run:

mysqld

Running under NT:

mysqld-nt --standalone

3)After that, MySQL runs in the background.

4)test mysql: (under d:/mysql/bin directory)

a)、

mysqlshow

Normally, two existing databases are displayed: mysql and test.

b)、

mysqlshow -u root mysql

Normally, five tables in database mysql are displayed:

columns_priv

db

host

tables_priv

user

c)、

mysqladmin version status proc

Display version number, status, progress information, etc.

d)、

mysql test

Enter mysql operation interface, the current database is test

5)mysql closing method:

mysqladmin -u root shutdown

At this point, MySQL has been successfully installed, and then you can familiarize yourself with MySQL's common commands and create your own database.

The above is "MySQL database how to install" all the content of this article, thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.