This tag is for the questions related to the version 5.6 of mysql database.
MySQL 5.6 builds on the momentum of 5.5, and Oracle's investment and commitment to MySQL, by delivering better performance and scalability.
Questions tagged [mysql-5.6]
456 questions
72
votes
3 answers
How to solve mysql warning: "InnoDB: page_cleaner: 1000ms intended loop took XXX ms. The settings might not be optimal "?
I ran a mysql import mysql dummyctrad < dumpfile.sql on server and its taking too long to complete. The dump file is about 5G. The server is a Centos 6, memory=16G and 8core processors, mysql v 5.7 x64-
Are these normal messages/status "waiting for…
sherpaurgen
- 3,028
- 6
- 32
- 45
26
votes
13 answers
ERROR 1006 (HY000) Can't create database (errno: 13) MySQL 5.6.12
I am facing problem creating the database and it results in following error.
mysql> show grants for 'admin'@'%';
+---------------------------------------------------------------------------------------------------------------------------------+
|…
hardy_sandy
- 361
- 4
- 6
- 13
25
votes
2 answers
Using "TYPE = InnoDB" in MySQL throws exception
When I try to execute the following SQL in MySQL, I'm getting error:
SQL:
SQL = "CREATE TABLE Ranges (";
SQL += "ID varchar(20) NOT NULL, ";
SQL += "Descriptions longtext NULL, ";
SQL += "Version_Number int NULL, ";
…
Gokul Nath KP
- 15,485
- 24
- 88
- 126
23
votes
4 answers
Using utf8mb4 in MySQL
In order to use 4-byte utf8mb4 in MySQL (5.6.11), I have set the following variables in the my.ini file (my.cnf is not found). This file is located in a hidden folder named Application Data (C:\Documents and Settings\All Users\Application…
Tiny
- 27,221
- 105
- 339
- 599
21
votes
9 answers
Resetting ROOT password in MySQL 5.6
I have been following these instructions for resetting root password for local installation of MySQL 5.6 on Windows 7 laptop.
I stopped the service, created init-file, and ran the following command (as Administrator):
"C:\Program Files\MySQL\MySQL…
PM 77-1
- 12,933
- 21
- 68
- 111
18
votes
6 answers
Setting default value for DATE type column to current date without time part?
NOTE: The question is about DATE type, not Datetime nor Timestamp
How to alter column of date data type to use current date by default?
I saw a lot of examples for datetime (with time part), but not for date. I have tried:
ALTER TABLE `accounting`…
Dmitrij Kultasev
- 5,447
- 5
- 44
- 88
14
votes
1 answer
How to uninstall MySQL 5.6 when installed by brew on macOS?
Installed MySQL by issuing the following commands:
$ brew install mysql56
$ brew services start mysql@5.6
Now I can't access it:
$ mysql -uroot
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Want to…
zseikyocho
- 621
- 2
- 9
- 18
14
votes
2 answers
How to migrate MySQL data directory in docker container?
I have a docker container running MySQL-5.5 with host data volume. I am upgrading my container to MySQL-5.6. I am starting a new container with the same host volume. MySQL was crashing in the container due to the crash of mysql.user table.
[ERROR]…
Gangaraju
- 4,406
- 9
- 45
- 77
11
votes
3 answers
mysql 5.6 adjust varchar length to longer value without table locking
We have a varchar column right now that is 255 chars in length. We're about to up it to 400 using this statement:
ALTER TABLE `resources` CHANGE `url` `url` varchar(400) NOT NULL;
I've read the docs about online ddl which states
Operation …
timsabat
- 2,208
- 3
- 25
- 34
10
votes
3 answers
Using MATCH with OR returns results that satisfy none of the conditions
Using MySQL 5.6, this request
SELECT foo
FROM bar
WHERE groupId = '1'
AND MATCH (foo) AGAINST ('"myQuery"' IN BOOLEAN MODE);
and
SELECT foo
FROM bar
WHERE groupId = '1'
AND foo like '%myQuery%';
returns both correct results, but when I…
egoz
- 354
- 3
- 16
10
votes
3 answers
Sql syntax: select without from clause as subquery in select (subselect)
While editing some queries to add alternatives for columns without values, I accidentally wrote something like this (here is the simplyfied version):
SELECT id, (SELECT name) FROM t
To my surprise, MySQL didn't throw any error, but completed the…
watery
- 5,026
- 9
- 52
- 92
9
votes
4 answers
Install MySQL 5.6 on Ubuntu 20.04
I have a custom app that required MySql 5.6. I was able to install MySql 5.7 on ubuntu 20.04 using this tutorial: https://askubuntu.com/a/1232993
How can I install MySql 5.6 on ubuntu 20.04?
Because the above tutorial only works for MySql 5.7, and I…
Pascut
- 3,291
- 6
- 36
- 64
9
votes
3 answers
How to install MySQL 5.6 on OSX Mojave?
I need to install MySQL 5.6 on my Mac, running under Mojave. (Because AWS Aurora Serverless only allows MySQL 5.6)
That wouldn't be an issue if a .dmg was available, but there are none for MacOS for this particular version, too old I guess?
See…
Vadorequest
- 16,593
- 24
- 118
- 215
9
votes
1 answer
performance issue MySQL 5.7
I've migrated my MySQL Database from 5.6 to version 5.7. Now I got a performance issue.
Specific statement are executed in both versions and I noticed that 5.7 is significant slower. Especially with large amount of Data.
Even a simple select…
OBSolet
- 93
- 1
- 5
9
votes
3 answers
Unable to enable logs in MySQL - error : Found option without preceding group in config file
I am trying to enable logs on my MySQL server but with no success.
What I have done :
1) I have created the log file with the right permissions :
touch /var/log/mysql/mysql.log
chown mysql:mysql /var/log/mysql/mysql.log
2) I have added…
hg8
- 1,082
- 2
- 15
- 28