How to Reset Password Using Putty under MySQL

1. Introduction
The document applies to MyPBX Standard V6/V7, SOHO V4/V5, U100/ U series, and Enterprise, which is using MySQL database.  
In this guide, we introduce how to reset password to “password” under MySQL.

2. Login MyPBX Using Putty
Note: In this guide, we show you how to log in MyPBX via SSH using Putty, you can also use other Telnet/SSH client to log in.

Step1. Before we can access MyPBX via SSH, we should enable SSH in “LAN settings” page.

       Figure 2-1. Enable SSH in "LAN Settings"

Step2. Open Putty via SSH.

      Figure 2-2. Login MyPBX via SSH using putty

Step3. Login MyPBX as root
Note: the default username is “root” and the default password is “ys123456”.

                                             Figure 3. Login as root

3. Reset the Password

Reset password of all accounts.
There are several accounts on MyPBX: admin, monitor, hotel, cdr, user, we can reset all the accounts' password by one command or execute commands one by one.

Execute the command “mysql -uroot -pys123456 MyPBX -e "update pwdsettings set password=md5('password')";”. Please don’t forget the semicolon.

Note: ys123456 is the password of root by default, if you have changed the password, please change it to the present password.

               Figure 3-1. Reset Password of All Accounts by One Command

Here is the second way:
That is execute these three commands one by one.
mysql –uroot –pys123456              // To enter MySQL database;

                                      Figure 3-2. Enter MySQL Database

use mypbx

                                       Figure 3-3. Use MyPBX

update pwdsettings set password=md5('password');

                              Figure 3-4. Update the Table of Password.

Reset password for a specific account.
We can reset password of a specific account by one command or execute commands one by one. Let’s take “admin” as an example.

Type “mysql -uroot -pys123456 MyPBX -e "update pwdsettings set password=md5('password') where name='admin' "; ” please don’t forget the semicolon.

                                Figure 3-5. Reset Password of “admin”

Here is the second way:
That is execute these three commands one by one.
mysql –uroot –pys123456                // To enter MySQL database;

                                       Figure 3-6. Enter MySOL Datebase

use mypbx  


                                            Figure 3-7. Use MyPBX

update pwdsettings set password = md5('password') where name = 'admin'; Please don’t forget the semicolon.

                                 Figure 3-8. Set the Password =’password’


As for the other accounts, just change the word “admin” to the specific account name.
mysql -uroot -pys123456 MyPBX -e "update pwdsettings set password
=md5('password') where name='monitor' ";

mysql -uroot -pys123456 MyPBX -e "update pwdsettings set password
=md5('password') where name='user' ";

mysql -uroot -pys123456 MyPBX -e "update pwdsettings set password
=md5('password') where name='cdr' ";

mysql -uroot -pys123456 MyPBX -e "update pwdsettings set password
=md5('password') where name='hotel' ";

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.