This tag is for questions related to the MySQL database, version 5.7.
MySQL 5.7 builds on the momentum of 5.6, and Oracle's investment and commitment to mysql, by delivering better performance and scalability.
Important Links:
Questions tagged [mysql-5.7]
766 questions
174
votes
14 answers
How do I turn off the mysql password validation?
It seems that I may have inadvertently loaded the password validation plugin in MySQL 5.7. This plugin seems to force all passwords to comply to certain rules.
I would like to turn this off.
I've tried changing the validate_password_length variable…
Alex Ryan
- 3,181
- 5
- 20
- 36
82
votes
14 answers
What is the default root pasword for MySQL 5.7
Cannot login to MySQL database after fresh install with root ID and empty/no password like other older MySQL versions do
Ryan
- 2,927
- 5
- 23
- 29
66
votes
2 answers
How to update JSON data type column in MySQL 5.7.10?
I have started using MySQL 5.7.10 recently and I am liking the native JSON Data type a lot.
But I ran into a problem when it comes to updating a JSON type value.
Questions:
Below is the table format, here I want to add 1 more key in JSON data column…
ʞɹᴉʞ ǝʌɐp
- 4,164
- 5
- 34
- 59
63
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…
satch_boogie
- 2,498
- 3
- 25
- 39
54
votes
7 answers
Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
I installed MySQL community server 5.7.10 using binary zip. I extracted the zip in c:\mysql and created the data folder in c:\mysql\data. I created the config file as my.ini and placed it in c:\mysql (root folder of extracted zip). Below is the…
BValluri
- 816
- 1
- 6
- 10
32
votes
12 answers
How to map a JSON column with H2, JPA, and Hibernate
I use in application MySQL 5.7 and I have JSON columns. When I try running my integration tests don't work because the H2 database can't create the table. This is the error:
2016-09-21 16:35:29.729 ERROR 10981 --- [ main]…
earandes
- 323
- 1
- 3
- 5
29
votes
2 answers
MySQL select where JSON field property has value
How to write a basic MySQL query that has a WHERE on a property within a JSON data-type field? I don't see basic where clause q for json fields on SO.
Something like this, but of course these dont work:
SELECT * from my_table where meta_data->name =…
Andrew
- 13,934
- 8
- 78
- 93
28
votes
2 answers
How to clean or resize the ibtmp1 file in MySQL?
MySQL 5.7 introduces a new file ibtmp1 for storing temporary data in InnoDB to increase the performance.
But I have noted that its size increases continuously. On my db server its sizes increases to 92GB.
Is there any way of reducing size or…
Aman Aggarwal
- 14,458
- 9
- 48
- 71
24
votes
4 answers
Homebrew, MySQL 8 support
Anyone have the inside scoop on when Homebrew will be updated to support MySQL 8's first general release (8.0.11)? I can't seem to find it by searching, but I bet someone here knows :)
Pete_1
- 931
- 3
- 12
- 22
24
votes
3 answers
MySQL 5.7 show_compatibility_56
Recently, I decided to get a VPS server and host my own forums as we grew too big for your average shared hosting platform. I thought it would be easy to setup and get going, and it has been for the most part, but I have hit a brick wall with a…
CarlM24
- 1,191
- 1
- 5
- 8
19
votes
7 answers
Poor whereHas performance in Laravel
I want to apply a where condition to relation. Here's what I do:
Replay::whereHas('players', function ($query) {
$query->where('battletag_name', 'test');
})->limit(100);
It generates the following query:
select * from `replays`
where exists (
…
Poma
- 8,118
- 16
- 59
- 137
19
votes
5 answers
Why does COUNT() show only one row of table?
I have the following table pet in the database menagerie:
+--------+-------------+---------+------+------------+------------+
| name | owner | species | sex | birth | death …
user31782
- 5,979
- 8
- 54
- 117
19
votes
3 answers
Invalid JSON text in argument 2 - json_contains in MySQL 5.7.8
I have a database with one column that is JSON of strings (ex. ["ART","LIT"], etc.). I want to search it using json_contains.
However, when I try:
json_contains(\`column_name`,"ART")
It errors saying:
Invalid JSON text in argument 2 to…
Alex Beals
- 1,365
- 3
- 14
- 24
17
votes
7 answers
How to create a six character password in MySQL 5.7
I need to create a user with a six character password in new MySQL on my mac. I know that the lowest setting in 5.7 will allows only eight characters. Is there any way to go around that?
I type in CREATE USER 'newsier'@'localhost' IDENTIFIED BY…
user3703723
- 219
- 1
- 2
- 11
15
votes
2 answers
Where is MySQL 5.7 my.cnf file?
In Ubuntu I had my.cnf file of MySQL 5.6 in /etc/my.cnf. But I can't find the same file of MySQL 5.7. From where can I find that?
I did a find in entire / (root). But I couldn't find it anywhere. Any clues?
I'm trying to set max_connections value.
Bee
- 11,225
- 8
- 39
- 68