Reset Forgotten MySQL Root Password

Have you ever forgotten the root password on one of your MySQL servers? No? Well maybe I’m not as perfect as you. This is a quick h00tow (how to) reset your MySQL root password. It does require root access on your server. If you have forgotten that password wait for another article. Original article posted on reset mysql root password. 

First things first. Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords.

mysqld_safe --skip-grant-tables
You should see mysqld start up successfully. If not, well you have bigger issues. Now you should be able to connect to mysql without a password.

mysql --user=root mysql

update user set Password=PASSWORD('new-password');
flush privileges;
exit;

Now kill your running mysqld, then restart it normally. You should be good to go. Try not to forget your password again.

MVTS for bussiness

This program is for the VoIP carrier businesses; the ISPs rendering VoIP LD and ILD call services to corporate customers operating their own VoIP equipment; and for the local, LD, and ILD telephony operators specializing in the prepaid card IP-telephony.

This program act like service, that runs at background. So it simply can executed as script command. Therefore there is no user interface for this program. However this program also have monitoring manager, that can view and monitor activity, status of originators, dialpeers, and gateways, but it must be download  separately. Don’t worry the manager is free to download. But MVTS (Mera) itself is pay ware, it’s mean you have to pay for using it.

The Mera has has few different with other under linux voip transit softswitch software. The main common is, that the configuration for Mera behaviour are saved  into file text with cfg extension. And using regex for formulating route for calls traffic.

The manager itself, divide into two parts. One part is windows side. The other part is Linux side. The windows side, provide graphical desktop user interface, that act as client software so user can easily install it on anywhere windows at office or home that connect to the Mera servers. The Linux side acting like web server and must install at the same pc / server with Mera. The web server, collecting data from mera and process it to become valuable information for monitoring, example ACD per client, ASR per client, maximum load, count of successed or failed call, etc.

By the way, ASR  is resemble Average Success Rate, it show in percent, how many call that success comparing with those one are fail. The higher percent of ACD, the better quality it shows. And ACD is resemble Average Call Duration, it show average duration for all calls. Mera server can be claim in good condition if minimum value ACD and ASR over 50-70%. But low value of acd or asr, not always come from wrong mera configuration, but it also come from client or from the gateways itself.