Reset password mysql

 

•     Reconfigure phpmyadmin
•     Ctrl+Alt+t to launch terminal
•     sudo dpkg-reconfigure phpmyadmin
•     Connection method for MySQL database for phpmyadmin: unix socket
•     Name of the database’s administrative user: root
•     Password of the database’s administrative user: password
•     MySQL username for phpmyadmin: root
•     MySQL database name for phpmyadmin: password
•     Web server to reconfigure automatically: apache2
•     ERROR 1045
•     ignore
•     sudo dpkg-reconfigure mysql-server-5.5
•     New password for the MySQL “root” user: password
•     Repeat password for the MySQL “root” user: password
•     sudo gedit /etc/apache2/mods-available/php5.conf
•     look for php_admin_value engine off, between and
•     Add # in front of php_admin_value engine off to disable it.
•     REMEMBER! Don’t change the value php_admin_value engine from off to on!
•     sudo /etc/init.d/apache2 restart