Tag Archive | "mysql"

Resetting your mysql root password

Thursday, August 13, 2009

0 Comments

First of all we need to stop mysql /etc/init.d/mysql stop Create a mysql table dump to reset the password UPDATE mysql.user SET Password=PASSWORD('YOUR-NEW-MYSQL-PASSWORD') WHERE User='root'; FLUSH PRIVILEGES; Now we need to start mysql in safe mode and import the mysql table dump mysqld_safe --init-file=/path/to/mysql/table/dump & Finally we need to kill mysql and start it in [...]

Continue reading...

How To Install WordPress (From Command line)

Friday, June 19, 2009

0 Comments

Okay, this tutorial will show you how to very easily install WordPress on your own server from the command line. First step is to make a MySQL database, user and permissions for that user. Secondly, you go to the directory that you want to put WordPress in and get the files: wget http://www.wordpress.org/latest.zip unzip wordpress-*.zip [...]

Continue reading...

Lighttpd virtual hosting

Saturday, June 13, 2009

0 Comments

Virtual hosting allows you to host many websites from one server. Setup The Folders and users adduser domain1 addgroup domain1 adduser www-data domain1 mkdir -p /home/domain1 chown domain1:domain1 -R /home/domain1 chmod 750 -R /home/domain1 adduser domain2 addgroup domain2 adduser www-data domain2 mkdir -p /home/domain2 chown domain2:domain2 -R /home/domain2 chmod 750 -R /home/domain2 Lighttpd Config Open [...]

Continue reading...