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
3
votes
3 answers

Run multiple mysql instances in mysql

I want to use MySQL server on two different ports on the same machine. I have made two separate config files. When I'm trying to connect to the MySQL server on the second port I defined then I can't connect. The OS running MySQL is Windows Vista. I…
MySQL DBA
  • 5,692
  • 21
  • 54
  • 71
2
votes
1 answer

MysqlTurner tips for improvement my mysql-mariaDB

I need a help for fix my configuration of MySQL. I've use MysqlTurner and this is the result: >> MySQLTuner 1.7.19 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help'…
Othin
  • 21
  • 3
2
votes
1 answer

How to make mysql client prompt reflect the server you're connected to, not local one

I have 2 servers - serverA and serverB, both have mysql server and mysql client. I have a reverse SSH tunnel set up from serverB to serverA so that I don't have to open ports up on server B to the internet. I access serverB from serverA by doing…
Kevin Jones
  • 3,837
  • 1
  • 16
  • 18
2
votes
5 answers

MariaDB 10.2 Performance Tuning - Lock wait timeout Issues

I have 4 instance database-clustering (2 of them are mariadb 10.2 server and 2 of them is garbd server) We use update-heavy queries in our databases, dealing with a huge tables which some of the tables have over 20 million records. Also we have lots…
user13493257
  • 51
  • 1
  • 4
2
votes
7 answers

Painfully set the sql_mode for vtiger

I couldn't figure out what Vtiger was on about when it asked me to set the php.ini file to error_reporting. Even after the error_reporting had been edited to show; error_reporting = E_WARNING & ~E_NOTICE & ~E_DEPRECATED & ~E_STRICT The CRM still…
cjones
  • 367
  • 1
  • 3
  • 19
2
votes
1 answer

Gitlab CI Runner | Custom mysql conf

I'm trying to set my own mysql conf for Gitlab CI Runner. I found in the documentation how to set my own php.ini : before_script: - cp ci/php.ini /usr/local/etc/php/conf.d/test.ini I didn't find informations about how setting my.cnf, I tried…
Aximem
  • 714
  • 8
  • 27
2
votes
2 answers

Ubuntu 16.04 MariaDb no sample configurations

I have an Ubuntu 16.04 server (VPS), I installed MariaDb 10.1 on it (did it like the doc said). I would like to configure the database server, so innodb can use 2-4GB memory, so I tried to find the sample my.cnf's in /usr/share/mysql/ but not a…
szab.kel
  • 2,356
  • 5
  • 40
  • 74
2
votes
2 answers

Can I edit my.ini or my.cnf file in browser?

I'm working on whmcs and it requires disabling MYSQL strict mode. I searched about it and it says you can find it in my.ini or my.cnf. My problem is that I can't find it in any place in file manager. Can Someone help me find and edit it?
Hamed Atae
  • 183
  • 1
  • 2
  • 8
2
votes
1 answer

How do I find out what my.cnf is being used?

With MySQL, a my.cnf can be used specify configuration properties. MySQL may look in a variety of places to find this file, and if it doesn't find it may use built-in defaults. How do you know what my.cnf is being used?
drusolis
  • 862
  • 9
  • 21
2
votes
1 answer

Mysql Left join not using foreign key

I have a problem executing a simple LEFT JOIN. When I run EXPLAIN SELECT * FROM Feature f LEFT JOIN feature_translations t ON f.id = t.object_id I got the following…
moroine bentefrit
  • 68
  • 7
2
votes
2 answers

utf8 in database - set default_charset in php.ini

I have set utf8 in mysql database now it shows +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client |…
Jeff
  • 235
  • 6
  • 16
2
votes
2 answers

Error in setting MySql Workbench

Operation failed: Couldn't find section [mysqld] in the config file /etc/mysql/my.cnf It is with this error, what is it and how do I fix?
Amauri Júnior
  • 43
  • 1
  • 6
2
votes
2 answers

how to prevent mysql from createing mysql-bin.00000x files?

I see that mysql creates a lot of files that are named like mysql-bin.000001, mysql-bin.000002, mysql-bin.000003 etc. I've found here that my log_bin setting is "ON". I'm wondering how I can set this to off and if that's a smart thing to do. I've…
user936965
2
votes
1 answer

Property access not allowed yet when using mysqli_init(). Trying to skip secure auth in php

I'm trying to skip secure authentication in php. $con= mysqli_init(); mysqli_options( $con, "READ_MYSQLI_DEFAULT_FILE", "/etc/my.cnf" ); mysqli_real_connect( $con, "localhost", ....password,etc... ) When i debug in phpstorm, on the first line,…
Masu
  • 1,568
  • 4
  • 20
  • 41
2
votes
1 answer

How do I undo a MySQL PAGER setting that hides sleeping processes like `\P grep -v Sleep`?

I came across this fancy way to hide sleeping processes from show processlist; mysql> \P grep -v Sleep But how do I reverse this?
Ryan
  • 14,682
  • 32
  • 106
  • 179
1 2 3
…
15 16