|
||||||
|
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 […] 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! […] 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 […] 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 -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 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 […] 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 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 […] 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 […] 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 […] |
||||||
|
Copyright © 2024 - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
Recent Comments