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> [...]
Posts Tagged ‘HowTo’
Posted in 
Tags: 
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….
March 17th, 2009
Adding .ttf Fonts to Ubuntu’s OpenOffice
I have many TrueType (.ttf) fonts I used on my old Windoze system which I wanted to use in Ubuntu. After a bit of investigating and after finding several different solutions relating to many different distros, I finally found one which worked. So here it is:
March 8th, 2009
Installing Retrospect Client on Linux Servers
Retrospect is a popular backup solution used by many large organizations, similar in functionality to Semantec Backup Exec. The main application is designed for Windows Server operating systems and includes clients for Windows, Linux, Mac OS, Solaris and Netware. These instructions are written for CentOS 5 and Red Hat Enterprise Linux 5 (not tested on [...]
