Database – CyberBuddy

Category: Database

Can’t increase MySQL max_connection stuck at 214

Issue : Increased the max_connection value to max_connections=2500 in my.cnf. grep -rnw max_connections /etc/mysql/ Output: max_connections = 2500 But max_connection value stuck in 214 Connections. Cause : Default open_files_limit for Read more

By: Rajat Malik Published: 10:47 pm

How To Connect AWS RDS With PhpMyAdmin

Before you get started, gather the below requirement: Apache installed and running Php installed version 5.6 or above RDS Endpoint RDS MySQL Username and Password Step 1: Verify apache is Read more

By: Rajat Malik Published: 1:00 pm

MySQL Basic Commands

How to login into MYSQL through terminal sudo mysql -h hostname -u username -p Create a database List all databases mysql> create database databasename; mysql> show databases; List all tables Read more

By: Rajat Malik Published: 5:31 pm

How to install MySQL on Ubuntu

Step 1: Enable MySQL Apt Repositories wget -c https://repo.mysql.com//mysql-apt-config_0.8.13-1_all.deb Then install the MySQL repository package by using the below command. sudo dpkg -i mysql-apt-config_0.8.13-1_all.deb MySQL server version 8.0 will be Read more

By: Rajat Malik Published: 11:31 am