MySQL-5.6.24 and other free installation version configuration method

MySQL-5.6.24 and other free installation version configuration method

1. Download MySQL-5.6.24

(direct Baidu search MySQL download can be)

2. Unzip the MySQL archive package

unzip the downloaded MySQL package into a custom directory, and my unzip directory is:
"C:\Java\mysql"
will unzip the directory under the default file My-default.ini copy one copy, renamed My.ini
Copy the following configuration information to My.ini save
#如果没有my-default.ini, you can create your own my.ini or get it from somewhere else .[Mysqld]

#绑定IPv4和3306端口
Bind-address = 127.0.0.1
Port = 3306
# set up the MySQL installation directory, that is, you unzip the location of the installation package, you need to note that this is a slash "/" instead of Windows inside the backslash ' \ "
Basedir=c:/java/mysql

# Set up a storage directory for MySQL database data
Datadir=c:/java/mysql/data
# Maximum number of connections allowed
max_connections=200
#设置字符集为utf8
Loose-default-character-set = UTF8
#开启查询缓存
Explicit_defaults_for_timestamp=true
Sql_mode=no_engine_substitution,strict_trans_tables

[Client]
#设置客户端字符集
port=3306
Loose-default-character-set = UTF8
[Winmysqladmin]
Server = C:/java/mysql/bin/mysqld.exe

3. Add Environment variables

1) Variable name: Mysql_home variable Value: C:\Java\mysql
2) when adding%mysql_home%\bin in path, note the delimiter ";"

4. Register MySQL as a Windows system service ( Run command prompt as Administrator)

1) from the console into the bin directory under the MySQL decompression directory:
2) Enter the Service installation command: Mysqld-install
#移除服务命令为: mysqld Remove

5. Change the password of the root account

The default password for the root account is empty when the installation is complete, and you can modify the password to the specified password. such as: Root

C:\>CD Java

C:\JAVA>CD MySQL

C:\JAVA\MYSQL>CD bin

C:\java\mysql\bin>mysql-uroot

mysql> show databases;

+--------------------+
| Database |
+--------------------+
| Information_schema |
| MySQL |
| Performance_schema |
| Test |
+--------------------+
4 rows in Set (0.01 sec)

mysql> use MySQL;
Database changed
Mysql> Delete from User where user= "";
Query OK, 1 row Affected (0.00 sec)

mysql> Update User Set Password=password (' root ') where user= ' root ';
Query OK, 3 Rows Affected (0.00 sec)
Rows Matched:3 Changed:3 warnings:0

mysql> FLUSH privileges;
Query OK, 0 rows Affected (0.00 sec)

Mysql> QUIT;
Bye

C:\java\mysql\bin>mysql-uroot-p
Enter Password:root
Welcome to the MySQL Monitor. Commands End With;

6. Start the shutdown MySQL service ( Run command prompt as Administrator)

Method One:

The Start service command is: net start MySQL

Shutdown Service Command for: net stop MySQL

Method Two:
Open the Administration Tools service and locate the MySQL service.
Start the service by right-clicking to start or by tapping on the left-hand boot directly.

7. mysql Console shortcut established:1) object location input, new shortcut, right-click, desktop: C:\Windows\System32\cmd.exe OK, shortcut established successfully
2) Right-click the shortcut you just created, and then change the target column to the MySQL startup parameter:
C:\Windows\System32\cmd.exe "C:\mysql\bin"/k mysql-uroot-proot
3) Click OK to save after the modification, double click the shortcut to connect to MySQL databaseattached: I cloud disk:mysql-5.6.24 Free Installation: Https://yunpan.cn/cqCaej648k5dI access password Ca48my.ini https://yunpan.cn/cqCantGCCdMDN access password 8fab

MySQL-5.6.24 and other free-installation version configuration method