MySQL root password reset on debian/ubuntu – cut and paste

Based on these instructions. http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html. Just cut and paste the following into a terminal to reset MySQL root password to ‘newpass123’ # stop existing service sudo service mysql stop; # start without access control sudo mysqld –skip-grant-tables & # wait until started sleep 5; # reset password echo “UPDATE mysql.user SET password=PASSWORD(‘newpass123′) WHERE user=’root’;FLUSH PRIVILEGES;”… Continue reading MySQL root password reset on debian/ubuntu – cut and paste

LAMP hello world

Quick start/refresher cheat-sheet on setup of fresh LAMP test server on Ubuntu 9.10. Intended for local development only, no security concerns addressed. Installation apt-get install apache2 libapache2-mod-php5 php5 mysql-server php5-mysql Login as root user to create a dedicated user and database. mysql –user root –password mysql> USE mysql; mysql> CREATE DATABASE testdb; mysql> CREATE USER… Continue reading LAMP hello world