MySQL 5.7.11 winx64 installation and configuration method graphic tutorial, mysql5.7.11winx64

MySQL 5.7.11 winx64 installation and configuration method graphic tutorial, mysql5.7.11winx64

Install and configure the MySql database system on the 64-bit Windows 7 operating system.

I. How to install and configure mysql5.7.11 winx64

Steps:

1. Download MySQL database and driver (Windows) from the official website ):Mysql-5.7.11-winx64.zip

2. Create a database configuration file:My. ini

Example:

1. decompress the compressed package to: D: \ Program Files

2. Create D: \ Program Files \ mysql-5.7.11-winx64 \ my. ini configuration file

3. initialize and start the Mysql service:

1. Run cmd as Administrator

2. Go to the mysql bin

3. initialize and generate the data folder

> Mysqld -- initialize-insecure (the root password is not set. We recommend that you use it)

> Mysqld -- initialize (generate a random root password)

3. Install the MySql Service

> Mysqld-install

4. Start mysql

> Net start mysql

4. log on to mysql

> Mysql-u root-p

No Password required for the First LoginDirectly press enter to log on

After logging on to mysql, set the root password

> Set password for root @ localhost = password ('yourpassword ');

Or use mysqlamdin to change the root password.

> Mysqladmin-u root-p password NewPassword

2. Simple database operations and Testing

1. Run cmd as an administrator, enter the directory where the program is located, and start the Mysql service.

2. Database Operations

Show databases; // create database dbName for All database lists; // create database use dbName; // select database show tables; // display the table list

3. View entries in the data table

desc tableName;describe tableName;show columns from tableName;show create table tableName;

4. Clear all entries in the data table:

Truncate table name; // clear all data, no logs, unrecoverable, extremely fast
Delete from table name; // clear all data, write logs, data can be restored, and the speed is slow

The above is how to install and configure mysql 5.7.11winx64. I hope it will be helpful for your learning.