mysqlÊý¾Ý¿â64λÊǽüÆÚµÄmysqlÊý¾Ý¿â°æ±¾ÁË£¬Óë´ËͬʱҲÊÇÊÊÓúºÓïµÄ°æ±¾£¬ÔÚÈç½ñÕâÒ»°æ±¾ÊÇÄܹ»ÊÊÓÃwin10µÄϵͳÈí¼þ¼°Æäwin8.1µÄ°æ±¾£¬ÓбØÐë¸ÐÊÜÏÂÕâÒ»mysqlÊý¾Ý¿â64λÈçºÎµÄ£¬Äܹ»ÏÈÀ´±¾ÍøÕ¾ÍêÈ«Ãâ·ÑµÄÏÂÔØÊÔÒ»ÏÂʵ¼ÊЧ¹ûÈçºÎ£¡

MySQL°²×°±íÃ÷

1.ÔÚ±¾ÍøÕ¾ÏÂÔØȫа汾µÄMySQL Êý¾Ý¿âСÇø°æ£¨Community£©Ñ¹Ëõ°ü£¬Ñ¹Ëõ°ü½âѹ£»

2.ËæºóµÃµ½Ò»¸ömysql-installer-web-community-8.0.18.msiÎĵµ£¬Ë«»÷Êó±ê°²×°£»

3.ÔÚ·¢ÉúµÄ¡°License Agreement¡±Ìáʾ¿òÒ³Ã棬¸ÃÒ³Ãæ¹æ¶¨¿Í»§Îñ±Ø½ÓÄɸÃЭÒéÊé²Å¿ÉÒÔ°²×° MySQL Êý¾Ý¿â¡£ÆôÓøÃÒ³Ãæϱߵġ°I accept the license terms¡±¹´Ñ¡¿ò£¬Ëæºóµã»÷¡°Next¡±°´¼ü£¬±íÃ÷ÈçÏÂͼËùʾµÄ°²×°Ñ¡ÔñÏîÌáʾ¿ò£»

4.ÆôÓá°Custom¡±µ¥ÏîÑ¡ÔñÌâÅ¥£¬Ëæºóµã»÷¡°Next¡±°´¼ü¡£ÔÚÏÂÃæµÄÒ³ÃæÖÐÄܹ»ÌôÑ¡°²×° MySQL ÐèÒªµÄ²¿¼þ£¬²¢ÌôÑ¡ MySQL Êý¾Ý¿â¼°Êý¾Ý¿âÎļþµÄ°²×°Í¾¾¶£¬±¾ÊµÀý½Ì³ÌÌôÑ¡½« MySQL Êý¾Ý¿âºÍÊý¾Ý¿âÎļþ¶¼°²×°ÔÚ D ÅÌÀï¡£ÌôÑ¡°²×° MySQL ÍøÂç·þÎñÆ÷.Îı¾ÎĵµºÍ Connector/Python£¨Õâ¾ÍÊÇ Python Áª½Ó MySQL µÄ¿ØÖÆÄ£¿é£©£»

5.µã»÷¡°Next¡±°´¼ü£¬MySQL Installer »á²éÑéϵͳÈí¼þ×ÔÈ»»·¾³ÊDz»ÊÇ´ïµ½°²×° MySQL Êý¾Ý¿âµÄ¹æ¶¨¡£¼ÙÈç·ûºÏÒªÇó£¬ÔòÄܹ»Á¢¼´µã»÷¡°Next¡±°´¼üÖð½¥°²×°£»Èç¹û²»Âú×ãÌõ¼þ£¬ÇëÒÀ¾Ý MySQL ÌáÐÑÏÈ°²×°Ïà¶ÔÓ¦µÄϵͳÈí¼þ²¿¼þ£¬ËæºóÔÙÔٴΰ²×° MySQL Êý¾Ý¿â£»

