Mysql download and installation step tutorial (detailed)

This article brings you a step-by-step tutorial (detailed) on downloading and installing MySQL. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to you.

1. Download and install

MySQL is a relational database management system developed by the Swedish MySQL AB company and currently belongs to an Oracle company. MySQL is the most popular relational database management system. In terms of WEB applications, MySQL is one of the best RDBMS (Relational Database Management System) application software.

If you want to use MySQL to store and operate data, you need to do a few things:
a. Install the MySQL server
b. Install the MySQL client
b. [Client] Connect to [Server]
c. [Client] sends commands to [Server MySQL]. The service accepts commands and performs corresponding operations (add, delete, modify, check, etc.)

Download: http://dev. mysql.com/downloads/mysql/

Installation

windows: dot point

Linux: yum install mysql-server

Mac: Click and click

1 Extract to any directory;

2 Run on the server

Windows service:

cmd E:\01-Software\ Test software\13 mysql\mysql-8.0.12-winx64\bin\mysqld –install

net start mysql Start service

cd /d E:\01-Software\Test software\13 mysql\mysql-8.0.12-winx64\bin

mysqld

Initialization naming:

mysqld --initialize-insecure Create root user without password

3 The client modifies the environment variable

Variable name: MYSQL_HOME

Variable value: D:\mysql-5.7.20-winx64

Add to path: %MYSQL_HOME%\ bin;

Computer—>Properties—>Advanced System Configuration

Start MySQL service

net start mysql

Close MySQL service

net stop mysql

linux

Installation: yum install mysql-server　

Service Client start

mysql.server start

Client connection

Connection: mysql -h host -u user -p

Common errors:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2), it means that the MySQL server daemon (Unix) or service (Windows) is not running.

Exit: QUIT or Control D

2. Database operation

1. Show databases

show databases;

mysql - User permissions related data
test - Used for user test data
information_schema - MySQL itself architecture related data

2. Create database

# utf-8
CREATE DATABASE 数据库名称 DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
# gbk
CREATE DATABASE 数据库名称 DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;

3. Using database

use db_name;

4, User management

View users

select host,user from mysql.user;

Create users

create user '用户名'@'IP地址' identified by '密码';

Delete users

drop user '用户名'@'IP地址';

Modify users

rename user '用户名'@'IP地址'; to '新用户名'@'IP地址';

Change password

set password for '用户名'@'IP地址' = Password('新密码')

PS: User permission-related data is stored in the user table of the mysql database, so you can also directly operate it (not recommended)

5. Authorization Management

show grants for 'user'@'IP address'                                                                                                                                                                                                        . ##revoke permissions on database.table from 'user'@'IP address' -- revoke permissions

ALL PRIVILEGES Except Grant's ownership
Select only check permissions
select, Insert check and insert permissions
...
USAGE without access
Alter use Alter Table
# #Alter Routine uses the Create PROTE PROCEDure ## Create Table Tables# ATE User uses Create User, Drop User, Rename User, and Revoke All Privileges
Create View uses the Create View
DELETE to use Drop Table
EXECUTE
FILE to use SELECT Into Outfile and Load Data Infile
#. #Grant option grant and revoke
                                                          use index
                                                                                                                                                                                                             ​                    Use show full processlist
                                Use select 
               Use show databases
          show view Use show view
                            Use update
                                          use update
                  using flush
          use ‐ mysqladmin shutdown’s
                                                   

The above is the detailed content of Mysql download and installation step tutorial (detailed). For more information, please follow other related articles on the PHP Chinese website!