Mysql5 installation-free version Configuration

1, to the official download, decompress to a directory, you will find a directory of several my-XXXXX.ini files, according to your own needs, change a name to my. INI, and then in my. search for the following two rows in ini:

# The MySQL Server
[Mysqld]

Add these two lines below:

Basedir = D:/MySQL // set it to the installation directory of MySQL
Datadir = D:/MySQL/Data // set it to the MySQL DATA DIRECTORY

The above are the basic settings. To further optimize my. ini settings, you can continue to add some settings below, such:

Default-character-set = utf8
Default-storage-engine = InnoDB
Max_allowed_packet = 12 m

2. Save after configuration, run bin/mysqld-nt.exe in WindowsProgramIf a mysqld-nt.exe process exists in the Windows Task Manager, MySQL has been started successfully.

You can also enter D: "MySQL" bin,input “mysqld-nt.exe-install "at the command prompt. Now, a service called MySQL is registered in the system service, you can run the service at a command prompt or with "Net start MySQL" during running.
Note that the MySQL service is automatically started by default when you register it ~

Common MySQL commands:
C: "> Net start MySQL startup)
C: "> net stop MySQL (STOP)
C: "> mysqld-NT -- remove MySQL (uninstall the Service)

3. Set the MySQL Chinese character set (MySQL displays Chinese normally)

1) Configure the server, modify the my. ini file, store records using the Chinese Character Set, and sort and compare records in Chinese.
[Mysqld]
# Set Character Set
Default-character-set = GBK
# Set character collation
Default-collation = gbk_chinese_ci
Or
Default-character-set = utf8
Default-collation = utf8_general_ci

Change Password
Open the command line window and execute the following commands in sequence:
Enter mysql-uroot-P in the bin directory
Enter
The last carriage return indicates that the password is empty and the MySQL prompt is displayed. MySQL can be used normally now.
Using mysqladministrator.exe in the graphic interface

////////////////////////////////////
Delete service MySQL
SC Delete MySQL or WMIC service MySQL Delete
/////////////////////////////////////////
Installation-free mysql5 User Manual
# Author: yzcdf

Free installation version mysql5 now mainly has two versions, mysql-noinstall-5.1.6 (win32) and MySQL-5.1.5-alpha (WIN), can be downloaded on this site

Mysql-noinstall-5.1.6 (win32): http://download.mysql.cn/src/2006/0302/205.html
MySQL-5.1.5-alpha (WIN): http://download.mysql.cn/src/2006/0213/105.html
However, Alpha is not recommended.

I take mysql-noinstall-5.1.6 (win32) as an example, a simple description of the use of the method, hope to help everyone, insufficient expenditure, please correct.

Download the mysql-noinstall-5.0.13-rc-win32.zip file, right-click the file and select "decompress to current folder", 1

[Attach] 249 [/Attach] Figure 1
Then wait, after a while the system automatically decompress the mysql-5.0.13-rc-win32 folder, in order to facilitate memory, change the folder name to MySQL. For ease of use, I put the MySQL folder in the root directory of a partition and the root directory of the d disk.

Open the MySQL folder, which should contain the following files, 2

[Attach] 250 [/Attach] Figure 2
The bin folder contains some MySQL applications;
The data folder contains MySQL data files. Each MySQL database creates a folder with the same name as the database under the data folder. Initially, there are two databases by default, MySQL and test, 3

[Attach] 251 [/Attach] Figure 3
My D: "MySQL" data folder contains two folders: MySQL and test.
The following is an English document about mysql5.
Those. ini files are MySQL configuration files. Do not modify them at will ,?
MySQL runs normally.

[Attach] 252 [/Attach] Figure 4

open the command line window and execute the following commands in sequence:
D: press ENTER
Cd MySQL press ENTER
Cd bin press ENTER
mysql-uroot-P press ENTER
press enter, 5
[Attach] 253 [/Attach]
Figure 5
the last carriage return indicates that the password is blank and the MySQL prompt appears, now MySQL can be used normally.
show all existing databases: Show databases; Figure 6
[Attach] 284 [/Attach]
figure 6
select one of the databases, for example, use MySQL;
display all tables in the database: show tables;
indicates that I want to use the MySQL database. By the way, the command should end with a semicolon. 7
[Attach] 282 [/Attach]
figure 7
if you do not enter a semicolon, the command will never be executed. MySQL considers that the command has not been input and waits for a semicolon to end the current command, 8
[Attach] 283 [/Attach]
figure 8