6.Öð½¥°²×° MySQL Êý¾Ý¿â£¬°²×°½øÐк󣬻ᷢÉúÈçÏÂͼȡµÃ³É¹¦°²×°µÄÌáʾ¿ò¡£

ÓÈÆä±íÃ÷£ºMySQL8.0 ±ØÐë Visual C 2015 Redistributable£¬²¢ÇÒÎÞÂÛ²Ù×÷ϵͳ 32 λ»òÊÇ 64 λµÄ£¬Ëü×ÔʼÖÁÖÕ±ØÐë 32 λµÄ Visual C 2015 Redistributable£¬²»È»»á°²×°²»³É¹¦¡£

7.MySQL Êý¾Ý¿â³ÌÐòÁ÷³Ì°²×°È¡µÃ³É¹¦ºó£¬ÏµÍ³Èí¼þ»¹¹æ¶¨Å䱸 MySQL Êý¾Ý¿â¡£µã»÷ÈçÏÂͼËùÏÔʾÌáʾ¿òϱߵġ°Next¡±°´¼ü£¬Öð½¥Å䱸 MySQL Êý¾Ý¿â¡£ÔÚÈçÏÂͼËùÏÔʾµÄÌáʾ¿òÖУ¬Ñ¡¶¨¡°Standalone MySQL Server/Classic MySQL Replication¡±µ¥ÏîÑ¡ÔñÌâÅ¥£¬¾Í¿ÉÒÔ¿ªÕ¹¸ü¾ßÌåµÄÅ䱸¡£

8.2´Îµã»÷¡°Next¡±°´¼ü£¬½«·¢ÉúÈçÏÂͼËùÏÔʾµÄÌáʾ¿ò£¬ÈÝÐí¿Í»§É趨 MySQL µÄ root ÕÊ»§µÇ½ÃÜÂ룬ҲÈÝÐí¼ÓÉÏ´óÁ¿µÄ¿Í»§¡£

9.¼ÙÈçҪΪ MySQL Êý¾Ý¿â¼ÓÉÏ´óÁ¿µÄ¿Í»§£¬Ôò¿Éµã»÷¡°Add User¡±°´¼ü¡£É趨½øÐк󣬵ã»÷¡°Next¡±°´¼ü£¬½«ÏȺó·¢ÉúһϵÁÐÌáʾ¿ò£¬µ«ÕâÖÖÌáʾ¿ò¶ÔÅ䱸Σº¦²¢²»´ó£¬Á¢¼´µã»÷¡°Next¡±°´¼ü£¬Ö±µ½ MySQL Êý¾Ý¿âÅ䱸ȡµÃ³É¹¦¡£

MySQL ¿É¸ù¾ÝcmdÊÖ»ú¿Í»§¶ËÀ´¹ÜÀí·½·¨ MySQL Êý¾Ý¿â¼°Êý¾Ý¿âÖеÄÊý¾ÝÐÅÏ¢¡£Í¨¹ýÉϱߺöà¸öÁ÷³ÌÒÔºó£¬Ó¦µ±ÔÚ Windows µÄ¡°Ö𽥡±²Ëµ¥À¸Öмûµ½¡°MySQL¡±¡ú¡°MySQL Server 8.0¡±¡ú¡°MySQL 8.0 Command Line Client - Unicode¡±²Ëµ¥À¸£¬µã»÷¸Ã²Ëµ¥À¸½«ÔËÐÐ MySQL µÄcmdÊÖ»ú¿Í»§¶Ë¶Ô»°¿ò£¬½øµ½¸Ã¶Ô»°¿ò¿ÉÄÜÌáÐѼüÈë root ÕÊ»§µÇ½ÃÜÂë¡£

