FAQ: Change forgotten or lost MySQL root password

Question: I forgot root password for MySQL DBE. How to reset or recover it? PLEASE HELP! Answer: Below is simple algorithm to reset MySQL root password in Linux, FreeBSD, OpenBSD and other Unix like operating systems: 1. Stop MySQL server process by one of the following commands: # /etc/init.d/mysqld stop # killall -9 mysqld # kill `cat /mysql-data-directory/host_name.pid` # mysqladmin shutdown To check if mysqld is killed run “ps ax [...]

Read more →

 

Secure shell (ssh) connection without password

Let’s assume we have two Linux running machines, one of them is ‘client’ and other is ‘server’. Task lies in allowing client to access server via ssh securely without a need to type password by hands. It’s usually useful to perform some operations that are to be done without user intervention (for example copying backup data files from client to server through ‘scp’).First of all it’s necessary to make sure [...]

Read more →

 

Access to sqlite3 database through perl (script example)

By publishing this post I try to help people who want to get access to popular and simple database engine sqlite through perl script. I use sqlite to store e-mails statistics at small mail server in order to retrieve information about users’ mail activity like average response time, sent and received messages and etc. There is perl script that is used to get this data per every user or get [...]

Read more →

 

Linux networking stack understanding

M. Tim Jones, Consultant Engineer, Emulex Corp.: One of the greatest features of the Linux® operating system is its networking stack. It was initially a derivative of the BSD stack and is well organized with a clean set of interfaces. Its interfaces range from the protocol agnostics, such as the common sockets layer interface or the device layer, to the specific interfaces of the individual networking protocols. This article explores [...]

Read more →

 

Fun: Bill Gates recommends Ubuntu :)

Picture found here.

Read more →