How to Recovery MySQL Root Password

1 ) Stop MySql Server Service
[root@naitinoi ~]# /etc/init.d/mysqld stop
Stopping mysqld: [ OK ]

2) Start MySQL server w/o password:
[root@naitinoi ~]# mysqld_safe –skip-grant-tables &
[1] 6462
[root@naitinoi ~]# 151105 08:47:32 mysqld_safe Logging to ‘/var/log/mysqld.log’.
151105 08:47:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

3) Login as root
[root@naitinoi ~]# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.x.xx MySQL Community Server (GPL) by Remi

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update user set password=PASSWORD(“new password here”) where User=’root’;
Query OK, 3 rows affected (0.01 sec)
Rows matched: 3 Changed: 3 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> quit
Bye

4) Stop MySQL server w/o password:
[root@naitinoi ~]# /etc/init.d/mysqld stop
151105 08:49:26 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
Stopping mysqld: [ OK ]
[1]+ Done mysqld_safe –skip-grant-tables

5) Start MySql Server Service
[root@naitinoi ~]# /etc/init.d/mysqld start
Starting mysqld: [ OK ]

6) Login
[root@naitinoi ~]# mysql -u root -p
Enter password:

### FS18 Install Production ###

https://freeswitch.org/confluence/display/FREESWITCH/Debian+9+Stretch

Building From Source
Compiling Release Branch (production)

root@fs18ast16:~# wget -O – https://files.freeswitch.org/repo/deb/freeswitch-1.8/fsstretch-archive-keyring.asc | apt-key add –
root@fs18ast16:~# echo “deb http://files.freeswitch.org/repo/deb/freeswitch-1.8/ stretch main” > /etc/apt/sources.list.d/freeswitch.list
root@fs18ast16:~# echo “deb-src http://files.freeswitch.org/repo/deb/freeswitch-1.8/ stretch main” >> /etc/apt/sources.list.d/freeswitch.list
root@fs18ast16:~# apt-get update
root@fs18ast16:~# apt-get build-dep freeswitch
root@fs18ast16:~# cd /usr/src/
root@fs18ast16:/usr/src# git clone https://freeswitch.org/stash/scm/fs/freeswitch.git -bv1.8 freeswitch
root@fs18ast16:/usr/src# cd freeswitch
root@fs18ast16:/usr/src/freeswitch# git config pull.rebase true
root@fs18ast16:/usr/src/freeswitch# ./bootstrap.sh -j
root@fs18ast16:/usr/src/freeswitch# ee modules.conf
say/mod_say_th
applications/mod_esl

Edit BANNER >

root@fs18ast16:/usr/src/freeswitch# cd /usr/src/freeswitch/libs/esl
root@fs18ast16:/usr/src/freeswitch/libs/esl# cp fs_cli.c fs_cli.backup
root@fs18ast16:/usr/src/freeswitch/libs/esl# ee fs_cli.c

SEARCH : banner
remove old banner and add new

static const char *banner =”YOUR BANNER HERE< teee@local.com>”;

static const char *inf = “Type /help to see a list of commands\n\n\n”;

root@fs18ast16:/usr/src/freeswitch/libs/esl# cd /usr/src/freeswitch/src/include
root@FS18:/usr/src/freeswitch/src/include# mv cc.h cc.bak

Create NEW
root@FS18:/usr/src/freeswitch/src/include# ee cc.h

const char *cc = “”;
const char *cc_s = “”;

root@fs18ast16:/usr/src/freeswitch/src/include# cd /usr/src/freeswitch
root@fs18ast16:/usr/src/freeswitch# ./configure
root@fs18ast16:/usr/src/freeswitch# make
root@fs18ast16:/usr/src/freeswitch# make install
root@fs18ast16:/usr/src/freeswitch#

root@fs18ast16:/usr/src/freeswitch# make cd-sounds-install && make cd-moh-install && make uhd-sounds-install && make uhd-moh-install &&
make hd-sounds-install && make hd-moh-install && make sounds-install && make moh-install

root@fs18ast16:/usr/src/freeswitch# make samples

### SECURE YOUR EVENT SOCKET ###

root@fs18ast16:/usr/src/freeswitch# ee /etc/fs_cli.conf
root@fs18ast16:/usr/src/freeswitch# ee /usr/local/freeswitch/conf/autoload_configs/event_socket.conf.xml
root@fs18ast16:/usr/local/freeswitch# cd /usr/local/freeswitch/bin
root@fs18ast16:/usr/local/freeswitch/bin# ln -s /usr/local/freeswitch/bin/freeswitch /bin/freeswitch
root@fs18ast16:/usr/local/freeswitch/bin# ln -s /usr/local/freeswitch/bin/fs_cli /bin/fs_cli
root@fs18ast16:/usr/local/freeswitch/bin# ee /usr/local/freeswitch/conf/vars.xml

root@fs18ast16:/usr/local/freeswitch/conf/autoload_configs# ee /usr/local/freeswitch/conf/autoload_configs/event_socket.conf.xml





root@fs18ast16:/usr/local/freeswitch/conf/autoload_configs# ee /etc/fs_cli.conf
[default]
; Put me in /etc/fs_cli.conf or ~/.fs_cli_conf
key_f1 => help
key_f2 => status
key_f3 => show channels
key_f4 => show calls
key_f5 => sofia status
key_f6 => reloadxml
key_f7 => /log console
key_f8 => /log debug
key_f9 => sofia status profile internal
key_f10 => fsctl pause
key_f11 => fsctl resume
key_f12 => version

[default]
profile => YOUR-USER
host => YOUR-FS-IPADDR
port => 8021
password => YOUR-PASSWD
debug => 2
loglevel => debug

root@fs:/usr/src/freeswitch# ee /usr/local/freeswitch/conf/autoload_configs/acl.conf.xml

root@fs18ast16:/usr/local/freeswitch/conf/autoload_configs# ee acl.conf.xml


DISABLE IPV6 (Debian)

root@fs18ast16:~# ee /etc/sysctl.conf

net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1
net.ipv6.conf.lo.disable_ipv6 = 1
net.ipv6.conf.enp0s3.disable_ipv6 = 1

root@fs18ast16:~# sysctl -p
net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1
net.ipv6.conf.lo.disable_ipv6 = 1
net.ipv6.conf.enp0s3.disable_ipv6 = 1

root@fs:/home/teee# ee /etc/sysctl.d/70-disable-ipv6.conf
net.ipv6.conf.all.disable_ipv6 = 1

root@fs:/home/teee# ee /etc/default/grub
GRUB_CMDLINE_LINUX=”ipv6.disable=1″