ÁôÒ⣺ÒòΪ MySQL ĬÈÏÉèÖÃÓ¦Óà UTF-8 ×Ö·û´®Êý×飬Òò¶øÓ¦µ±¸ù¾Ý¡°MySQL 8.0 Command Line Client - Unicode¡±²Ëµ¥À¸ÔËÐÐÃüÁîÐй¤¾ß£¬¸ÃרÓù¤¾ß¿ÉÄÜÓ¦Óà UTF-8 ×Ö¶ÎÃû¡£Ä¿Ç°ÊÐÃæÉÏÓÐÒ»¸öÃû½ÐSQLyog µÄרÓù¤¾ß³ÌÐòÁ÷³Ì¸øÓèÁ˲»´íµÄͼÐνçÃæÉè¼ÆÀ´¹ÜÀí·½·¨MySQLÊý¾Ý¿âÖеÄÊý¾ÝÐÅÏ¢¡£´ËÍ⣬MySQLÒ²±£Ö¤ÁËMySQLAdministrator רÓù¤¾ßÀ´¹ÜÀí·½·¨MySQLÊý¾Ý¿â¡£ÔĶÁÕßÄܹ»×ÔÖ÷ÏÂÔØÕâÁ½¸öרÓù¤¾ß£¬²¢Ó¦ÓÃÕâÁ½¸öרÓù¤¾ßÀ´¹ÜÀí·½·¨MySQLÊý¾Ý¿â¡£µ«±¾ÊµÀý½Ì³ÌÈÔȻǿÁÒÍƼöÔĶÁÕßÓ¦ÓÃÃüÁîÐй¤¾ß£¬ÓÉÓÚÕâÀà¡°¼«¶Ë¡±µÄרÓù¤¾ß»áÇ¿ÖÆÐÔÔĶÁÕß¼ÇÀÎSQLÖ¸Áî¡£

mysqlÊý¾Ý¿â64λ±¸·Ý»Ö¸´Ö¸Áî

mysqldump -uµÇ¼Ãû -pµÇ½ÃÜÂë -h·þÎñÆ÷Êý¾Ý¿â a -w sql±ê×¼ --lock-all-tables ;¾¶

ʵÀý£º

mysqldump -uroot -p1234 -hlocalhost db1 a -w id in (select id from b) --lock-all-tables c:\aa.txt

mysqldump¸´Ô­£º

mysqldump -uµÇ¼Ãû -pµÇ½ÃÜÂë -h·þÎñÆ÷Êý¾Ý¿â;¾¶

ʹÓ÷½·¨

1.½«ÏÂÔØµÄ mysql-5.7.17-winx64.zip »º½âѹÁ¦×Ô¶¨ÎļþĿ¼£¬Õâ¶ùÎÒÃǽ«°ÑÕâ¸öÎļþ½âѹÖÁ D:\mysql-5_x64 ÎļþĿ¼;

2.¿ªÆôÕâÒ»ÎļþĿ¼£¬·¢¾õÀïµÄÎļþ¼ÐÃû³ÆºÍÎĵµ¸úÒ»¸ö°²×°ºÃºóµÄMySQL»ù±¾ÉÏ›]Óвî±ð

3.¸Ä¶¯MySQL»·¾³±äÁ¿£¬ÔÚmysql-5_x64ÎļþĿ¼ÏÂÓÐÒ»¸ömy-default.ini£¬Äܹ»ËãÊÇÄ£°æÀ´Ó¦Óã¬Àï±ßµÄÐÅÏ¢²¢²»ÊÇÐí¶à£¡Äܹ»×ÔÉí´´Á¢Ò»¸ö my.ini×öΪMySQL»·¾³±äÁ¿£¬¿ªÆômy.iniÉ趨

[client]

port=3306

#ÊÖ»ú¿Í»§¶Ë±êʶ·ûÖÖÀ࣬Óë·þÎñÆ÷¶ËÒ»Ö¾ͿÉÒÔÁË£¬ÌáÒéutf8

default-character-set=utf8

[mysqld]

#¹ØÁªIPv4ºÍ3306¶Ë¿ÚºÅ

bind-address = 0.0.0.0

port = 3306

#·þÎñÆ÷¶Ë±êʶ·ûÖÖÀ࣬ÌáÒéutf8

