MySQL - reset a lost MySQL root password
The MySQL root password allows full access to the MySQL database and allows for all actions to be undertaken including creating new users, new databases, setting access rules and so on.
The first thing to do is stop MySQL.
sudo /etc/init.d/mysql stop
Now start mysql in safe mode.
Next we need to start MySQL in safe mode - that is to say, we will start MySQL but skip the user privileges table.
sudo mysqld_safe –skip-grant-tables &
*ampersand (&) at the end of the command is required.
Login
Next, instruct MySQL which database to use:
Reset password
Enter the new password for the root user as follows:
update user set password=PASSWORD(”mynewpassword”) where User=’root’;
and finally, flush the privileges and then stop and start mysql.
Reset the license for Ensim Pro Control Panel Linux
Ensim Pro Control Panel license is tied to a MAC-address. Therefore, when you change your network card, Ensim does not recognize the license as valid anymore.
Rename /etc/appliance/.license/.LIC_file and /etc/appliance/.license/.MLK_file so that the license would be treated as a new one by Ensim
# mv /etc/appliance/.license/.MLK_file /etc/appliance/.license/.MLK_file.bak
# mv /etc/appliance/.license/.LIC_file /etc/appliance/.license/.LIC_file.bak
Once this is done, we need to contact support to reset the license.
How to reset SQL “sa” password and Integrate with Plesk Control panel
The following steps will guide you to reset the SQL admin password and how to integrate it with Plesk control panel for hosting purpose.
Step 1: Login to the Windows server through RDP.
Step 2: Open CMD ( Start -> Run -> type: cmd then Enter)
Step 3: cd “c:\Program files\Microsoft SQL Server\80\Tools\Binn”
Step 4: Now execute the following command.
osql -E -Q “EXEC sp_password @new=’newpassword’, @loginame = ’sa’”
Now integrate SQL server with Plesk control panel.
Step 1: Login to Plesk control panel using the admin login.
Step 2: Select “Server >> Databases >> Add new database”.
Step 3: Create new MSSQL database server using SQL admin (known as “sa”) login details.
