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

MySQL query duplicate data

Suppose there is a user table, user. The data is as follows: 1. Duplicate uid data in query table SELECT id, uid, name FROM USER WHERE uid IN (SELECT uid FROM USER GROUP BY uid HAVING COUNT(uid) > 1); 2. Duplicate data in the query table, excluding the minimum id SELECT id, uid, name FROM user WHERE uid IN (SELECT ...

Posted on Sat, 16 May 2020 11:25:22 -0400 by dyconsulting

Implementation of lamp architecture and unified log management

1. Deploy the separated LAMP to two servers, and php loads the xcache module 1) Install httpd, PHP, PHP MySQL on c2 server [root@c2 ~]# yum install httpd php php-mysql -y 2) Installing the database mariadb server on the mariadb server [root@mariadb ~]# yum install mariadb-server -y 3) Start service [root@c2 ~]# systemctl start httpd [root@mari ...

Posted on Sat, 16 May 2020 03:29:12 -0400 by BuzzStPoint

MySQL date plus minus

1. addtime() is the date plus the specified number of seconds select addtime(now(),1); -- Plus 1 second 2. adddate() can be used in two ways. The second parameter is to add the specified number of days to the date, and the second parameter is to add the specified interval time to the date select adddate(now(),1); -- Plus 1 day select adddate ...

Posted on Fri, 15 May 2020 10:26:49 -0400 by jwrightnisha

View linux Log in web interface

rsyslog+mariadb+loganalyzer An architecture that can use web pages to view logs Environment preparation: just like the centralized log server architecture mentioned in the previous course, this architecture is built on the server, that is, the host with IP address of 192.168.1.55 Environment preparation and setting of server side Packages requ ...

Posted on Thu, 14 May 2020 10:39:32 -0400 by lunny

The difference between [MySQL] char and varchar

CHAR and VARCHAR types are similar, but they are saved and retrieved in different ways. Their maximum length and whether trailing spaces are preserved are also different. There is no case conversion during storage or retrieval. Char 0-255 byte fixed length string VARCHAR 0-65535 byte variable length string Create test table mysql> c ...

Posted on Tue, 12 May 2020 11:29:46 -0400 by cyberdwarf

Mysql dual host hot standby and implementation of Mysql dual host and high availability with preserved

There are two ways of mysql hot standby: Hot standby of master-slave serverMaster master server hot standby The following is an example of dual hot standby of the primary and primary servers. The primary and secondary configurations are similar. Two centos7, ip respectively: 172.17.1.136 172.17.3.134   1, mysql creating database This st ...

Posted on Mon, 11 May 2020 05:17:19 -0400 by alex clone

tpcc instructions

Note: the content of the article originated from the network and was obtained through our own experiment; however, the reference article address was not recorded at that time. If you find any infringement problem, please leave a message. 1, Introduction Stress test means that before MySQL goes online, a large number of stress tests need to be ...

Posted on Mon, 11 May 2020 03:26:33 -0400 by Balu

[JSP+Spring] use Servlet to develop user login function = > spring

Using Servlet to develop user login function = > spring Before transformation Table of contents user.java package com.bean; public class user { private Integer u_id; private String u_username; private String u_password; public user(String u_username, String u_password) { this.u_username = u_username; this.u_password = u_passwo ...

Posted on Mon, 11 May 2020 03:07:37 -0400 by sushant_d84

Deploy private cloud CloudStack

catalog preface 1. Cluster planning 2. Set yum source 3. Turn off the firewall and selinux 4. Install nfs 4.1.192.168.0.232 4.2.192.168.0.233 5. Install and start MySQL server 6. Install and start cloudstack management 7. Browser access preface The infrastructure cloud formed by CloudStack and Data center Operators can quickly and easil ...

Posted on Sun, 10 May 2020 23:56:54 -0400 by johnpaine