Categories

Mysql Secure Installation for non default socket.

Mysql Secure Installation for non default socket. SECURING MYSQL SERVER –

mysql_secure_installation is a script useful to

set root password disallowing root login remotely removing anonymous user accounts after first installation removing test database which can be accessed by any users

Above script would work for default socket location i.e /var/lib/mysql/mysql.sock

If the server is started […]

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!

[…]

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     […]

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 […]

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;

HaProxy high availability cluster configuration Redis notes

HaProxy high availability cluster configuration Redis notes

Goal is to make a high-availability cluster for redis sensu use. redis cluster using Sentinel + Redis three-node configuration. Blog post before configuring details

Sentinel can be done when the master hang up automatically elect a new master, then it is not a proxy. Therefore, we need a […]

How to configure Storage Tiers with Windows Server 2012 R2

Storage Spaces: How to configure Storage Tiers with Windows Server 2012 R2 | Ask Premier Field Engineering (PFE) Platforms window._wpemojiSettings = {“baseUrl”:”https:\/\/s.w.org\/images\/core\/emoji\/72×72\/”,”ext”:”.png”,”source”:{“concatemoji”:”https:\/\/blogs.technet.microsoft.com\/askpfeplat\/wp-includes\/js\/wp-emoji-release.min.js?ver=4.5.3″}}; !function(a,b,c){function d(a){var c,d,e,f=b.createElement(“canvas”),g=f.getContext&&f.getContext(“2d”),h=String.fromCharCode;if(!g||!g.fillText)return!1;switch(g.textBaseline=”top”,g.font=”600 32px Arial”,a){case”flag”:return g.fillText(h(55356,56806,55356,56826),0,0),f.toDataURL().length>3e3;case”diversity”:return g.fillText(h(55356,57221),0,0),c=g.getImageData(16,16,1,1).data,d=c[0]+”,”+c[1]+”,”+c[2]+”,”+c[3],g.fillText(h(55356,57221,55356,57343),0,0),c=g.getImageData(16,16,1,1).data,e=c[0]+”,”+c[1]+”,”+c[2]+”,”+c[3],d!==e;case”simple”:return g.fillText(h(55357,56835),0,0),0!==g.getImageData(16,16,1,1).data[0];case”unicode8″:return g.fillText(h(55356,57135),0,0),0!==g.getImageData(16,16,1,1).data[0]}return!1}function e(a){var c=b.createElement(“script”);c.src=a,c.type=”text/javascript”,b.getElementsByTagName(“head”)[0].appendChild(c)}var f,g,h,i;for(i=Array(“simple”,”flag”,”unicode8″,”diversity”),c.supports={everything:!0,everythingExceptFlag:!0},h=0;h

.recentcomments a{display:inline !important;padding:0 !important;margin:0 !important;} .at-icon{fill:#fff;border:0}.at-icon-wrapper{display:inline-block;overflow:hidden}a .at-icon-wrapper{cursor:pointer}.at-rounded,.at-rounded-element .at-icon-wrapper{border-radius:12%}.at-circular,.at-circular-element .at-icon-wrapper{border-radius:50%}.addthis_32x32_style .at-icon{width:2pc;height:2pc}.addthis_24x24_style .at-icon{width:24px;height:24px}.addthis_20x20_style .at-icon{width:20px;height:20px}.addthis_16x16_style .at-icon{width:1pc;height:1pc}#at16lb{display:none;position:absolute;top:0;left:0;width:100%;height:100%;z-index:1001;background-color:#000;opacity:.001}#at16pc,#at16pi,#at16pib,#at_complete,#at_error,#at_share,#at_success{position:static!important}.at15dn{display:none}.at15a{border:0;height:0;margin:0;padding:0;width:230px}#at15s,#at16nms,#at16p,#at16p form input,#at16p label,#at16p textarea,#at16recap,#at16sas,#at_msg,#at_share .at_item{font-family:arial,helvetica,tahoma,verdana,sans-serif!important;font-size:9pt!important;outline-style:none;outline-width:0;line-height:1em}* html […]

PVLAN Isolation

 PVLAN Isolation

Introduction

In VMM 2012 SP1 you can isolate VM Networks using either traditional VLAN/PVLANS or, if you are using Windows Server 2012 as your host operating system, you can choose to implement Network Virtualization. The latter option addressing the scale limitations associated with a traditional VLANs solution as well […]

Requirements for Active Directory Recycle Bin 2008

Requirements for Active Directory Recycle Bin

Requirements for Active Directory Recycle Bin

Updated: December 21, 2012

Applies To: Windows Server 2008 R2

By default, Active Directory Recycle Bin in Windows Server 2008 R2 is disabled. To enable Active Directory Recycle Bin, your environment must meet the requirements in the following sections.

Active Directory Domain Services environment

Do the following […]

Hyper -V Fabric Monitoring

Fabric Monitoring

A close integration between System Center 2012 R2 Virtual Machine Manager and System Center 2012 R2 Operations Manager introduces System Center cloud monitoring of virtual layers for private cloud environments. To get this new functionality, use the System Center 2012 Management Pack for System Center 2012 R2 Virtual Machine Manager Dashboard, which is […]

Page 1 of 3123