Increase MySQL connections max_connections Rumi, January 19, 2017 If you need to increase MySQL Connections without MySQL restart do like below mysql> show variables like 'max_connections'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 100 | +-----------------+-------+ 1 row in set (0.00 sec) mysql> SET GLOBAL max_connections = 150; Query OK, 0 rows affected (0.00 sec) mysql> show variables like 'max_connections'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 150 | +-----------------+-------+ 1 row in set (0.00 sec) These settings will change at MySQL Restart. For permanent changes add below line in my.cnf and restart MySQL max_connections = 150 Related Administrations Configurations (Linux) MySQL
Recover MySQL root Password December 27, 2011 You can recover MySQL database server password with following five easy steps. Step # 1: Stop the MySQL server process. Step # 2: Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for password. Step # 3: Connect to mysql server as the… Read More
Install PHP 7.3, 7.2, 7.1 on CentOS/RHEL 6.10 August 24, 2019 Configure Yum Repository First of all, you need to enable Remi and EPEL yum repositories on your system. Use the following command to install EPEL repository on your CentOS and Red Hat 7/6 systems Use this command to install epel-release yum repository yum install epel-release and now execute one of… Read More
Set Time Zone on CentOS 7 January 14, 2020 Checking the Current Timezone In CentOS and other modern Linux distros, you can use the timedatectl command to display and set the current system’s time and timezone. timedatectl The output below shows that the system’s timezone is set to UTC: Local time: Wed 2019-02-06 22:43:42 UTC Universal time: Wed 2019-02-06… Read More