Solved

unable to find my.cnf

Posted on 2004-08-26
6
718 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
6 Comments
 
LVL 32

Expert Comment

by:ldbkutty
Comment Utility
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
Comment Utility
I am using linux es
0
 
LVL 48

Expert Comment

by:hernst42
Comment Utility
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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 26

Accepted Solution

by:
ushastry earned 250 total points
Comment Utility


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
Comment Utility
"unable to find my.cnf"

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

0
 
LVL 26

Expert Comment

by:ushastry
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
This video discusses moving either the default database or any database to a new volume.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

763 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now