Running multiple mysql instances on one machine

Installation instructions: A mysql program file, a configuration file, running multiple mysql instances (each with its own distinct data directory).For the convenience of the test, only two examples are used in this experiment. MySQL program installation directory: /usr/local/mysql_5.6.38 Data directories for MySQL i ...

Posted on Thu, 16 Jul 2020 12:06:56 -0400 by twigletmac

Running multiple mysql instances on one machine

Installation instructions: A mysql program file, a configuration file, running multiple mysql instances (each with its own distinct data directory).For the convenience of the test, only two examples are used in this experiment. MySQL program installation directory: /usr/local/mysql_5.6.38 Data directories for MySQL i ...

Posted on Thu, 16 Jul 2020 12:08:11 -0400 by battlesiege

Running multiple mysql instances on one machine

Installation instructions: A mysql program file, a configuration file, running multiple mysql instances (each with its own distinct data directory).For the convenience of the test, only two examples are used in this experiment. MySQL program installation directory: /usr/local/mysql_5.6.38 Data directories for MySQL i ...

Posted on Thu, 16 Jul 2020 12:08:54 -0400 by ashutosh.titan

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