Solved

unable to find my.cnf

Posted on 2004-08-26
6
722 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
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 26

Accepted Solution

by:
ushastry earned 250 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:ushastry
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
Creating and Managing Databases with phpMyAdmin in cPanel.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

832 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