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

Mysql,zip format

1. The home directory of Mysql had better not have "-." And so on.

2. Mysql configure environment variables

The Path environment variable is followed by the mysql extraction path: eg:E:\ mysql-5.7.17-winx64\ bin (preferably set to D:\ mysql\ bin, that is, create a new folder mysql on disk D and put the extracted files in this folder).

3. The Mysql configuration file my-default.ini is renamed to my.ini and added as follows: (some files have previous comments on these two lines, leave them out)

Basedir = E:\ mysql

Datadir = E:\ mysql\ data

Note: there is no data folder after zip is decompressed. You need to create a new data folder first.

4. After mysql version 5.6, the database startup command of the decompressed version:

Mysqld-remove

Mysqld-initialize or mysqld-initialize-insecure-user=mysql

Mysqld-install

Net start mysql

Note: if it is not successful, consider changing the path.

5. Modify the initial password:

Mysql-u root-p

Enter the initial password:

Set password for root@localhost=password ('root')

The modification was successful.

6. Build the database statement:

CREATE DATABASE IF NOT EXISTS mdnov-web DEFAULT CHARSET utf8 COLLATE utf8_general_ci

7. Modify the character encoding problem to utf8:

Screenshot of My.ini configuration file

8. Set password=password ('new password') sets a new password

9. Update user set host='%' where user='root' updates the root command to allow any other ip to log in.

10. Navicat loads .sql file.

Create a new database in the connection: right-> create a database-> enter the database name, select utf-8 for the character set, and select utf8_general_ci for the sort set.

Right-click-> run the sql file in the database, select the .sql file, refresh it after confirmation, and the .sql file can be loaded into navicat.

11. Navicat double-click user: 1045-access denied for user 'root'@'localhost' (using password:yes)

Right-click the user localhost_3306---- to select connection properties-enter the root password:

Login name of Mysql: root, password: root.

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.