MySQL
It is a SQL Database Management System that is mainly used by multi-users, its Codebase is copywrited 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 is same like the JBoss Model and completely opposite to Apache Working theme.MySQL is famous for its web applications and is the database for LAMP, MAMP and Platforms and also for some open-source bug tracking tools and it is also known for its user friendly feature. Normally the MySQL and PHP are usually combined together well versed.
Hypertext Preprocessor is a open-source programming language which originated in the aim of production of the most interactive websites.This programming language is an open-challenge to other languages.
It is used in server-side application software but can be made use from a command line interface/stand-alone graphical applications.
How to Reset MySQL Password in Plesk?
1) Login 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
