Shulou(Shulou.com)06/01 Report--

The following content mainly brings you a brief analysis of the installation of mysql 5.7.22 Enterprise Edition. The knowledge mentioned here, which is slightly different from books, is summed up by professional and technical personnel in the process of contact with users, and has a certain value of experience sharing. I hope to bring help to the majority of readers.

1. Environment description operating system: windows 2012 database: mysql 5.7.12 Enterprise Edition II, operation step 1, the planning MySQL installation file is stored in D:\ mysql, the data directory is E:mysqldata2, and the configuration file location is d:\ mysql\ my.ini. The contents are as follows: [mysqld] port = 3306 basedir= D:\ mysqldatadir= E:\ mysqldatamax_connections=500 character-set-server=utf8 default-storage-engine=INNODB sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [mysql]

Default-character-set=utf8

3. Install the service C:\ Users\ admin > DVR D:\ > cd mysql\ binD:\ mysql\ bin >.\ mysqld-install 4, initialize mysql.\ mysqld-- initialize-insecure-- user=mysql5, start the service D:\ mysql\ bin > net start mysqlMySQL service is starting. MySQL service has been started successfully. 6. Log in to database D:\ mysql\ bin > mysql-uroot-pEnter password:Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 2Server version: 5.7.22 MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.mysql > 7, change password use mysql;update mysql.user set authentication_string=password ('qwe12345') where user='root' and Host =' localhost';flush privileges;8, shutdown service D:\ mysql\ bin > net stop mysqlMySQL service is stopping.

The MySQL service stopped successfully.

For the above brief analysis of the installation of mysql 5.7.22 Enterprise Edition, if you have more information, you can continue to pay attention to the innovation of our industry. If you need professional answers, you can contact the pre-sale and after-sale ones on the official website. I hope this article can bring you some knowledge updates.

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.