Mysql5.7.18 unzip the version to start the mysql service, mysql5.7.18mysql

Mysql5.7.18 unzip the version to start the mysql service, mysql5.7.18mysql

Mysql5.7.18 unzip the version to start the mysql service. The specific content is as follows:

1. Download mysql Community Edition

2. decompress the package to D: \ Program Files.

3. In D: \ Program Files \ mysql-5.7.18-winx64 \ bin, create the file my. ini with the following content:

 [client] port=3306 default-character-set=utf8  [mysqld] bind-address = 127.0.0.1 port=3306 character_set_server=utf8 basedir ="D:\Program Files\mysql-5.7.18-winx64" datadir ="D:\Program Files\mysql-5.7.18-winx64\data" tmpdir ="D:\Program Files\mysql-5.7.18-winx64\data" socket ="D:\Program Files\mysql-5.7.18-winx64\data\mysql.sock" log-error="D:\Program Files\mysql-5.7.18-winx64\data\mysql_error.log" 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.18-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"

4. Configure C: \ WINDOWS \ system32 \ drivers \ etc \ hosts, Which is commented out by default. Remove the comment:

127.0.0.1  localhost

5. Create a data folder under the D: \ Program Files \ mysql-5.7.18-winx64 Directory, which must be empty.

6. Open cmd, cd to D: \ Program Files \ mysql-5.7.18-winx64 \ bin, execute the following command

mysqld --initialize-insecuremysqld -install

7. Start the mysql service, if it is not started.Net start mysql.

8. In cmd, use the commandMysql-u root-p,Press enter to enter mysql> command prompt.

9. Modify the root password

mysql> set password=password('123456');

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.