May 2018
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
28293031  

Categories

WordPress Quotes

Cherish your visions and your dreams as they are the children of your soul, the blueprints of your ultimate achievements.
Napoleon Hill

Recent Comments

May 2018
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
28293031  

Short Cuts

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

WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.

Who's Online

11 visitors online now
1 guests, 10 bots, 0 members

Hit Counter provided by dental implants orange county

MYSQL 5.8 on Centos 7

systemd is now used to look after mySQL instead of mysqld_safe (which is why you get the -bash: mysqld_safe: command not found error – it’s not installed) The user table structure has changed.

So to reset the root password, you still start mySQL with –skip-grant-tables options and update the user table, but how you do it has changed.

1. Stop mysql: systemctl stop mysqld 2. […]

MYSQL BINARY INSTALL CENTOS7

Environment: Virtual Machine + CentOS 7

1. download binary package, the following mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz link is the official website

cd /usr/local/src

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz 2. extract, rename

[root@beta src]# tar zxvf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz

[root@beta src]# ls index.html?id=471614 mysql-5.7.19-linux-glibc2.12-x86_64 mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz [root@beta src]# mv mysql-5.7.19-linux-glibc2.12-x86_64 /usr/local/mysql 3. Initialize

[root@beta mysql]# useradd -M -s /sbin/nologin mysql

[root@beta mysql]# ls bin COPYING […]

MySQL backup command mysqldump parameters and examples

MySQL backup command mysqldump parameters and examples

1. Grammar options -h, –host=name CPU name

-P[ port_num], –port=port_num The TCP / IP port number used to connect to the MySQL server

–master-data This option adds the location and filename of the binlog to the output. If it is equal to 1, it will be printed as […]

Master and slave MySQL versions are MySQL5.6.31

Master and slave MySQL versions are MySQL5.6.31

Primary server IP: 192.168.1.178

From the server IP: 192.168.1.145

Master and slave are able to ping each other.

A?192.168.1.178?Master? B?192.168.1.145?Slave?

 

service mysqld stop service mysqld start service mysqld restart

 

mysql> grant replication slave on *.* to ‘mohan’@’192.168.1.145’ identified by ‘123456’; mysql> flush privileges;

vi /etc/my.cnf

port=3306

[…]

MySQL 5.8 starts and then instantly stops

MySQL 5.8 starts and then instantly stops Everything worked perfectly except one of the final steps, launching mysql:

mysqld –skip-grant-tables –user=mysql Was giving me the following message and then shutting down:

[ERROR] Can’t find messagefile ‘/usr/share/errmsg.sys’ After some googling I found the solution to be adding the following flag:

–lc-messages-dir=”/usr/local/mysql/share/english/” To launch it and have […]

Mysql

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm rpm -ivh mysql-community-release-el7-5.noarch.rpm yum update yum install mysql-server

systemctl start mysqld

[root@clusterserver1 ~]# systemctl start mysqld [root@clusterserver1 ~]# systemctl enable mysqld [root@clusterserver1 ~]# systemctl status mysqld

[root@clusterserver1 ~]# mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!

In order to […]

Replication Features in MySQL 8.0.1

MySQL 8.0.1 has just been released with a wonderful set of features across the board. Specifically in replication, there is plenty of new and exciting functionality as well as performance improvements.  In this post I am going to summarize the replication features of this development milestone release.

The Group Replication plugin. You can now use Group Replication together […]

MySQL 5.7 vs MySQL 8.0 – What’s new in MySQL 8.0?

MySQL is arguably the most popular and common RDBMS. The last major release was MySQL 5.7 back in 2013.

As of today, several development milestones were declared for MySQL v8.0, but there is no official release available yet.

Tip: Do not click here if all your SQL queries are fast as lightning!

Even though there is no official software […]

mysqlcheck

[root@clusterserver1 software]# mysqlcheck mysql -uroot -p Enter password: mysql.columns_priv error : Table upgrade required. Please do “REPAIR TABLE `columns_priv`” or dump/reload to fix it! mysql.db OK mysql.event error : Table upgrade required. Please do “REPAIR TABLE `event`” or dump/reload to fix it! mysql.func OK mysql.general_log error : Table upgrade required. Please do “REPAIR TABLE `general_log`” […]

CENTOS 7 MySQL 5.7

CENTOS 7 MySQL 5.7

 

wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm

yum install -y mysql-community-server

 

systemctl start mysqld.service

[root@clusterserver1 software]# systemctl start mysqld.service [root@clusterserver1 software]# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.7.19 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, […]

Page 1 of 812345...Last »