To reset the root access from localhost for a MySQL instance, enter the following commands in a terminal with root/su privilages. # /etc/init.d/mysqld stop # mysqld_safe –skip-grant-tables & # mysql -u root mysql> use mysql; mysql> CREATE USER ‘root’@’localhost’ IDENTIFIED BY ‘yourpassword’; mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root’@’localhost’ -> WITH GRANT OPTION; mysql> [...]
‘HowTo’s’
Posted in 
Tags: 
March 17th, 2010
How To Recover A Lost MySQL Root Password
To reset the root password for a MySQL instance, enter the following commands in a terminal with root/su privilages. # /etc/init.d/mysqld stop # mysqld_safe –skip-grant-tables & # mysql -u root MySQL will load. Enter the following at the prompt mysql> use mysql; mysql> update user set password=PASSWORD(“yourpassword”) where User=’root’; mysql> flush privileges; mysql> quit You [...]
August 1st, 2009
A Beginner’s Guide to Getting a Website Online
For many people using the world wide web is an every day task, whether it be for work or leisure, shopping or getting information. While many of these individuals are confident in how to use the internet, and what it can do for them, there are also many people who have no idea of how it works or what they would need to do to get their own website.
May 31st, 2009
How to Set Up a Secure Chrooted Jail with RSSH
In this guide I will show you how to install and configure Restricted SSH (rssh) using the default port 22, create a chrooted jail for your users and how to properly secure it all afterwards. This method is tried and tested as I originally wrote this for my own benefit when building servers at work. [...]
May 16th, 2009
Ctrl-Alt-Backspace Disabled by Default
Most Linux distro updates being released in 2009 will be using the latest version of X. Unfortunatly, they have disabled the Ctrl-Alt-Backspace keystroke by default due to complaints by users (even though it’s been there for years). Here’s how to re-enable it….
