MySQL Zip installation under Windows

Source: Internet
Author: User

Method from the great Internet.

1. Go to the official website to download the compressed package for MySQL server in. zip format, select x86 or x64 as needed. Note: The download is required to register an account and log in.

2. Unzip to the location you want.

3. Copy the extracted directory under My-dafault.ini to the bin directory and rename it to My.ini. and add the following (the path should be modified according to your own situation). No data directory does not matter, the next step to deal with this thing.

4. Starting with MySQL 5.7, Oracle began working to disrupt MySQL's ease of use and force users to work with Oracle databases. A joke. However, there is no data folder to make many configuration methods on the Web invalid, if not initialized, the MySQL service can not be started . Here's how to initialize it:

(1) Run cmd as Administrator, and CD to the bin directory in MySQL, execute command: mysqld--initialize--user=mysql--console

(2) The command creates the data directory with the database, generates the root user and the temporary password, for example, we need to remember this command for easy login.

5. Configure the environment variables, otherwise you will need to CD to the bin directory each time to use MySQL. Right-click this computer (computer)-Properties-Advanced system Settings-advanced-environment variables, add your bin directory to the path in the system variable, such as: C:\mysql-5.7.12-winx64\bin, click OK! Generally do not need to restart, if necessary, when I did not say.

6. Install the MySQL service, run cmd as Administrator, and enter mysqld install MySQL--defaults-file= "C:\mysql-5.7.12-winx64\bin\my.ini", Where the path is your official INI file.

7. Run cmd, enter net start MySQL to start the MySQL service, enter Mysql-u root-p, and then enter the temporary password. Change Password: Set password = password (' New password '), and then enter on it, note that the semicolon cannot be omitted.

That's it.

MySQL Deployment when table ' Mysql.plugin ' doesn ' t exist is resolved by Yanina2011

Today deployed a version-free MySQL, appeared the table ' Mysql.plugin ' doesn ' t exist problem, distressed for a long time, finally found a solution on the internet, now tidy up for everyone to share:

System environment: WIN10 64-bit

MySQL version: mysql-5.7.17-winx64

The step of deployment is to follow the online:

1: Modify environment variable path, add value C:\Program files\mysql-5.7.17-winx64\bin

2: Modify My-default.ini, rename to My.ini, modify file contents:

# basedir = C:\Program files\mysql-5.7.17-winx64
# DataDir = C:\Program Files\mysql-5.7.17-winx64\data

Create an empty Data folder under the home directory "C:\Program files\mysql-5.7.17-winx64";

3: The administrator runs cmd, enter: Mysqld-install, display installation success, and then enter: Net start MySQL, prompt to start the service failed,

At this point: see 5 Files under the Data folder, open the file with the suffix. Err, inside prompt: Table ' mysql.plugin ' doesn ' t exist

The solutions to this problem are:

1. Copy the My.ini to the \ Bin folder;

2. In cmd to \ Bin directory, then enter mysqld--initialize--user=mysql--console execute this command to generate the library. Note that there is a temporary password, to be written down;

3. Start the service net start MySQL;

4. Enter the MySQL command: mysql-uroot-p, enter the password just now;

5. Re-enter Set password = password (' root ') to modify the root login password;

I succeeded in doing this, and I hope it will be helpful to you.

MySQL Zip installation under Windows

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.