MySQL installation configuration

1. First download the Windows edition to http://dev.mysql.com/, Mysqlinstall, this software MySQL provides the software for installing the solution for the Windows platform.

2. Copy the My-default.ini under MySQL and create the My.ini in the same directory. My.ini is the configuration for MySQL. The simplest configuration:

1 basedir=d:/mysql-5.6.20-winx642 Datadir=d:/mysql-5.6.20-winx64/data

Base Config

My configuration is:

 1 # for advice on what to change settings please see 2 # HTTP://DEV.MYSQL.COM/DOC/REFMAN/5.6/EN/SERVER-CONFIGURATION-DEFAU Lts.html 3 # * * * * does not EDIT this FILE. It's a template which'll be copied to the 4 # * * * * default location during install, and'll be replaced if you 5 # * * * u Pgrade to a newer version of MySQL. 6 7 [mysqld] 8 Character-set-server=utf8 9 # Remove Leading # and set to the amount of RAM for the most important data # Cache in MySQL. Start at 70% of all RAM for dedicated server, else 10%.12 # innodb_buffer_pool_size = 128m13 # Remove leading # to Tu RN on a very important data integrity Option:logging15 # Changes to the binary log between backups.16 # log_bin17 # Th ESE is commonly set, remove the # and set as required.19 # Basedir = ..... # DataDir = ... # port = ..... # server_id = ... basedir=d:/mysql-5.6.20-winx6424 datadir=d:/mysql-5.6.20-winx64/data25 port=330626 character-set-server= utf828 default-storage-engine=innodb29 Innodb_datA_home_dir=d:/mysql-5.6.20-winx64/data30 innodb_data_file_path=ibdata1:12m:autoextend31 Innodb_log_group_home_ Dir=d:/mysql-5.6.20-winx64/data32 INNODB_BUFFER_POOL_SIZE=512M34 # Remove Leading # To set options mainly useful for re Porting servers.35 # The server defaults is faster for transactions and fast selects.36 # Adjust sizes as needed, Experim Ent to find the optimal values.37 # join_buffer_size = 128m38 # sort_buffer_size = 2m39 # read_rnd_buffer_size = 2M 40 41  # Sql_mode=no_engine_substitution,strict_trans_tables

My.ini

3. Set the environment variable path. Add D:\mysql-5.6.20-winx64\bin to path.

4.CMD below try to start mysqld, and the background log output on the screen.

5. Register MySQL for Windows service. You can later use Windows service to install Mysqld and uninstall MYSQLD services.

6. Go to Service Manager

7. Start the MySQL service

8.net start MySQL start MySQL service, net stop MySQL stop MySQL service

9. You can also turn off the MySQL service using the mysqladmin command.

10. Log in to the MySQL database using the root user

11.show databases; show all databases

12. Change the login password of the root account 1234:

13. Create a database to specify the Chinese encoding method

14. View MySQL Storage engine

15. Create MySQL remote connection user, set maximum permissions and login password.

There are also some commands for testing MySQL installation:

If a startup error occurs, the My.ini is generally not configured successfully.

You can view the *.err file under the root directory to troubleshoot the situation.

One of the cases is to restart the ib_logfile0,ib_logfile1 after it has been deleted.

MySQL installation configuration