mysql-proxy proxies the same intranet database

Elementary analysis: Specific deployment: mysql server: # Authorize remote login account   [root@localhost ~]# mysql -uroot  -p mysql> GRANT ALL ON *.* to 'test'@'192.168.0.1' IDENTIFIED BY 'lmdb(A7105#B9606@com!'; mysql> flush privileges;  mysql> select user,host from mysql.user; +---------------+----------------+ | user          |  ...

Posted on Tue, 01 Oct 2019 05:04:14 -0700 by SparkleD

vsftp virtual user based on mysql, the use of iptables

vsftp creates virtual users based on mysql 1. First install the environment yum groupinstall -y "Development Tools" "Server PlatformDevelopment" yum install -y pam-devel mariadb-devel mariadb-server vsftpd lftp ftp //Download the latest pam-mysql http://pam-mysql.sourceforge.net/ //Compile and install pam-mysql tar xf pam_mysql-0.7RC1.tar.gz ...

Posted on Sun, 15 Sep 2019 21:22:02 -0700 by nou

vncserver add user

Original Link: https://my.oschina.net/u/1590001/blog/268242 1. Set up login user information in vncserver   #vi /etc/sysconfig/vncservers   VN ...

Posted on Sat, 14 Sep 2019 19:52:41 -0700 by stephenlk

Use ulog to monitor port logs (by quqi99)

Author: Zhang Hua, published in: 2019-08-14 Copyright Statement: It can be reproduced arbitrarily. When reproducing, please indicate the original source of the article, the author's information and the Copyright Statement in the form of hyperlinks.( ...

Posted on Wed, 14 Aug 2019 00:17:59 -0700 by eves

Linux Remote Desktop

Torture yourself Mark in the machine room after a long time.(test environment rhel5.5) Independent Service Configuration for vnc      Step 1: (1) Check to see if the vnc service is installed on the system (also in System-Administrator-Service, check and check Start-Up) # rpm -qa | grep vnc (If there is a return value, similar to the value o ...

Posted on Tue, 25 Jun 2019 09:48:52 -0700 by ihw13

05.04 Rsync Service Exception Error Summary

Chapter 1 iptables firewall opened by rsync server 1. [Client error] No route to host 2. [Error Demonstration Process] [root@nfs01 tmp]# rsync -avz /etc/hosts rsync_backup@172.16.1.41::backup rsync: failed to connect to 172.16.1.41: No route to host (113) rsync error: error in socket IO (code 10) at clientserver.c(124) [sender=3.0.6] 3. ...

Posted on Thu, 13 Jun 2019 17:13:20 -0700 by Petty_Crim

iptables firewall rules cause port impassability case analysis

iptables firewall rules cause port impassability case analysis Problem phenomena: Port 8080 of one server is not accessible, but other ports are normal, such as port 22 of ssh and ping. Testing port 8080 for telnet connection from other machines shows the result below. [root@iZ25a9b7bpcZ ~]# telnet xx.xx.xx.xx 8080 Trying xx.xx.xx.xx... tel ...

Posted on Mon, 03 Jun 2019 20:31:06 -0700 by mikesab

Routing and Policy Routing in linux

Route Gateway: Exit to other segments Dynamic routing: Routers automatically create routing tables, when the network structure changes, routers will have more network conditions to automatically modify the routing table. Static routing: Manual routing table. Manual modification of routing table is required when network card architecture chan ...

Posted on Sun, 19 May 2019 03:45:39 -0700 by franck

Configure YUM Server

1. Pre-preparation Prepare two Linux servers, one for CentOS 6.9 and one for CentOS 7.4. The other will access the two services 2. Turn on CentOS7 Auto-mount Disc Service Install autofs package yum -y install autofs Turn on automount systemctl start autofs Turn on Automount by default systemctl enable autofs 3. Close the fire ...

Posted on Sat, 27 Apr 2019 23:00:38 -0700 by tzicha

kubeadm installation kubernetes environment initialization

Server environment 192.168.1.252 k8s-node02 192.168.1.73 k8s-node01 192.168.1.101 k8s-master Environment settings a) Setting time synchronization b) DNS parsing of local hosts files c) Turn off iptables or firewwalld and make sure it does not start automatically d) Turn off selinux and disable swap devices e) If the proxy model of ipvs is ...

Posted on Fri, 26 Apr 2019 09:03:35 -0700 by stenk