General Discussion

PHP MySQL Hosting

MySQL

It is a SQL Database Management System that main used by multi-users, its Codebase copyright by a Swedish Company but was founded by David Axmark, Allan Larsson, and Michael Widenius it develops and keeps it up-to-date and carries out its each and every activity.

It same as the JBoss Model and completely opposite to the Apache Working theme.MySQL is famous for its web applications and the database for LAMP, MAMP, and Platforms and also for some open-source bug tracking tools it is also known for its user-friendly feature. Normally MySQL and PHP usually combined together well versed.

PHP

Hypertext Preprocessor is an open-source programming language that originated to produce the most interactive websites. This programming language is an open challenge to other languages.

It used in server-side application software used from a command-line interface/stand-alone graphical applications.

How to Reset MySQL Password in Plesk?

1) log in to the Server and load MySQL with the ‘skip-grant-tables’ in /etc/my.cnf like below.
[mysqld]
default-character-set=latin1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable=max_connections=500
skip-grant-tables

2) Log on the MySQL server and set an empty password for root.
[root@support root]# mysql
mysql>FLUSH PRIVILEGES;
mysql>GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY ‘new password’ WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;
mysql>\q

3) Comment out or remove string ‘skip-grant-tables’ like below.
[mysqld]
default-character-set=latin1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable=max_connections=500
#skip-grant-tables

4) Then restart mysqld service with command
/sbin/service mysqld restart