Tag: bitnami – ServerOK

Reset MySQL root password on Bitnami server

Posted on December 13, 2020 by ServerOk

To reset MySQL root password on Bitnami server, first check MySQL server version you are running.

mysql --version

1	mysql --version

Create a file

vi /tmp/mysql-init

1	vi /tmp/mysql-init

Add following text For MySQL 5.7 or MySQL 8

ALTER USER 'root'@'localhost' IDENTIFIED BY 'NEW_PASSWORD';
ALTER USER 'root'@'127.0.0.1' IDENTIFIED BY 'NEW_PASSWORD';

1 2	ALTER USER 'root'@'localhost' IDENTIFIED BY 'NEW_PASSWORD'; ALTER USER 'root'@'127.0.0.1' IDENTIFIED BY 'NEW_PASSWORD';

For MySQL 5.6

UPDATE mysql.user SET Password=PASSWORD('NEW_PASSWORD') WHERE User='root';
FLUSH PRIVILEGES;

1 2	UPDATE mysql.user SET Password=PASSWORD('NEW_PASSWORD') WHERE User='root'; FLUSH PRIVILEGES;

In above code, replace NEW_PASSWORD with your new MySQL root password. Stop MySQL

/opt/bitnami/ctlscript.sh stop mysql

1	/opt/bitnami/ctlscript.sh stop mysql

Reset MySQL root password by running […]

Disable MySQL bin log on Bitnami

Posted on February 26, 2020 by ServerOk

if you have cloud sevrer with less disk space, it is better disable MySQL bin log as it take approx 3 GB of disk space on bitnami server. To disable MySQL binlog, edit mysql config file.

vi /opt/bitnami/mysql/my.cnf

1	vi /opt/bitnami/mysql/my.cnf

Find

[mysqld]

[mysqld]

Add below

disable_log_bin

1	disable_log_bin

Here is what i have in the my.cnf

root@wordpress-vm:~# cat /opt/bitnami/mysql/my.cnf

[mysqladmin]
user=root

[mysqld]
disable_log_bin
basedir=/opt/bitnami/mysql
datadir="/opt/bitnami/mysql/data"
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock
tmpdir=/opt/bitnami/mysql/tmp
max_allowed_packet=32M
bind-address=127.0.0.1
skip-name-resolve=1
default-authentication-plugin=mysql_native_password

character-set-server=UTF8
collation-server=utf8_general_ci
[client]
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock

default-character-set=UTF8
[manager]
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock
pid-file=/opt/bitnami/mysql/tmp/manager.pid
default-mysqld-path=/opt/bitnami/mysql/bin/mysqld.bin


!include /opt/bitnami/mysql/bitnami/my.cnf
root@wordpress-vm:~#

root@wordpress-vm:~# cat /opt/bitnami/mysql/my.cnf

[mysqladmin]

user=root

[mysqld]

disable_log_bin

basedir=/opt/bitnami/mysql

datadir="/opt/bitnami/mysql/data"

port=3306

socket=/opt/bitnami/mysql/tmp/mysql.sock

tmpdir=/opt/bitnami/mysql/tmp

max_allowed_packet=32M

bind-address=127.0.0.1

skip-name-resolve=1

default-authentication-plugin=mysql_native_password

character-set-server=UTF8

collation-server=utf8_general_ci

[client]

port=3306

socket=/opt/bitnami/mysql/tmp/mysql.sock

default-character-set=UTF8

[manager]

port=3306

socket=/opt/bitnami/mysql/tmp/mysql.sock

pid-file=/opt/bitnami/mysql/tmp/manager.pid

default-mysqld-path=/opt/bitnami/mysql/bin/mysqld.bin

!include /opt/bitnami/mysql/bitnami/my.cnf

root@wordpress-vm:~#

Now restart MySQL

/opt/bitnami/ctlscript.sh stop mysql
/opt/bitnami/ctlscript.sh start mysql

1 2	/opt/bitnami/ctlscript.sh stop mysql /opt/bitnami/ctlscript.sh start mysql

[…]

Install LetsEncrypt SSL on Bitnami

Posted on January 27, 2019 (December 14, 2019) by ServerOk

To install LetsEncrypt SSL on bitnami wordpress server, install letsencrypt with

wget https://raw.githubusercontent.com/serverok/server-setup/master/install/letsencrypt.sh
sh ./letsencrypt.sh

1 2	wget https://raw.githubusercontent.com/serverok/server-setup/master/install/letsencrypt.sh sh ./letsencrypt.sh

Stop apache web server with

/opt/bitnami/ctlscript.sh stop apache

1	/opt/bitnami/ctlscript.sh stop apache

Now get SSL certificate using certbot

certbot certonly --standalone -d YOUR-DOMAIN.EXT -d www.YOUR-DOMAIN.EXT

1	certbot certonly --standalone -d YOUR-DOMAIN.EXT -d www.YOUR-DOMAIN.EXT

Now you have SSL certficate, lets copy it to bitnami folder

