Step 1 – At the linux shell, stop the current mysqld process, start the mysqld_safe process with –skip-grant-tables switch and login as root (no password). /etc/init.d/mysql stop mysqld_safe –skip-grant-tables & mysql -u root Step 2 – At the mysql shell set the root password and flush privileges. USE mysql; UPDATE user SET password=PASSWORD("new-password-here") WHERE User=’root’; [...]
To reset the MySQL root password, login to the mysql shell and run the following commands. SET PASSWORD FOR root@localhost=PASSWORD(’RootPasswordHere’); FLUSH PRIVILEGES;
To grant all privileges to a user from any location login to the mysql shell and run the following queries. GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY ‘PasswordHere’ WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO username@"%" IDENTIFIED BY ‘PasswordHere’ WITH GRANT OPTION; FLUSH PRIVILEGES;
Use Apache’s mod_expires to explicitly set the expiration of a file by it’s type. This will enable to browser to cache these static assets and greatly increase performance. <IfModule mod_expires.c> ExpiresActive on ExpiresDefault "now" ExpiresByType text/html "now" ExpiresByType text/xml "now" ExpiresByType text/css "access plus 8 hours" ExpiresByType text/plain "access plus 8 hours" ExpiresByType application/x-javascript "access [...]