mysql> create database ajay; Query OK, 1 row affected (0.00 sec) CREATE USER ‘newuser’@’localhost’ IDENTIFIED BY ‘password’; GRANT ALL PRIVILEGES ON * . * TO ‘newuser’@’localhost’; FLUSH PRIVILEGES;
This tutorial describes how to set up MySQL master-master replication. We need to replicate MySQL servers to achieve high-availability (HA). In my case I need two masters that are synchronized with each other so that if one of them drops down, other could take over and no data is lost. Similarly when the […]
How to install MySQL Install MySQL yum install mysql-server mysql php-mysql How to configure MySQL Set the MySQL service to start on boot chkconfig –levels 235 mysqld on Start the MySQL service service mysqld start Log into MySQL mysql -u root Set the root user password for all local domains SET PASSWORD FOR ‘root’@’localhost’ […]
You can pipe the output of mailq through various other filters but simply you can do this # mailq | tail -1 or this mailq | grep -c “^[A-Z0-9]”
FTP hangs or throws these error after a successful login. Vsftp – ftp: connect: No route to host This is because the FTP-data port is blocked by a firewall. 1. Make sure that passive mode is enabled (vsftp enables it by default). Check the file /etc/vsftpd/vsftpd.conf, for the following lines pasv_enable=YES 2. Also check whether […]
I really like to use this as the bash while loop is a control flow statement that allows code or commands to be executed repeatedly based on a given condition. while [ condition ] do command1 done i run this loop to show my EXIM mailq count every minute while true; do date && echo […]
method 1: Temp: on boot from GRUB Menu selecy kernel line and press e then add fast boot at the end of the line , press ENTER and Press b to boot Permanent: /boot/grub/grub.conf Find kernel line and put fastboot at the end of the kernel line. In the end it should look as follow: kernel […]
You can cd to /var/spool/mqueue and delete all files if you want to get rid of all messages in the queue: # cd /var/spool/mqueue/ # ls # rm *
Command 10 = 10 seconds interval #iostat 10 Result avg-cpu: %user %nice %system %iowait %steal %idle 0.55 0.00 0.03 0.21 0.00 99.22 Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn sda 15.27 0.16 162.70 1787038 1770815888
If you need to configure a linux in different network with different gteway this howto is for you. I present you a solution to do the multi default gateway under linux based on iproute2 commande line. Schema example : Step 1 : Creation of the table definition in iproute2: root# cat /etc/iproute2/rt_tables # reserved values […]
