my.cnf Questions
5
Solved
I have a mysql 5.7 docker container. When I run the mysql command:
SELECT now();
It shows the time -3 hours to my current time (which is logical). I want to set the time zone in a config file. F...
Hedvig asked 21/4, 2018 at 19:43
5
Solved
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...
15
Solved
I am not sure how to fix this:
dyn-72-33-214-45:python mona$ sudo /usr/local/mysql/bin/mysqld stop
2014-09-06 09:49:04 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use -...
3
Solved
Whenever i fire this query from one of the mysql client (emma):
CREATE TABLE `tbl_mappings` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`private_id` int(11) unsigned NOT NULL,
`name` tinyt...
2
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 wan...
3
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, wh...
7
Solved
In MySQL you can set a session variable called time_zone to change the timezone. This is useful e.g. when looking at timestamps from another country. Here is an example:
mysql> select now();
+-...
3
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_SY...
Canaliculus asked 15/10, 2020 at 20:12
6
Solved
I've updated the my.cnf file of my database with the following line: max_connections=200. I stopped and started the mysql service after that so that the changes would take effect.
But for some rea...
5
Solved
I'm trying to connect to my DB in Ubuntu remotely but I receive error message when trying to mysql -u root -p:
Found option without preceding group in config file: /etc/mysql/my.cnf at line: 1
...
9
Solved
The same question is repeated again and again and i am another one repeating this question .
I have already set up my mysql server .
Its location is C:\Program Files\MySQL\MySQL Server 5.5
but i...
Tratner asked 6/12, 2011 at 17:20
3
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 (usin...
2
Solved
I'm trying to enable Slow Query Logging on mysql 5.7 and getting this error:
2016-04-27T14:55:51.934612Z 0 [ERROR] unknown variable 'log-slow-queries=/var/log/mysql-query.log'
2016-04-27T14:55:51...
Myelencephalon asked 27/4, 2016 at 15:8
5
How to configure two different port for MySQL on same machine? I know that default port is 3306. But I also want to configure 3307 and 3308. Is it possible?
One bonus question with current one ;)
...
1
Solved
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 t...
1
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...
1
edit9: Is it a possibility that I'm simply missing a few permissions on folders? I'd really, REALLY appreciate some more suggestions..
edit3: As this post did not get enough replies and it is abso...
1
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/m...
3
I am attempting to move a mysql db onto an upgraded server with a newer version of ubuntu running (15.04), and after installing LAMP, I went to edit the bind address in the my.cnf file. The below i...
3
Solved
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 t...
Caul asked 17/1, 2014 at 3:56
2
Solved
I am kind of hoping that someone might be able to offer some assistance with optimizing a my.cnf file for an extremely high volume mysql database server.
Our architecture is as follows:
Mem...
Eric asked 5/6, 2012 at 21:27
1
Solved
Why can't I use slow_query_log on MySQL 5.6 on CentOS 6.4?
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
...
## Logging
## *** THESE LOGS WORK JUST FINE ***
log_error = /var/l...
Rahel asked 22/11, 2013 at 4:18
3
Solved
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 th...
Midi asked 25/5, 2011 at 17:14
2
Solved
In short, what configuration values does MySQL use if there is no my.cnf?
I'm running MySQL on Slackware. I've been using it for a while with ISAM and InnoDB tables. I never configured a my.cnf fi...
1
Solved
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 file:
[client]
default-character-set=utf8
[mysql]
...
Analgesia asked 11/1, 2012 at 16:37
1 Next >
© 2022 - 2024 — McMap. All rights reserved.