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]
936 questions
206
votes
16 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,719
- 5
- 25
- 41
149
votes
10 answers
MySQL JOIN the most recent row only?
I have a table customer that stores a customer_id, email and reference. There is an additional table customer_data that stores a historical record of the changes made to the customer, i.e. when there's a change made a new row is inserted.
In order…
bcmcfc
- 25,966
- 29
- 109
- 181
103
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
- 5,350
- 8
- 39
- 65
88
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
- 3,085
- 5
- 27
- 31
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
63
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
- 916
- 1
- 6
- 10
55
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
- 553
- 1
- 4
- 5
47
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
- 18,680
- 13
- 103
- 118
36
votes
3 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
- 17,619
- 9
- 53
- 81
29
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,965
- 4
- 18
- 26
28
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,174
- 18
- 82
- 144
25
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
- 981
- 3
- 14
- 23
25
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,251
- 1
- 9
- 8
24
votes
6 answers
How to install and start MySQL 5.7 on macOS BigSur (Apple Silicon) with Homebrew?
I need a specific version of MySQL (5.7) to be installed on my MacBook with M1.
I'm trying to do that with Homebrew.
brew install mysql@5.7
The output:
We've installed your MySQL database without a root password. To secure it run:
…
Vitalii
- 383
- 1
- 2
- 8
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
- 7,087
- 14
- 68
- 143