Mobile Portal

Tutorial

Important Tutorials

Resetting Database Password of VPS OVH

Resetting Database Password of VPS OVH

Tutorial
Last tutorial discuss about Resetting VPS Root Password. Now in this tutorial showing how to resetting MySQL Password or MariaDB. While updating the Adminer MySQl Password, Forgetting password reaalllyyy so much irritating part while working on it. And It happens to the most of us. If you forget or lose the root password to your MySQL or MariaDB database, you can still access and reset the password if you have access to the server and a sudo-enabled user account. In this article I am going to cover how to reset the root password for older and newer versions of MySQL and MariaDB At First run the PuTTY and follow the bellow command carefully Step 1 — First Identify the Running Database Version Depending on the database used and its version, you'll need to use different commands to recove
mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists what this Mean?

mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists what this Mean?

Tutorial
While Resetting the Database Password of VPS this message shows when running command. While restarting the database server you need to run this command   sudo mysqld_safe --skip-grant-tables --skip-networking & here The ampersand(&) at the end of this command will make this process run in the background so you can continue to use your terminal. For me when I run this command it shows “mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists”. In that case you just need to run those command and the “mysqld” directory will automatically create. mkdir -p /var/run/mysqld chown mysql:mysql /var/run/mysqld Now you can connect to the database as the root user, which will not asked for a password. Now use this Command: mysql -u root Now this MySQL Prompt Will
Resetting VPS Password with OVH

Resetting VPS Password with OVH

Tutorial
In this article explaining the useful steps to Resetting VPS  Password with OVH Step 1: First need to open the SSH session on your VPS. In Windows, the SSH client does not exist by default so you will need an additional software. The Additional Software is PuTTY. That can be downloaded from here for free. Download PuTTY: https://www.putty.org/ Step 2: When  download complete, simply launch it and then enter the VPS details you received by email: Step 3: While launched , A console window will appear, type root as user name and the associated password, received in the OVH activation email. If you don't make any mistake, the SSH session is open on your server. Like this: Step 3: Change the root password, Now we will change the default root password that you have received in the