MySQL 5.6 (Win7 64-bit) download, install and configure graphics tutorials

Source: Internet
Author: User



A Tools



WIN7 64-bit operating system



Two Steps



First step: Download the installation package



Download Address: http://www.mysql.com/






As of Now (2016/7/24), the latest version of the official website is 5.7.13, but not using this version, the download is the previous version of 5.6.31.






The platform defaults to Windows.






Confirm your machine word length, click Download.



Step Two: Unzip



After unpacking, you can rename the folder and put it in the appropriate location. I renamed the folder to MySQL Server 5.6 and placed it in the D:\Program files\mysql path. Of course you can put it anywhere you want.






Step Three: Configure (do not rush to use, preferably configured first)



After you configure the environment variable path, you can open MySQL later without switching directories. Principle: Simply put, the path inside the environment variable is the lookup directory of the CMD system. You enter a command, how does the system know that this command is there? How did the system do it? In fact, the system is in the current directory and the system environment variable path inside of the search, to find the first to prevail, can not find the error. So after you set up path, you can save the hassle of switching directories with commands every time. An analogy: The system is like a bus, according to the established route. The path inside the environment variable is the driving route. Go to a station (find the first directory) and get Off (run).



Procedure: Computer--System Properties, advanced system configuration, environment variables






Select Path, after which you add: the path to your MySQL Bin folder (for example: my: D:\Program files\mysql\mysql Server 5.6\bin) modified path is:



Path=.;D: \program Files\mysql\mysql Server 5.6\bin (Note: 1. The semicolon must be added in English after the original path; 2. is append, not overwrite. )






Fourth Step: Modify the configuration file



Do not start MySQL after configuring environment variables, also need to modify the configuration file, mysql-5.6.1x default configuration file is D:\Program files\mysql\mysql Server 5.6\ My-default.ini, you can build a My.ini file yourself, in which you modify the configuration:



[Mysqld] Basedir=c:\program files\mysql\mysql Server 5.6 (MySQL directory) datadir=c:\program files\mysql\mysql server 5.6\ Data (MySQL directory \data)



Mydefault.ini content is as follows:






My.ini content is as follows:






Fifth step: Install MySQL



First, run CMD as an administrator (you must run as administrator, or you will not have enough permissions to make an error)



Next, enter the D:\Program files\mysql Server 5.6\bin directory,



Then, executemysqld –installthe command and, if there is no error, prompt the installation to succeed.






Note: If you have previously installed MySQL, but for some reason it is not uninstalled, when you install MySQL again, you will be prompted that the service already exists. The sc delete mysql command is available, the previous version is removed, and the Mysqld–install command is executed.






Sixth step: Start the MySQL server



Enter the command in CMDnet start mysql.






Seventh step: Log in to MySQL



In cmd, entermysql -u root -p, first login without password, direct enter, login successful.






The command to exit MySQL is exit. The direct close CMD window is not exited, and the exit is not exited until you enter exit.



MySQL 5.6 (Win7 64-bit) download, install and configure graphics tutorials


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.