cat /etc/letsencrypt/live/YOUR-DOMAIN.EXT/privkey.pem >  /opt/bitnami/apache2/conf/server.key
cat /etc/letsencrypt/live/YOUR-DOMAIN.EXT/cert.pem > /opt/bitnami/apache2/conf/server.crt
cat /etc/letsencrypt/live/YOUR-DOMAIN.EXT/chain.pem >> /opt/bitnami/apache2/conf/server.crt

cat /etc/letsencrypt/live/YOUR-DOMAIN.EXT/privkey.pem > /opt/bitnami/apache2/conf/server.key

cat /etc/letsencrypt/live/YOUR-DOMAIN.EXT/cert.pem > /opt/bitnami/apache2/conf/server.crt

cat /etc/letsencrypt/live/YOUR-DOMAIN.EXT/chain.pem >> /opt/bitnami/apache2/conf/server.crt

Start the web server with

/opt/bitnami/ctlscript.sh start apache

1	/opt/bitnami/ctlscript.sh start apache

Auto Renew LetsEncrypt Create file

mkdir /usr/serverok
vi /usr/serverok/ssl-renew

1 2	mkdir /usr/serverok vi /usr/serverok/ssl-renew

Add following to the file. Replace […]

Bitnami

Posted on April 30, 2018 (December 13, 2020) by ServerOk

WordPress bitnami Install LetsEncrypt SSL on Bitnami Disable MySQL bin log on Bitnami Reset MySQL root password on Bitnami server To remove logo from bitnami wordpress, login to SSH as user “bitnami”, then run

sudo /opt/bitnami/apps/wordpress/bnconfig --disable_banner 1

1	sudo /opt/bitnami/apps/wordpress/bnconfig --disable_banner 1

Now restart web server

sudo /opt/bitnami/ctlscript.sh restart apache

1	sudo /opt/bitnami/ctlscript.sh restart apache

If you are using Nginx, run

sudo /opt/bitnami/ctlscript.sh restart nginx

1	sudo /opt/bitnami/ctlscript.sh restart nginx

[…]

Kubeapps

Posted on December 25, 2017 by ServerOk

Kubeapps allows you to run bitnami applications in Kubernetes cluster. […]

WordPress bitnami

Posted on December 16, 2017 (January 27, 2019) by ServerOk

Install LetsEncrypt SSL on Bitnami To stop/start service use ctlscript.sh

root@ip-172-31-26-46:~# /opt/bitnami/ctlscript.sh 
usage: /opt/bitnami/ctlscript.sh help
       /opt/bitnami/ctlscript.sh (start|stop|restart|status)
       /opt/bitnami/ctlscript.sh (start|stop|restart|status) mysql
       /opt/bitnami/ctlscript.sh (start|stop|restart|status) php-fpm
       /opt/bitnami/ctlscript.sh (start|stop|restart|status) apache

help       - this screen
start      - start the service(s)
stop       - stop  the service(s)
restart    - restart or start the service(s)
status     - show the status of the service(s)

root@ip-172-31-26-46:~#

root@ip-172-31-26-46:~# /opt/bitnami/ctlscript.sh

usage: /opt/bitnami/ctlscript.sh help

/opt/bitnami/ctlscript.sh (start|stop|restart|status)

/opt/bitnami/ctlscript.sh (start|stop|restart|status) mysql

/opt/bitnami/ctlscript.sh (start|stop|restart|status) php-fpm

/opt/bitnami/ctlscript.sh (start|stop|restart|status) apache

help - this screen

start - start the service(s)

stop - stop the service(s)

restart - restart or start the service(s)

status - show the status of the service(s)

root@ip-172-31-26-46:~#

To stop MySQL, run

root@ip-172-31-26-46:~# /opt/bitnami/ctlscript.sh stop mysql
Unmonitored mysql
/opt/bitnami/mysql/scripts/ctl.sh : mysql stopped
root@ip-172-31-26-46:~#

root@ip-172-31-26-46:~# /opt/bitnami/ctlscript.sh stop mysql

Unmonitored mysql

/opt/bitnami/mysql/scripts/ctl.sh : mysql stopped

root@ip-172-31-26-46:~#

To disable Banner on WordPress site, run

/opt/bitnami/apps/wordpress/bnconfig --disable_banner 1

1	/opt/bitnami/apps/wordpress/bnconfig --disable_banner 1

Disable MySQL in Bitnami instance after moving Database to RDS

/opt/bitnami/ctlscript.sh stop mysql
mv /opt/bitnami/mysql/scripts/ctl.sh /opt/bitnami/mysql/scripts/ctl.sh.disabled
mv /opt/bitnami/config/monit/conf.d/mysql.conf /opt/bitnami/config/monit/conf.d/mysql.conf.disabled

/opt/bitnami/ctlscript.sh stop mysql

mv /opt/bitnami/mysql/scripts/ctl.sh /opt/bitnami/mysql/scripts/ctl.sh.disabled

mv /opt/bitnami/config/monit/conf.d/mysql.conf /opt/bitnami/config/monit/conf.d/mysql.conf.disabled

Apache Config VirtualHost entry for wordpress is available on file

vi /opt/bitnami/apache2/conf/bitnami/bitnami.conf

1	vi /opt/bitnami/apache2/conf/bitnami/bitnami.conf

[…]