?
Solved

unable to find my.cnf

Posted on 2004-08-26
6
Medium Priority
?
728 Views
Last Modified: 2008-03-07
Hi,

I wanted to increase the max_connection variable to 500 but I am unable to find my.cnf file. please help.

0
Comment
Question by:tripat
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 32

Expert Comment

by:ldbkutty
ID: 11907388
Under Windows, *.cnf is a hidden extension on some systems

'C:\Windows\my.cnf' would show up as 'C:\Windows\my' because the ".cnf" extension is hidden under some Windows systems.
0
 
LVL 1

Author Comment

by:tripat
ID: 11907403
I am using linux es
0
 
LVL 48

Expert Comment

by:hernst42
ID: 11907495
On linux thefile is typicaly located at /etc/my.cnf If it is not there you can search fo the file with
find / -name my.cnf
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 26

Accepted Solution

by:
Umesh earned 1000 total points
ID: 11910998


If you have installed using source, this should be under  mysql/support-files/ you will find these (my-huge.cnf,my-small.cnf,my-large.cnf.. etc)

Copy the default configuration file for the expected size of the database (small, medium, large, huge)

cp support-files/my-medium.cnf /etc/my.cnf
chown root:sys /etc/my.cnf
chmod 644 /etc/my.cnf


Hope this helps!
0
 
LVL 7

Expert Comment

by:petoskey-001
ID: 11919373
"unable to find my.cnf"

Hmm... Where did you leave it last?  ;o)

0
 
LVL 26

Expert Comment

by:Umesh
ID: 11919430
Hi tripat,

Have you installed mySQL from source/RPM(Binary)?
If you have installed from any binary/RPM then the my.cnf should be in /etc/..
Say if this file is not found anywhere, then you can create my.cnf file. Please check this url for  how to stuff..

http://dev.mysql.com/doc/mysql/en/Option_files.html


Hope this helps!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question