MySQL-5.7 permission details
1.MySQL permission level
(1) Global management rights Affects the entire MySQL instance level
*.*Permissions on behalf of all databases
mysql> grant all on *.* to 'test'@'%';
Query OK, 0 rows affected (0.00 sec)
mysql> grant select, insert on *.* to 'test'@'%';
Query OK, 0 rows ...
Posted on Fri, 22 May 2020 00:05:52 -0400 by PHPTOM
In MySQL 5.7.24, information about users and user permissions is stored in the user table of mysql library, which can be roughly divided into user column, permission column, security column and resource control column.
1. User ColumnsThe user column of the user table includes Host, User, and password, representing the host name, user name, and ...
Posted on Sat, 16 May 2020 15:40:18 -0400 by sspoke
1. Create monitoring account in MySQL
GRANT PROCESS,REPLICATION CLIENT ON *.* TO mysql_monitor@'localhost' IDENTIFIED BY 'Nt8eWv';
# process with this permission, users can executeSHOW PROCESSLIST and KILL Command.
# The replication client has this permission to query the status of master server and slave server.
2. Create three new scr ...
Posted on Tue, 05 May 2020 02:43:11 -0400 by b0gner17
If you find that you can't log in to MySQL one day and you can't remember your password, you can only change the password in mysql.user locally.
$ sudo service mysqld stop //Confirm that mysqld and installation free mysqld are both closed
$ sudo mysqld_safe --skip-grant-table & //Enter local security mode
After arriving here, mysq ...
Posted on Sat, 02 May 2020 08:44:15 -0400 by chick3n
Experimental environmentAfter MySQL operation and maintenance-2, multi instance deployment, the environment used in this article is also the experimental environment after the successful deployment of the previous experiment.
Usage method1. Write a script named mysqld with execution permission2. Copy mysqld to the directory of different instan ...
Posted on Sat, 04 Apr 2020 13:02:04 -0400 by elpaisa
What is multi instance
In short, multiple instances of MySQL are to open multiple different server ports on one server at the same time and run multiple MySQL service processes at the same time. These service processes provide services by listening to different service ports on different socket s.
Two different mult ...
Posted on Tue, 31 Mar 2020 23:32:53 -0400 by FrankA
Use mysqladmin ext to understand the running status of MySQL
Absrtact: 1. Using the - r/-i parameter and mysqladmin extended status command, you can get all MySQL performance indicators, that is, show global status output. However, because most of these indicators are cumulative values, if you want to know the current status, y ...
Posted on Sun, 29 Mar 2020 13:09:34 -0400 by darknessmdk
mysql-5.7.20-winx64.zip installation tutorial
1. Download and unzip
2. Environmental variables
1. Download and unzip
Download mysql-5.7.20-winx64.zip and unzip it. Link: https://dev.mysql.com/downloads/mysql/
Extract this article to D:\Program Files\mysql-5.7.20-winx64
Posted on Sun, 26 Jan 2020 14:01:13 -0500 by galmar
0. Uninstall the old version of MySQL. If MySQL has been installed before, find and delete MySQL related files!!!
find / -name mysql
rm -rf Path found above, multiple paths separated by spaces
#Or a command below
find / -name mysql|xargs rm -rf
1. Create a new / jiazhe folder in the / opt folder, and download the linux version ...
Posted on Mon, 23 Dec 2019 16:31:15 -0500 by jacko_162
System: CentOS 7.2
MySQL installation package: mysql-5.7.18-linux-glibc2.12-x86_.tar.gz
tar -zxvf mysql-5.7.18-linux-glibc2.12-x86_64.tar.gz
Main tools in bin directory
mysql_safe: start stop mysql
mysqldump: export tool
1. First specify the installation directory a ...
Posted on Sat, 21 Dec 2019 15:23:56 -0500 by maryp