Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to install mysql5.7.16 under win7, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

1: download the installation package, extract it, and add the bin path of mysql to the global system variable path.

2: edit the my.ini file. (omitted here, there are many my.ini files on the Internet)

# configuration file starts # # 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] port=3306 basedir = "D:\ mysql-5.7.16-winx64/" datadir = "D:\ mysql-5.7.16-winx64/data/" tmpdir = "D:\ mysql-5.7.16-winx64/data/" socket = "D:\ mysql-5.7.16-winx64/data/mysql.sock" log-error= "D:\ mysql-5.7.16-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-5.7.16-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 End of NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION "# sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES # configuration file # 3: administrator cmd, execute mysqld install MySQL-- defaults-file=" D:\ mysql-5.7.16-winx64\ my.ini "--your own my.ini path

4: start the mysql command on the command line: net start mysql

If startup fails, re-execute the following command:

1: administrator cmd, type mysqld-- initialize to wait for a period of time (during which you are creating the data folder), and then type net start mysql again.

Add:

Log in to mysql after installation and find that there is no root password.

So net stop mysql

Edit my.ini and add a line: skip-grant-tables.

Restart net start mysql and log in to mysql-u root-p without a password.

Then change the root password of mysql

> use mysql

> update mysql.user set authentication_string=password ('123qwe') where user='root' and Host =' localhost';-there is no password field in version 5.7, and many materials are not applicable.

> flush privileges

> quit

Stop mysql service: net stop mysql

Log out the skip-grant-tables in the my.ini file.

Start mysql: net start mysql

Log in to mysql mysql-u root-p

At this point, you also need to execute the alter command.

> alter user 'root'@'localhost' identified by' 123'

Thank you for reading this article carefully. I hope the article "how to install mysql5.7.16 under win7" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.