September 2016
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  

Categories

September 2016
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  

MYSQL mariadb CENTOS 7

MYSQL CENTOS 7

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!

[…]

September 18th, 2016 | Category: Centos RHEL 7, mariadb | Leave a comment

XFS CENTOS 7

Last login: Mon Sep 5 22:48:00 2016 from 192.168.1.1 clusterserver1 without LVM Create an “clusterserver1” file system We have “/dev/sdb” as a free hard drive :

[root@clusterserver1 ~]# lsblk -f NAME FSTYPE LABEL UUID MOUNTPOINT fd0 sda ??sda1 clusterserver1 aba69d25-b3de-4d89-ba25-e50a8dcf10eb /boot ??sda2 LVM2_member EE31dY-Ubnm-LwCA-8J9J-vK9B-XNzz-OZSt75 ??centos-swap swap 2e1fb731-0f59-4d10-9f2f-e302a671de57 [SWAP] ??centos-root clusterserver1 8e1d8c59-5cd0-4716-92dd-de7c1417dc74 / sdb sr0 iso9660 […]

September 18th, 2016 | Category: Centos, Centos RHEL 7 | Leave a comment

CentOS7 under yum successfully installed MySQL 5.7

1. Download the YUM library

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

2. Install YUM library

shell> yum localinstall -y mysql57-community-release-el7-7.noarch.rpm

3. Install Database

shell> yum install -y mysql-community-server

4. Start MySQL service

shell> systemctl start mysqld.service

5. The default blank password

shell> mysql -uroot -p

6. Reset the root password to restart the mysql service

shell> update mysql.user […]

September 18th, 2016 | Category: Centos RHEL 7 | Leave a comment

MySQL change the default blank password to open Remote Access

mysql -u root -p

use mysql

update user set password=PASSWORD(‘abcde’) where user = ‘root’;

mysql update user set password=PASSWORD(‘123456′) where user=’root’

mysqld -install

 

 

mysql> show variables like ‘char%’; mysql>set character_set_client=gbk; mysql>set character_set_results=gbk;

September 18th, 2016 | Category: MYSQL | Leave a comment