MySQL5.5 installation under Windows (unzip as a folder)

Source: Internet
Author: User

The MSI installation of MySQL 5.5.10 always fails and is never passed in the instance configuration, so it can only be installed through archive.

1, first download Windows (x86, 64-bit), ZIP Archive installation package.

2. Extract to any directory such as: E:\MySQL\MySQL Server 5.5

3. Select the *.ini file in the installation directory (select My-medium.ini here) to copy and rename the My.ini file. Add the following content:

[client]default-character-set=Utf8[mysqld]basedir="e:/mysql/mysql Server 5.5/"DataDir="e:/mysql/mysql Server 5.5/data/"Character-set-server=UTF8 Uncomment the following: Innodb_data_home_dir= E:\\mysql\\mysql Server5.5\\data\\Innodb_data_file_path= ibdata1:10m:Autoextendinnodb_log_group_home_dir= E:\\mysql\\mysql Server5.5\\datainnodb_buffer_pool_size=16minnodb_additional_mem_pool_size=2minnodb_buffer_pool_size=16minnodb_additional_mem_pool_size= 2M

4. Add E:\MySQL\MySQL Server 5.5\bin to the environment variable path;

5, test whether MySQL can start normally.

C:\>CD E:\mysql\mysql Server 5.5\

. \mysqld--console

If prompted: Mysqld:ready for connectionsversion: ' 5.5.9 ' socket: ' port:3306 ' means to start MySQL normally from the console, now press Crtl+c to end, so you can intermittently install into Windo WS service out.

If MySQL is running, you can end it with the following command:

Shutdown

6, install WINODWS service. Execute the following command:

. \mysqld.exe--install MySQL5. 5 --defaults-file="E:\MySQL\MySQL Server 5.5\my.ini"net start mysql5. 5

If everything works, the service is properly installed.

7, change the root password.

The first time you install MySQL, the user root is not set up, here to set the password for root:

. \mysql-u Root-Pmysql> UseMysql;mysql>desc User;mysql>grant all privileges on * * to [email protected]"%"Identified by"Root";//the ability to add remote connections for root. MySQL>update user Set Password = Password ('xxxxxx') Where user='Root'; MySQL>SelectHost,user,password from User where user='Root'; MySQL>Flush Privileges;mysql>Exit

Log back in to MySQL

#.\mysql-u root-p

Mysql> Show variables like ' char% '; can see if character encoding is set to UTF8

 +--------------------------+-------------------------------------------------+| variable_name | Value |+--------------------------+--------------------------------------------- ----+| character_set_client | UTF8 | | character_set_connection | UTF8 | | Character_set_database | UTF8 | | Character_set_filesystem | binary | | Character_set_results | UTF8 | | Character_set_server | UTF8 | | Character_set_system | UTF8 | | Character_sets_dir | E:\MySQL\MySQL Server 5.5  \share\charsets\ |+--------------------------+------ -------------------------------------------+

8. Add a new user.

Reference: MySQL--add user, permission Refresh

Grant all privileges on * * to user name [email protected]'%'Identified by'Password'; grant all privileges on* * to User name @'localhost'Identified by'Password'; grant all privileges on* * to User name @'127.0.0.1'Identified by'Password';#INSERT INTO User (Host,user,password) values (' localhost ', ' username ', ' password '), #insert into user (Host,user,password) values (' 127.0.0.1 ', ' username ', ' password '); Insert into User (Host,user,password)Values(':: 1','User name',"'); #Update user Set Password = Password (' password ') where user= ' username ';SelectHost,user,password from User where user='User name'; flush privileges;

Note: The grant command also adds a new record to the user table, so the grant command does not need to insert a new record entry.

Use the UPADTE statement if you want to unify all of the user's passwords.

9. Create a database.

Reference: http://tech.ccidnet.com/art/1105/20041104/173233_1.html

MySQL5.5 installation under Windows (unzip as a folder)

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.