MYSQL «

2012 SERVER (64)
2016 windows (9)
AIX (13)
Amazon (40)
Ansibile (19)
Apache (135)
Asterisk (2)
cassandra (2)
Centos (230)
- ftp (5)
- IPTABLES (15)
- SFTP (1)
- swap (3)
Centos RHEL 7 (270)
centos8 (3)
chef (3)
cloud (2)
cluster (3)
Coherence (1)
DB2 (5)
DISK (25)
DNS (9)
Docker (31)
Eassy (11)
ELKS (1)
EXCHANGE (3)
Fedora (6)
GIT (3)
GOD (2)
Grub (1)
Hacking (10)
Hadoop (6)
health (2)
horoscope (23)
Hyper-V (10)
IIS (15)
JAVA (7)
JBOSS (32)
jenkins (1)
Kubernetes (9)
Ldap (5)
Linux (189)
Linux Commands (166)
Load balancer (5)
mariadb (14)
Mongodb (4)
MQ Server (24)
MYSQL (84)
Nagios (5)
NaturalOil (13)
Nginx (36)
Ngix (1)
openldap (1)
Openstack (6)
Oracle (35)
Perl (3)
Postfix (19)
Postgresql (1)
PowerShell (2)
Python (3)
qmail (36)
Redis (12)
RHCE (28)
SCALEIO (1)
Security on Centos (29)
Shell (64)
Solaris (58)
Sql Server 2012 (4)
squid (3)
SSH (10)
SSL (14)
Storage (1)
TIPS on Linux (28)
tomcat (62)
Ubuntu (1)
Uncategorized (30)
Veritas (2)
vfabric (1)
VMware (28)
Weblogic (38)
Websphere (71)
Windows (19)
Windows Software (2)
wordpress (1)
ZIMBRA (17)

db

[root@clusterserver2 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.1.20 clusterserver1.rmohan.com clusterserver1 192.168.1.21 clusterserver2.rmohan.com clusterserver2 [root@clusterserver2 ~]#

wget https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

[root@clusterserver2 software]# rpm -ivh mysql57-community-release-el7-8.noarch.rpm warning: mysql57-community-release-el7-8.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing… ################################# [100%] Updating / installing… 1:mysql57-community-release-el7-8 ################################# [100%]

wo*fk9,yVb!y

EIJQW-y6:hhe

set password for root@localhost=password(‘Test@123’);

Master1 […]

Your password does not satisfy the current policy requirements

wget https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

After the installation of this package. We will get two new yum repo related to MySQL

[root@localhost ~]# ls -1 /etc/yum.repos.d/mysql-community* /etc/yum.repos.d/mysql-community.repo /etc/yum.repos.d/mysql-community-source.repo [root@localhost ~]# Installing MySQL Server

By […]

CentOS 7 used rpm install MySQL 5.7

$ wget http://repo.mysql.com/mysql57-community-release-el7-7.noarch.rpm

$ rpm -ivh mysql57-community-release-el7-7.noarch.rpm

[root@cluster1 ~]# rpm -ivh mysql57-community-release-el7-7.noarch.rpm warning: mysql57-community-release-el7-7.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing… ########################################### [100%] 1:mysql57-community-relea########################################### [100%]

$ yum install mysql-server

So far, mysql57 has been successfully installed. Now try to log on to use the root mysql, an error ERROR 1045 (28000): Access denied […]

Mysql gallera

[…]

Yum to configure multiple master cluster MariaDB Galera

Yum to configure multiple master cluster MariaDB Galera Hereinafter, if the command is not preceded by PS1 is to represent the three nodes are required to perform the same action, if it means the implementation of the action on the specified node

cluster1.rmohan.com Centos6.7 192.168.1.60 MariaDB cluster2.rmohan.com Centos6.7 192.168.1.62 MariaDB cluster3.rmohan.com Centos6.7 192.168.1.63 MariaDB

[…]

multi-master MariaDB Galera Cluster

CentOS 6.7 Linux compilation configure a multi-master MariaDB Galera Cluster for HA.

Multi-master MariaDB Galera Cluster

Summary Galera is essentially a wsrep provider (provider), relies on the wsrep API interface. Wsrep API defines a set of applications and replication callback call library to implement transaction database synchronization write set (writeset) replication, and similar applications. The […]

MySQL slow remote connection causes and solutions

Because the network is deployed MySQL server, there is no load, when the speed local connections […]

MySQL and PostgreSQL rosetta stone

This is a short table of useful and common MySQL & PostgreSQL commands put up against each other.

MySQL PostgreSQL Command line client mysql psql Connect to database use mysql; \connect postgresql; List databases show databases; \l List tables show tables; \dt Describe table describe table; \d table; Show server version select version(); select version(); […]

Change the default MySQL data directory with SELinux enabled

This is a short article that explains how you change the default MySQL data directory and adjust SELinux to account for the changes. The article assumes that you’re running either RHEL, CentOS, Scientific Linux or Fedora with SELinux enabled. This works with the most recent EL (6.2) version.

We’ll be doing this in the following […]

MySQL Terminal Commands

MySQL has a lot of visual management tools, such as “mysql-workbench” and “sequel-pro-“. Now I’m writing MySQL terminal command operation is to strengthen the understanding of yourself for MySQL, always be better than using a graphical thorough understanding, because I already prefer to write code. Meanwhile write these articles, you want to be a reference, […]

Recent Posts

Pages

Categories

Archives

Recent Comments