CentOS Linux 5/6 Install Mysql Database Server

To install MySQL server on CentOS 5/6, follow these steps: Add the MySQL repository: wget https://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm sudo yum localinstall mysql57-community-release-el6-9.noarch.rpm Install the MySQL server: sudo yum install mysql-server Start the MySQL service: sudo service mysqld start Set the root password: mysqladmin -u root password ‘new_password’ Replace new_password with the desired password for the MySQL root … Read more

HowTo: Deleting Directories in Linux

To delete a directory in Linux, you can use the rmdir command. However, if the directory is not empty, you will get an error message. To delete a directory and all its contents, including any subdirectories and files, you can use the rm command with the -r (recursive) option. For example: rm -r directory_name Note … Read more

gnome-terminal: There Was An Error Creating The Child Process For This Terminal

The error message “There was an error creating the child process for this terminal” usually indicates a problem with starting the shell process in the gnome-terminal. There could be several reasons for this error, including: Permission issues with the shell executable: Ensure that the shell executable has the necessary permissions to run. Incorrect shell specified … Read more

SSH: Use Remote Bash / KSH source Command Set Variable Locally From a Remote Server

You can use the remote source command with the ssh command to set a variable locally from a remote server. Here’s an example in bash: VAR=$(ssh user@remote-server “source ~/.bashrc; echo \$VAR”) In this example, the ssh command connects to the remote server as user, sources the ~/.bashrc file, and then echoes the value of the … Read more

Set/Export: http_proxy With Special Characters In Password Under Unix / Linux

You can set the http_proxy environment variable with a password that contains special characters by URL encoding the password. The URL encoding replaces special characters with their hexadecimal representation. Here’s an example of setting the http_proxy variable with a password that contains special characters: export http_proxy=”http://username:$(echo -n “pass#word” | xxd -plain | tr -d ‘\n’ … Read more

HowTo: Linux Limit A Specific User’s Shell Account Network Bandwidth Using Bash Shell and Trickle

To limit the network bandwidth of a specific user’s shell account in Linux, you can use the trickle command. Trickle is a user-space bandwidth shaper that can be used to limit the network bandwidth of individual programs. Here is how to limit the network bandwidth of a specific user’s shell account: Install trickle: sudo apt-get … Read more

MySQL/MariaDB Server: Bind To Multiple IP Address

To bind a MySQL/MariaDB server to multiple IP addresses, you can follow these steps: Open the MySQL/MariaDB configuration file: sudo nano /etc/mysql/my.cnf Locate the bind-address directive and comment it out or delete it: # bind-address = 127.0.0.1 Add the following lines to the configuration file to specify the IP addresses that the server should listen … Read more