win7 64ä½ä¸å¦ä½å®è£
é
ç½®mysql-5.7.4-m14-winx64
1. mysql-5.7.4-m14-winx64.zipä¸è½½
2ã解åå°D:/mysql.ï¼è·¯å¾èªå·±æå®ï¼
3ãå¨D:/mysql/mysql-5.7.4-m14-winx64ä¸æ°å»ºmy.inié
ç½®æ件
å
容å¦ä¸ï¼
####################é
ç½®æ件å¼å§###################
# For advice on how to change settings please see
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will 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
####################é
ç½®æ件ç»æ###################
éç¹æ¯ä»¥ä¸é
ç½®ï¼å
¶ä¸datadirçç®å½å称å¿
é¡»æ¯ï¼D:/mysql/mysql-5.7.4-m14-winx64/data/ã
4ãå¨windowsç³»ç»ç¯å¢åépathï¼å å
¥å¦ä¸å
容
D:/mysql/mysql-5.7.4-m14-winx64/bin;ï¼æ³¨æå åå·ï¼
5ãå°mysql注å为windowsç³»ç»æå¡
å
·ä½æä½æ¯å¨å½ä»¤è¡ä¸æ§è¡ä»¥ä¸å½ä»¤ï¼éè¦ä»¥ç®¡çå身份è¿è¡å½ä»¤è¡ï¼ï¼
å¢å æå¡å½ä»¤ï¼mysqld install MySQL --defaults-file="D:/mysql/mysql-5.7.4-m14-winx64/my.ini"
移é¤æå¡å½ä»¤ä¸ºï¼mysqld remove
6ã第5æ¥æååï¼æå¼ç³»ç»æå¡ç®¡ç
å¯ä»¥çå°mysqlç³»ç»æå¡(æ¤å¤éè¦æ³¨æ):
éè¦å¨mysqlæå¡çç»éå±æ§éé
置管çåç¨æ·ç»éï¼ä¸é
ç½®ä»æå¡ç®¡çéå¯å¨æ¥1035é误ï¼å¨å½ä»¤è¡å¯å¨æ¥å¯å¨å¤±è´¥ï¼
å¨å½ä»¤è¡å¯å¨mysqlå½ä»¤ä¸ºï¼ net start mysql
å
³émysqlå½ä»¤ä¸ºï¼net stop mysql
7ãä¿®æ¹rootçå¯ç 为123456
å½ä»¤è¡æ§è¡ï¼mysql âuroot
mysql>show databases;
mysql>use mysql;
mysql> UPDATE user SET password=PASSWORD('123456') WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> QUIT
8ãæ¤æ¶å¯ä»¥å¨æ¬æºä¸å®¢æ·ç«¯è¿æ¥äºï¼æ¬äººç¨çæ¯SQLyogï¼ï¼æ个系ç»åºå«ï¼mysql
9ãè¿ç¨ç»éé
ç½®
å
许rootç¨æ·å¨ä»»ä½å°æ¹è¿è¡è¿ç¨ç»å½ï¼å¹¶å
·æææåºä»»ä½æä½æéï¼å
·ä½æä½å¦ä¸ï¼
1ï¼å¨æ¬æºå
使ç¨rootç¨æ·ç»å½mysqlï¼
å½ä»¤è¡æ§è¡ï¼mysql -u root -p
è¾å
¥å¯ç ï¼ç¬¬7æ¥ä¸è®¾ç½®çå¯ç ï¼ï¼123456
2ï¼è¿è¡æææä½ï¼
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
éè½½ææ表ï¼
mysql>FLUSH PRIVILEGES;
éåºmysqlï¼quit..ãããã
温馨提示:答案为网友推荐,仅供参考