Resetting the Root Password for mysqld on Unix Systems

“These are taken from the mysql website and is for refrence and documentation purpose”

On Unix, use the following procedure to reset the password for all MySQL root accounts. The instructions assume that you will start the server so that it runs using the Unix login account that you normally use for running the server. For example, if you run the server using the mysql login account, you should log in as mysql before using the instructions. Alternatively, you can log in as root, but in this case you must start mysqld with the --user=mysql option. If you start the server as root without using --user=mysql, the server may create root-owned files in the data directory, such as log files, and these may cause permission-related problems for future server startups. If that happens, you will need to either change the ownership of the files to mysql or remove them.

MySQL php wordpress

if you get the error “Your PHP installation appears to be missing the MySQL extension which is required by WordPress”

install the following files with yourapache, php and mysql installation, mine got fixed by this, hope yours too will

[code language=”text”]
sudo apt-get install  phpmyadmin libapache2-mod-php5 libapache2-mod-auth-mysql php5-mysql