RSS

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 normal mode killall mysqld /etc/init.d/mysql start Your password should now [...]

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 cd wordpress mv * ../ rm -R [...]

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 your lighttpd.conf nano /etc/lighttpd.conf Add the following for the virtual host configuration $HTTP["host"] == "domain1.com" { server.document-root = "/home/domain1" accesslog.filename [...]

Continue reading...

Pastebin from command line

Thursday, May 28, 2009

0 Comments

Have you ever wanted to show data from your command line but couldn't copy it? there is now a solution the script below will allow you to paste the output of commands into the tuts4tech pastebin just copy the script below and save it in /usr/bin/pastebin then you'll be able to do | pastebin e.g [...]

Continue reading...