character_set_server=utf8

# É趨mysqlµÄ°²×°ÎļþĿ¼

basedir=D:/mysql-5_x64

# É趨mysqlÊý¾Ý¿âµÄÊý¾Ý×ÊÁϵĴ¢·ÅÎļþĿ¼

datadir=D:/mysql-5_x64/data

# ÈÝÐí×î´óÁ¬½ÓÊý

max_connections=201

ÄÇÑùÒ»¸öÖ÷ÒªµÄMySQL×ÔÈ»»·¾³ËùÐëÒªµÄÖ÷Òª²ÎÊý¾Í¿ÉÒÔÁË

4.MySQLϵͳ±äÁ¿

ÓÒ¼üÕą̂µçÄÔÉÏ--ÌØÐÔ--¸ß¼‰--ϵͳ±äÁ¿--¿Í»§×Ô±äÁ¿Ð´´½¨×Ô±äÁ¿MYSQL_HOME ÖµD:\mysql-5_x64 ,»·¾³±äÁ¿Ñ°ÕÒ×Ô±äÁ¿path ±àд ÔÚºóÃæÔÙ¼ÓÉÏ ;%MYSQL_HOME%\bin

5.°²×°MySQLÊý¾Ý¿â

ÔËÐÐcmd £¨Win8 .Win10ÒÔ¹ÜÀíÈËÔ±ÔËÐÐcmd£©--½øµ½D:\mysql-5_x64\binÎļþĿ¼

Microsoft Windows [°æ±¾ 10.0.10240]

(c) 2015 Microsoft Corporation. All rights reserved.

C:\Windows\system32D:

D:\cd mysql-5_x64

D:\mysql-5_x64cd bin

D:\mysql-5_x64\bin

ʵÐÐmysqld -install °²×°MySQL

D:\mysql-5_x64\binmysqld -install

Service successfully installed

ʵÐÐnet start mysqlÔËÐÐMySQL

D:\mysql-5_x64\binnet start mysql

D:\mysql-5_x64\binnet start mysql

MySQL ·þÎñÏîÄ¿ÒѾ­ÔËÐÐ .

MySQL ·þÎñÏîÄ¿ÔçÒÑÔËÐÐÈ¡µÃ³É¹¦

ÔËÐÐMySQL·þÎñÏîÄ¿£ºnet start mysql

ÖÕÖ¹MySQL·þÎñÏîÄ¿£ºnet stop mysql

ɾµôMySQL·þÎñÏîÄ¿£ºsc delete mysql

¸Ä¶¯MysqlµÇ½ÃÜÂë

D:\mysql-5_x64\binmysql -u root -p //Ó¦ÓÃrootµÇ½mysql

Enter password: //µÇ½ÃÜÂë¿Õ£¬»Ø³µ¼ü¾Í¿ÉÒÔ

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.6.26 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type help; or \h for help. Type \c to clear the current input statement.

mysql

½øµ½mysqlÊý¾ÝÐÅÏ¢.ɾµô¿Õ¿Í»§

Éý¼¶µÇ½ÃÜÂë²¢ÔÙ´ÎˢȨÏÞ±íµ½ÔËÐÐÄÚ´æ(»¹¿ÉÒÔÓÃmysqladminרÓù¤¾ßÀ´ÃÜÂëÉèÖÃ)

mysql update User set Password=PASSWORD(123456) where User=root;

Query OK, 4 rows affected (0.00 sec)

Rows matched: 4 Changed: 4 Warnings: 0

mysql flush privileges;

Query OK, 0 rows affected (0.00 sec)

ÊÔ×ŵǼ

D:\mysql-5_x64\binmysql -u root -p //ÓÃroot¿Í»§µÇ½Êý¾Ý¿â

Enter password: ****** //¼üÈëÉý¼¶ºóµÄµÇ½ÃÜÂë 123456

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 5

Server version: 5.6.26 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type help; or \h for help. Type \c to clear the current input statement.

mysql