Stack Overflow
Stack Overflow

Questions tagged [my.cnf]

Configuration file for MySQL programs, particularly for the mysqld server.

MySQL programs read one or more option files in .ini format, with sections specific to each program.

The global option file, usually /etc/my.cnf, frequently contains options for the mysqld server and sometimes the mysqldump or isamchk maintenance programs. There are many such options, with complex interactions; fine-tuning them for your specific needs can be out of scope for this site, but ServerFault may be able to help with some general situations.

The user-specific option file, usually ~/.my.cnf, is not often necessary, but can reduce command-line length or help tailor the mysql client to your preferences. For specific advice, SuperUser is probably a better place to look.

234 questions
8
votes
1 answer

Bind Address missing in my.cnf in MYSQL centos

I have hit a problem, when I edit the my.cnf for MySQL, the bind-address line is not in the file. Here is the content of /etc/mysql/my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is…
Megha Sharma
  • 2,235
  • 8
  • 27
  • 31
7
votes
3 answers

MAMP PRO Disable ONLY_FULL_GROUP_BY, NO_ZERO_IN_DATE, NO_ZERO_DATE in my.cnf

I'm trying to disable ONLY_FULL_GROUP_BY, NO_ZERO_IN_DATE, NO_ZERO_DATE in MAMP PRO mysql. I've changed my.cnf in mysql templates, restart mysql server but unfortunately it's still the same. So, what i'm doing wrong? How to fix?
Andrew
  • 671
  • 2
  • 8
  • 21
7
votes
3 answers

Error writing my.cnf: Permission denied

I'm attempting to edit my my.cnf file to allow remote access to mysql (by changing the bind-address). However, I'm getting a "Error writing my.cnf: Permission denied" error when I try to save (using pico through SSH). Running $ lsattr my.cnf returns…
user994585
  • 661
  • 3
  • 13
  • 28
7
votes
1 answer

my.cnf.d/server.cnf configuration - dash or underscore

I'm using MySQL/MariaDB 10.0 In my server.cnf usually in the past I've used underscores for the majority of things in this configuration. I'm testing out a generated .cnf but it has dashes instead of underscores, do dashes work?…
Sven Kahn
  • 487
  • 1
  • 3
  • 16
6
votes
3 answers

How do I set the perms of a my.cnf file to be readonly from within Docker (not at the client's OS level)?

I'm using docker-compose v 1.27 and Docker v 19.03. I have this in my docker-compose.yml file ... version: '3' services: mysql: restart: always image: mysql:8.0 cap_add: - SYS_NICE # CAP_SYS_NICE environment: …
Dave
  • 15,639
  • 133
  • 442
  • 830
6
votes
3 answers

InnoDB tables exist in MySQL but says they do not exist after copying database to new server

I used mysqldump to export my database and then I imported it into MySQL on my other server. I can now see all my tables if I do "show tables" but I can't actually select from or describe any of them. ERROR 1146 (42S02): Table 'mydatabase.user'…
mrgordon
  • 130
  • 1
  • 2
  • 7
6
votes
2 answers

changing default my.cnf path in mysql

I am having two mysql instances on same machine. The installations are on /usr/loca/mysql1 and /usr/local/mysql2. I m having separate my.cnf files located in /etc/mysql1 and /etc/mysql2. I installed the first instance of my sql using source…
user377941
  • 145
  • 1
  • 1
  • 7
6
votes
2 answers

Optimize my.cnf configuration for 1 gb ram with 100+ users online

My mysql keeps crashing. And I think it's because of improper configuration of my.cnf. Here's my my.cnf current configuration. Please help me to optimize it. I'm using a 1gb ram and 30gb ssd. I wanted to optimize my allocated ram and memory. I…
user3416962
  • 89
  • 1
  • 2
  • 7
6
votes
3 answers

Installing MySQL Workbench but File /etc/my.cnf doesn't exist

I managed to download the MySQL DMG archive to my OS (mac OS X). It works if I use the command line. Now, I'm trying to install MySQL Workbench. I've created MySQL Connection but once I'm testing the host machine settings, I get: Checking command…
Didi Bui
  • 623
  • 2
  • 7
  • 17
6
votes
4 answers

my.cnf file missing and cannot be found at any directory

I recently removed mysql 5.1 an installed mysql 5.6 on my CENTOS 6 x86 OS. When I try to look for the my.cnf file it is missing from these directories: mysqld --verbose --help | grep -A 1 "Default options" = /etc/my.cnf, /etc/mysql/my.cnf, and…
user1464296
5
votes
1 answer

mysql: unknown variable in `my.cnf`

I follow these instructions to speed up loading a big local file (500+M, 10+M rows) into MySQL, adding configurations to /etc/mysql/my.cnf: [mysql] #no-auto-rehash # faster start of mysql but no tab completition local-infile=1 # add following…
SparkAndShine
  • 17,001
  • 22
  • 90
  • 134
4
votes
2 answers

No results after removing mysql ft_stopword_file

I have a film database that contains information about a film called Yes, We're Open. When searching the database, I'm having an issue wherein a search for "yes we're open" returns another title that has the words "we're" and "open" but not "yes"…
jessica
  • 3,051
  • 2
  • 30
  • 31
4
votes
1 answer

MAMP MySQL not recognizing my.cnf values in OSX

Trying to go UTF8 permanently and can't get MAMP's install of MySQL to recognize my.cnf values. MAMP Version 2.0.5 (2.0.5) MySQL 5.5.9 my.cnf…
PHPeer
  • 659
  • 1
  • 7
  • 20
4
votes
1 answer

mysqld hangs when init-file used in my.cnf

I am trying to do some stuff every time mysqld (version 5.1.4) is started/restarted on Fedora14. I put the following line in my.cnf: init-file=/etc/mysqlinit.sql I've tried various queries in the file, even leaving the file empty. MySQL will not…
Xi Vix
  • 1,381
  • 6
  • 24
  • 43
4
votes
1 answer

updating max_allowed_packet

I have my application hosted on a shared server, I can't access my.cnf/my.ini file from my account, max_allowed_packet is set to 1M only, Now I need to change it to 32M, is their any idea either by PHP or .htaccess to change its value? Thanks and…
Prajjwal
  • 41
  • 1
  • 1
  • 2
1
2
3
…
15 16