by skufel | Aug 8, 2016 | Databases, Linux, Scripting, Security, SysAdmin
In order to install MySQL/MariaDB database engine on CentOS follow these: [root@localhost ~]# yum install mariadb-server [root@localhost ~]# systemctl enable mariadb [root@localhost ~]# systemctl start mariadb [root@localhost ~]#...
by skufel | Jan 26, 2014 | Infrastructure, Security, SysAdmin, Windows
If you have machine which is not connected to domain, but has TPM chip you might want to encrypt disks with BitLocker and enable PIN protection at boot-up. In order to do that you have to make sure TPM is activated and enabled for provisioning in BIOS. Next step will...
by skufel | Sep 24, 2012 | Databases
After I instaled PostgreSQL on Amazon Linux AMI, first thing after database server was up and running I start thinking how to create user with administrative privileges, so I can access it using some management applications. So, here is how to create superuser and set...
by skufel | Dec 8, 2011 | Databases, Infrastructure, Scripting, SysAdmin
By default when I installed mysql on openSUSE, root password for mysql access was blank. First thing then is to change password as this might pose security issue. First of all login to openSUSE using root account and then: lab-net-01:~ #mysql Welcome to the MySQL...
