VPS and Dedicated server customers with root access can change their MySQL settings in the my.cnf file. To do this, you simply log in the server and edit the my.cnf file using Nano. This article will explain the steps to view and edit your my.cnf file.

How to view MySQL settings in the my.cnf file

  1. Login to your server via SSH
  2. To view the MySQL my.cnf settings type the following:
    cat /etc/my.cnf
     

    edit-my-cnf-1-catThe contents of the my.cnf file will display similar to the snapshot to the right.

Editing the MySQL my.cnf file

  1. Login to your server via SSH
  2. image-moodleTo edit the MySQL settings with nano type the following:
    nano /etc/my.cnf

    Note! There are several editors you can use in shell. Nano, Vim, or Emacs. This article will focus only on Nano.


  3. Nano the my.cnf in shellFind the line to edit. For example, if you want to edit the max_connections, find the following line.
    max_connections=100

    Changing the my.cnf with nanoTo increase the max_connections to 110 change it to the following.

    max_connections=110

  4. Enter Ctrl + O to "WriteOut" or save the settings.
  5. Then Ctrl + X to exit.
  6. Restart MySQL by typing the following.
    service mysql restart

    Now the max_connections is increased to 110 instead of 100.

Viewing the MySQL variables through shell.

  1. Login to your server via SSH
  2. Viewing the MySQL variablesType the following command.
    mysqladmin variables

    The variables will display similar to the snapshot to the right.

Viewing MySQL variables in PhpMyAdmin

  1. Log into your phpMyAdmin
  2. Click variables tab in PhpMyAdminClick the Variables tab at the top right.

    PhpMyAdmin list of MySQL variablesPhpMyAdmin will list all the variables and there settings on your server..


Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question
n/a Points
2014-07-13 10:40 am

-bash and command not found error is coming when i m using this command in the ssh console plz help for this and thank you in advance :)

Staff
20,312 Points
2014-07-13 9:01 pm
Hello vivek,

While looking at the commands, I did notice a typo in one of them. It should read as below:
mysqladmin variables


I have made the change on the article to display correctly. It was wrong for a time, it seems. Thank you for finding that!

If that is not the command giving you the error please let us know which one is giving you trouble as I do not see any others that should give an error.

Kindest Regards,
Scott M
n/a Points
2014-10-24 2:27 pm

Nice article.Thanks! I done for my mysql :)

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

4 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!