How can I increase MySQL max connections?
By InterServer Staff on October 23rd, 2015
Edit the file /etc/my.cnf
The file should look like this:
[mysqld]
set-variable = max_connections=500
Increase 500 to the number you desire.
- How to manage MySQL users via Command line
- How to manage MySQL databases with command line
- Import and Export Databases in MySQL using Command Line
- Allow MySQL remote connections and Secure them on Ubuntu 16.04
- Set up Master-Slave replication in MySQL Server 5.7
- How to Fix the Common MySQL Errors?
- How to Monitor MySQL Using Mytop?
- MySQL Error – The Server Quit Without Updating PID File
- What is MySQL Query Caching?
- MySQL Storage Engines – Types and Details
- MySQL FLUSH Commands.
- How to recover the mysql root password?
- How can I start and stop mysql?
- How do I allow remote MySQL connections?
- How can I backup my MySQL Database?
- DEFAULT CHARSET=latin1 or collate latin1_general_ci NOT NULL default or TIMESTAMP errors on importing a database dump
I am using a shared hosting plan. I am trying to do it on phpmyadmin but it keeps on saying you need at least One of the super user previledges. Please how can I go about this
You’ll need root access to do that which is not available in shared plans. Please take a look at our Cloud VPS plans here: https://www.interserver.net/vps You’ll get full root access with these plans.