MySQL-5.7 permission details

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

User and Rights Management for MySQL

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

Zabbix monitoring MySQL under Windows

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

Comprehensive solutions to problems such as mysql 1045 1044

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. First $ 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

MySQL O & M-3, writing and using of multi instance control script

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

Mysql multi instance installation and configuration

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

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

mysql-5.7.20-winx64.zip installation tutorial 1. Download and unzip 2. Environmental variables 3.my.ini configuration 4.cmd operation 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 2 ...

Posted on Sun, 26 Jan 2020 14:01:13 -0500 by galmar

Mysql installation tutorial under linux, available for personal test

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

MySQL 5.7 binary simple installation

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: client mysqladmin mysqlbinlog mysqld:mysql binary 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