Mysql-no-install Manual Installation

D:\mysql-5.5.28-win32

1, download Mysql-5.5.15-win32.zip, extract to local D:\mysql.

2, save My-small.ini as My.ini. (depending on the situation, you can choose another file: My-huge.ini,my-large.ini,my-medium.ini,my-small.ini)

3, modify the My.ini configuration file.

The following is appended to [client].
Default-character-set = UTF8

The following is appended to [mysqld].
Character_set_server = UTF8
Basedir=d:/mysql
Datadir=d:/mysql/data

MySQL's Create DATABASE ... DEFAULT CHARACTER SET ... Syntax vs. standard SQL Create SCHEMA ... CHARACTER SET ... Similar syntax. Therefore, you can create a database that uses different character sets and proofing rules on the same MySQL server.
If the table character set and proofing rules are not specified in the CREATE TABLE statement, the database character set and proofing rules are used as default values. They have no other purpose.

The character set and proofing rules for the default database can be used as character_set_database and collation_database system variables. The server sets the values for both variables whenever the default database changes. If there is no default database, these two variables have the same value as the corresponding server-level variables (Character_set_server and Collation_server).

4. Install MySQL-related commands

4.1 Registration Service
Mysqld--install MySQL--defaults-file=d:\mysql\my.ini

4.2 Deleting a service
Mysqld--remove MySQL

4.3 Starting the service
net start MySQL

4.4 Command Line Login
net stop MySQL

4.5 command line start MySQL service (not Windows system service mode)
Mysqld--console

4.6 Command line stop MySQL service (not Windows system service mode)
Mysqladmin-u Root shutdown

Password
If I don't get in at first,
In the My.ini
The password of [client] writes a password eg:password=root
[Mysqld] Join Skip_grant_tables
Go in again mysql-uroot-proot.
Delete unwanted root
Update Set Password =password (' tl123 ') where user= ' root '

net stop MySQL

Remove [client] password write a password eg: #password =
[Mysqld] #skip_grant_tables
net start MySQL

[Client]
#password = root
Port = 3306
Socket =/tmp/mysql.sock
Default-character-set=utf8

# here follows entries for some specific programs

# The MySQL server
[Mysqld]
Port = 3306
Socket =/tmp/mysql.sock
Skip-external-locking
Key_buffer_size = 16M
Max_allowed_packet = 1M
Table_open_cache = 64
Sort_buffer_size = 512K
Net_buffer_length = 8K
Read_buffer_size = 256K
Read_rnd_buffer_size = 512K
Myisam_sort_buffer_size = 8M

Character_set_server = UTF8

#skip_grant_tables
# set Basedir to your installation path

Basedir=d:/mysql-5.5.28-win32

# set DataDir to the * * * of your Data directory
Datadir=d:/mysql-5.5.28-win32/data

Mysql-no-install Manual Installation