MySQL 5.7.11 winx64 Installation configuration method graphics and text tutorial _mysql

Install and configure the MySQL database system on the 64-bit WINDOWS7 operating system.

First, mysql5.7.11 winx64 installation configuration method

Steps:

1, website download MySQL database and driver (Windows):mysql-5.7.11-winx64.zip

2. Create DATABASE configuration file:My.ini

Example:

1. Extract 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 MySQL service:

1. Run cmd with administrator privileges

2. Go to MySQL Bin

3. Initialize, Generate Data folder

>mysqld--initialize-insecure (not set root password, recommended)

>mysqld--initialize (Generate a random root password)

3. Install MySQL Service

>mysqld-install

4. Start MySQL

>net start MySQL

4, login MySQL

>mysql-u root-p

Login without password at first logon

After you log in to MySQL, set the root password

>set password for root@localhost = password (' YourPassword ');

Or use Mysqlamdin to modify the root password

>mysqladmin-u root-p Password NewPassword

Second, simple database operations and testing

1, run cmd with admin rights, enter the directory of the program, start the MySQL service

2. Database operation

show databases; All database list CREATE DATABASE
dbname//Create databases use
dbname;//Select database
show tables;//Display datasheet list

3, view the entries in the datasheet

DESC TableName;
Describe TableName;
Show columns from TableName;
Show CREATE TABLE tablename;

4, empty the data table all the entries:

TRUNCATE TABLE name; //Clear all data, do not write log, not recoverable, very fast
Delete from table name; //Clear all data, write log, data recoverable, slow

Wonderful topic sharing: MySQL different versions of the installation Tutorials mysql5.7 version Installation Tutorials

This is the MySQL 5.7.11winx64 installation configuration method, I hope to help you learn.