Your Place for Linux/Windows Tutorials
Helpful Tips / Tricks
How to Permanently Decrypt an Encyrpted VI File
Jan 5th
Say you accidently encrypted a file and want to decrypt it permanently. Or you have an encrypted file and you want to decrypt it permanently. The process is easier than you think.
1.) vim -x filename 2.) Enter passphrase 3.) While in VI, type “:X” (without the quotes) and hit enter More >
Cannot Connect to Host “hostname”
Nov 23rd
When trying to run an application using X11 on a host, and getting “Cannot connect to host “hostname”", you should try using
ssh host -X
This enabled X11 forwarding, even if you have it enabled by default, still try it. If it doesn’t work, try
ssh host -Y
The error is caused More >
How to Reset MySQL Root Password
Oct 3rd
As always, let’s login to the server with root privileges.
Now, stop the Mysql daemon:
service mysqld stop
Then, run:
mysqld_safe --skip-grant-tables
This will start MySQLd in Safe mode and skip the grant tables, which is where the passwords are stored.
Now, you should be able to login as root into MySQLd without being prompted for More >
How to add an FTP user
Sep 7th
This article will teach you how to add an FTP user, using ProFTPD
A running theme with most of the tutorials I write here is you need to login with a user who has root privileges (i.e. Sudo), so lets do so.
Now, add a user as you normally would:
adduser username
Set a More >
Changing the Timezone in MySQL
Aug 30th
This article will explain how to change the timezone for MySQL.
1.) Login to mysql as root
mysql -u root -p
2.) Run the following command:
SET GLOBAL time_zone='timezone'
For example, since I live in Arizona and we are GMT -7 I would use:
SET GLOBAL time_zone='GMT -7'
Hopefully this helps. If you have any questions, feel More >
