mysql 5.7.14 免裝置版留意事項(精)。本站提示廣大學習愛好者：（mysql 5.7.14 免裝置版留意事項(精)）文章只能為提供參考，不一定能成為您想要的結果。以下是mysql 5.7.14 免裝置版留意事項(精)正文
相干浏覽：
MySql 5.7.14 裝置教程詳解(解壓版)
Mysql 5.7.14 應用罕見成績匯總(推舉)
1、解壓
2、在目次D:\Program Files\mysql-5.7.14-winx64下復制my-default.ini，放在與其雷同目次下，稱號顯示為my.ini；
3、編纂my.ini
# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html # *** 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] # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # These are commonly set, remove the # and set as required. basedir = D:\Program Files\mysql-5.7.14-winx64 datadir = D:\Program Files\mysql-5.7.14-winx64\data tmpdir = D:\Program Files\mysql-5.7.14-winx64\data socket = D:\Program Files\mysql-5.7.14-winx64\data\mysql.sock port = 3306 # server_id = ..... max_connections = 100 table_open_cache = 256 query_cache_size = 1M tmp_table_size = 32M thread_cache_size = 8 innodb_data_home_dir = D:\Program Files\mysql-5.7.14-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 # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M join_buffer_size = 128M sort_buffer_size = 32M read_rnd_buffer_size = 32M max_allowed_packet = 32M explicit_defaults_for_timestamp = true sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
4、在解壓目次D:\Program Files\mysql-5.7.14-winx64下新建data文件（不消在文件夾做其他操作）
5、以治理員身份進入cmd界面（必需是治理員）
6、切換至mysql解壓目次\bin下，初始化data目次
輸出敕令：mysqld --initialize-insecure (生成無暗碼的root用戶)
或：mysqld --initialize(生成帶隨秘密碼的root用戶)
7、初始化完成後啟動mysql辦事
輸出敕令：net start mysql
8、開端應用mysql
輸出敕令：mysql -u root -p
9、停滯mysql辦事
輸出敕令：net stop mysql
10、忘卻root暗碼後若何登錄
101、 封閉正在運轉的MySQL辦事。
10.2、 翻開DOS窗口，轉到mysql\bin目次。
10.3、輸出mysqld --skip-grant-tables 回車。--skip-grant-tables 的意思是啟動MySQL辦事的時刻跳過權限表認證。
10.4、再開一個DOS窗口（由於適才誰人DOS窗口曾經不克不及動了），轉到mysql\bin目次。
10.5、輸出mysql回車，假如勝利，將湧現MySQL提醒符 >。
10.6、銜接權限數據庫： use mysql; 。
10.7、改暗碼：update user set password=password("123") where user="root";（別忘了最初加分號） 。
10.8、刷新權限（必需步調）：flush privileges; 。
10.9、 加入 quit。
10.10、刊出體系，再進入，應用用戶名root和適才設置的新暗碼123登錄。
11、修正root用戶暗碼
5.7版本之前：
update user set authentication_string =password( 'root') where user = 'root;
5.7版本今後：
update user set password=password( 'root') where user = 'root;
以上所述是小編給年夜家引見的mysql 5.7.14 免裝置版留意事項(精)，願望對年夜家有所贊助，假如年夜家有任何疑問請給我留言，小編會實時答復年夜家的。在此也異常感激年夜家對網站的支撐！
