MySQL different version installs

Source: Internet
Author: User
Tags change settings mysql login

1.win7 64-bit how to install the configuration mysql-5.7.4-m14-winx64

1. Mysql-5.7.4-m14-winx64.zip Download

2, decompression to d:/mysql. (path itself specified)

3. Create a new My.ini configuration file under D:/mysql/mysql-5.7.4-m14-winx64
The contents are as follows:

################### #配置文件开始 ###################
# for advice The change settings
# * * * Don't EDIT this FILE. It ' s a template which'll be copied to the
# * * * default location during install, and would be replaced if you
# * * * * Upgrade to a newer version of MySQL.
[Client]
Default-character-set=utf8

[Mysqld]
port=3306
Basedir = "d:/mysql/mysql-5.7.4-m14-winx64/"
DataDir = "d:/mysql/mysql-5.7.4-m14-winx64/data/"
Tmpdir = "d:/mysql/mysql-5.7.4-m14-winx64/data/"
Socket = "D:/mysql/mysql-5.7.4-m14-winx64/data/mysql.sock"
Log-error= "D:/mysql/mysql-5.7.4-m14-winx64/data/mysql_error.log"

#server_id = 2
#skip-locking

max_connections=100
table_open_cache=256
query_cache_size=1m

tmp_table_size=32m
Thread_cache_size=8

Innodb_data_home_dir= "d:/mysql/mysql-5.7.4-m14-winx64/data/"
Innodb_flush_log_at_trx_commit =1
innodb_log_buffer_size=128m
innodb_buffer_pool_size=128m
innodb_log_file_size=10m
Innodb_thread_concurrency=16
innodb-autoextend-increment=1000
Join_buffer_size = 128M
Sort_buffer_size = 32M
Read_rnd_buffer_size = 32M
Max_allowed_packet = 32M
Explicit_defaults_for_timestamp=true
Sql-mode= "Strict_trans_tables,no_auto_create_user,no_engine_substitution"
#sql_mode =no_engine_substitution,strict_trans_tables
################### #配置文件结束 ###################

The focus is on the following configuration, where the directory name for DataDir must be: d:/mysql/mysql-5.7.4-m14-winx64/data/.

4, in the Windows System environment variable path, add the following content
D:/mysql/mysql-5.7.4-m14-winx64/bin; (note plus semicolon)

5. Registering MySQL as a Windows system service
To do this, execute the following command on the command line (you need to run the command line as an administrator):
Add Service command: mysqld install MySQL--defaults-file= "D:/mysql/mysql-5.7.4-m14-winx64/my.ini"
The Removal Service command is: mysqld remove

6. After the 5th step succeeds, open the system service management
You can see the MySQL system service (note here):
Need to configure the login property of the MySQL service administrator user login (not configured to start the report 1035 error from service management, the command line to start the report failed)
Start MySQL command at the command line for: net start MySQL
Shutdown mysql command for: net stop MySQL

7. Change the root password to 123456
Command line execution: Mysql–uroot
Mysql>show databases;
Mysql>use MySQL;
mysql> UPDATE user SET Password=password (' 123456 ') WHERE user= ' root ';
mysql> FLUSH privileges;
Mysql> QUIT

8, at this time can be on the local client connection (I use the SQLyog), there is a system library called: MySQL

9. Remote Login Configuration
Allow the root user to remotely log in anywhere and have any permissions to operate on any library, as follows:
1) Log in to MySQL first using the root user:

Command line execution: Mysql-u root-p
Enter password (password set in step 7th): 123456
2) Authorize the operation:
Mysql>grant all privileges on * * to ' root ' @ '% ' identified by ' Youpassword ' with GRANT OPTION;
Overload Authorization Table:
Mysql>flush privileges;
Exit Mysql:quit.

2.win7 64-bit how to install the configuration mysql-5.6.24

1. Download MySQL Community Server 5.6.14

2. Unzip the MySQL archive package

Unzip the downloaded MySQL archive into a custom directory.

3. Add Environment variables

Variable name: mysql_home

Variable Value: D:\Program files\mysql-5.6.14-winx64

This is the custom unzip directory for MySQL.

Add%mysql_home%\bin in Path again

4. Registering Windows System Services

Registering MySQL as a Windows system service

The operation is as follows:

1) Create a new My.ini file and copy the My.ini file to the C:\Windows directory, the My.ini content is as follows:

[Client]
port=3306
Default-character-set=utf8

[Mysqld]
# Set the installation directory to MySQL
Basedir=d:\program files\mysql-5.6.14-winx64
# Data Directory set to MySQL
Datadir=d:\program Files\mysql-5.6.14-winx64/data
port=3306
Character_set_server=utf8
Sql_mode=no_engine_substitution,strict_trans_tables

2) from the console into the bin directory under the MySQL decompression directory.

3) Enter the Service installation command:

Mysqld.exe-install

If Install/remove of the Service denied! appear

Because window 7 is more restrictive than vista.
Go to C:\Window\System32 Find CMD.EXE right-click to select as Administrator, and then go to the corresponding directory to execute the command, everything is OK.

A successful installation will prompt the service to install successfully.

Note: The My-default.ini file is available in the root directory after MySQL decompression, if not, from somewhere else.

The Removal Service command is: mysqld remove

5. Start the MySQL service

Method One:

The Start service command is: net start 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.

6. 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. Example: 123456

Method One:

C:>mysql–uroot

Mysql>show databases;

Mysql>use MySQL;

Mysql>update user SET Password=password ("123456") WHERE user= ' root ';

Mysql>flush privileges; "Attention must not forget this sentence, otherwise the password change cannot take effect"

Mysql>quit

Method Two:

Use third-party management tools for password modification. such as Navicat for MySQL

3.mysql5.5.28 Installation Illustration tutorial

In the database ranks, the performance of MySQL is also very good, now share with you mysql 5.5.28 installation diagram tutorial, for everyone to refer to the next

Tools/Materials
    • Mysql 5.5.28
    • Windows Server 2003 SP2

Method/Step
  1. 1

    First download the version of MySQL 5.5.28, you can baidu this version to download

  2. 2

    Double click the software, the installation interface of the Popup software is as follows

  3. English installation interface, no problem, engage it people, data, afraid of this English words that is really justified. Click Next to continue the installation

  4. After agreeing to the license, click Next.

    Ask here whether you want a typical installation, a custom installation, or a full installation. Here I choose the Custom option to continue the installation.

  5. Here choose, the installation location and function of the software. Click Next to proceed with the installation

  6. Then confirm and install, if there is no problem, press install

  7. During the installation process, some of the customizations are then popped up, as follows

  8. After the installation is complete, you will be prompted to eject the Configuration Wizard, as follows

  9. Standard configuration, click Next to continue

  10. Then configure the MySQL root user's password and set whether the MySQL service can be connected remotely.

  11. Then perform these configurations to write to the file inside, with a progress display. Finally click Finish.

  12. Now that the MySQL installation has been completed, we can finally test the success of MySQL login at the command line.

MySQL different version installs

Related Article

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.