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

Read more
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! […]

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

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

Read more
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;

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

Read more
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 Storage Tiers allow for use of SSD and hard drive storage within the same storage pool as a new feature in Windows Server 2012 R2.  If you’ve not read Jose Barreto’s Step-by-step post on this subject […]

Read more
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 as allowing tenants to […]

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

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

Read more

Hit Counter provided by dental implants orange county