$ sudo apt-get install acpi $ acpi
Month: April 2018
How to set & change root password in MySQL
Set root password MySQL for the first time:
$ mysqladmin -u root password NEWPASSWORD
Change your existing root password:
$ mysqladmin -u root -p'oldpassword' password newpass
Generate CSR for Nginx server
This is how to generate the .csr file, requirement for SSL certificate.
$ openssl req -new -newkey rsa:2048 -nodes -keyout server.key -out server.csr ----- Country Name (2 letter code) [AU]:ID State or Province Name (full name) [Some-State]: Locality Name (eg, city) []: Organization Name (eg, company) [Internet Widgits Pty Ltd]: Organizational Unit Name (eg, section) []: Common Name (e.g. server FQDN or YOUR name) []:domain.com Email Address []: Please enter the following 'extra' attributes to be sent with your certificate request A challenge password []: An optional company name []:
Install SSL certificate
cat domain_com.crt > domain_chain.crt ; echo "" >> domain_chain.crt ; cat domain_com.ca-bundle >> domain_chain.crt
—–BEGIN RSA PRIVATE KEY—–
(Your Private Key: your_domain_name.key)
—–END RSA PRIVATE KEY—–
—–BEGIN CERTIFICATE—–
(Your Primary SSL certificate: your_domain_name.crt)
—–END CERTIFICATE—–
—–BEGIN CERTIFICATE—–
(Your Intermediate certificate: DigiCertCA.crt)
—–END CERTIFICATE—–
—–BEGIN CERTIFICATE—–
(Your Root certificate: TrustedRoot.crt)
—–END CERTIFICATE—–
Enable remote connection from mysql-community-server on Fedora 28
$ sudo vim /etc/my.cnf (for mysql)
$ sudo vimĀ /etc/mysql/my.cnf (for mariadb)
Find these variables, and set the value:
[mysqld] skip-grant-tables bind-address=0.0.0.0 ...
skip-grant-tables is optional, though.