Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

MySQL version 8.0 - please also tag with mysql for search purposes.

0
votes
1answer
10 views

Problems Linking the max value of an attribute in a table to its primary Key

I need to extract the order_id with the max number of items, I've figured out how to extract the max value but I'm having problems linking it to the particular order_id. PS: I'm a uni student so ...
0
votes
0answers
9 views

Bizarre MySQL Replication Connection Issue

I am configuring MySQL master-master replication (AKA master-slave replication done twice) between two servers. After I set the master settings on each server (CHANGE MASTER TO master_hos..., etc.) ...
1
vote
1answer
17 views

Cannot set innodb_buffer_pool_size above 1023M in my.ini

Windows server 2012 R2 with 64GB RAM, MySQL 8. The Database is about 5GB. I am using a buffer pool of 1023M, as shown below: innodb_buffer_pool_size=1023M If I enter anything above 1023M e.g. 1024M ...
-3
votes
0answers
78 views

select with where clause not working properly in mysql 8.0 as it is not returning anything though values are there in the single table of the database [closed]

Please follow the images, Here the table verblist contains the value 'beat' in column baseVerb But still on executing select query "SELECT * FROM datavaldb.verblist where baseVerb = 'beat';" It is ...
0
votes
1answer
41 views

What's your data ETL methodology? [closed]

I think this is more like an open question: How do you do the ETL for your company? We are using MySQL as our database management system and we have a production schema. Every month, when we received ...
0
votes
2answers
39 views

Using MySQL 8.0 “Upgrade Checker” on RDS

The MySQL 8.0 Shell came with an "Upgrade Checker". Useful to run before upgrading, as you may detect incompatible issues with your table structure / etc. Running its python version from the shell ...
0
votes
1answer
33 views

How to structure table in MySQL for group chat application? [closed]

I'm making a messaging application, and I need a way to organize and store messages. I was thinking something like a table that had all the group chat IDs and who was in which group chat, but MySQL ...
1
vote
1answer
28 views

How to verify if given user@host with 'password' exists in MySQL 8.0+?

I write sanity check script for an application. One of the tests is supposed to verify that a given user@host with 'password' exists in MySQL. I'm using simple native hash passwords. In MySQL5.7- ...
0
votes
0answers
21 views

MySQL 8 cannot start, when recovering from logs?

Without any reason, MySQL server not working anymore. I don't know any reason why this could happened, and don't know any actions made before this happened. What i did is just make apt update &&...
0
votes
1answer
37 views

SQL query does not recognise derived table

So I've made a simple SQL query: SELECT companyname FROM works w1, ( SELECT companyname,sum(salary) AS sumsal FROM works GROUP BY companyname ...
2
votes
1answer
31 views

Mysql temp table insert from json can't handle null values

The MySql-8 JSON_TABLE function allows you to handle JSON data as if it was a table. I'm trying to use it to populate a temporary table using the generated table but I believe I'm hitting a bug. ...
0
votes
3answers
27 views

MYSQL 8.0 server not found in Workbench directory in Windows 10?

I have upgraded my workbench to 8.0CE and also removed the previous 5.7 MYSQL server as well as Workbench 6.3. This is the directory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE Also when I typed ...
-1
votes
0answers
18 views

Mysql - Failed to connect to MYSQL at localhost:3306

MySQL 5.7 was working well until I added a line in the my.ini. The default character set that will be used when a new schema or table is created and no character set is defined character-set-...
0
votes
1answer
24 views

MySQL 8.0 Triggers Current_User not working

I have this trigger that inserts a row to a table CREATE DEFINER=`root`@`localhost` TRIGGER `user_log_AFTER_INSERT` AFTER INSERT ON `user_log` FOR EACH ROW BEGIN INSERT INTO ...
0
votes
0answers
65 views

Error connecting to mysql-8.0.12 with Sequel Pro 1.1.2

I just installed mysql-8.0.12-macos10.13-x86_64 on Mac v10.13.6, but when I try to connect using Sequel Pro 1.1.2 I got his error and I can't connect to localhost NSInvalidArgumentException -[...
1
vote
1answer
42 views

Install mysql-shell from apt repository

I want to install and configure a high availability cluster for Mysql 8. To automate that, I want to use use apt repository (via ansible). My servers are debian jessy (8) distribution. I succesfully ...
3
votes
1answer
56 views

MySQL creates tables very slow

On my home machine running Ubuntu 18.04 and MySQL version 8.0.12 with better hardware, table creation, database creation and so on are very slow. On my other computer with older hardware (slower SSD), ...
0
votes
0answers
43 views

MySQL creating database really slow

I had a problem on my MySQL server, where creating tables/databases is really slow (had to wait a couple of hours), so I reinstalled the server and MySQL from scratch, but the problem didn't go away. ...
0
votes
2answers
23 views

Where is the cache for the MySQL caching_sha2_password auth plugin stored?

Where is the cache for the new default authentication plugin caching_sha2_password in MySQL 8 stored? I want to know for future reference how to clear it in case I ever run into any problems using it.
4
votes
3answers
276 views

Why mysql remove query cache in 8.0 version?

Why mysql remove query cache in 8.0 version ?
2
votes
1answer
75 views

MySQL 8: Truncate table stuck in `checking permissions` state for minutes

Sometimes but not always truncate table statements get stuck in checking permissions state for several minutes (up to 7-8 minutes). I'm running MySQL 8.0.12 (for Linux on x86_64 (MySQL Community ...
0
votes
1answer
31 views

get row/value by primary key number

I'm writing my own python wrapper on top of official mysqldb connector. I'm trying to design method that would dynamically extract row data knowing KEY ID. SELECT * FROM cameras; +----------+--------...
0
votes
1answer
27 views

MySQL upgrading from 5.7 to 8 - Throwing strange error and won't start up

I followed the instructions on the MySQL web site and got MySQL server 8 mostly installed but it won't launch because it fails pretty quickly during the upgrade process. The apt-get portion installed ...
2
votes
2answers
31 views

unexpected additional columns

in most of my tables, command SELECT column_name FROM information_schema.columns WHERE table_name='table' worked as expected, but in one table i am getting additional tables that i was not expecting....
2
votes
1answer
17 views

column_name ordered same as describe table

I was under impression that default order of columns is internal mysql order but for some reason describe table and selecting column_name gives me compleatly different order. How can I set ORDER BY ...
0
votes
1answer
40 views

MySQL MSI appears to be installing wrong (latest) MySQL version

For compatibility reasons with other software, I'm trying to install MySQL 5.6.40 on Windows 10. Any version from 5.7 onward is incompatible with my other programs. I've been trying to use the MSI ...
1
vote
1answer
155 views

How do I create a point with an SRID in MySQL?

MySQL supports using ST_PointFromText to construct a point with an SRID, ST_PointFromText(wkt[, srid [, options]]) Constructs a Point value using its WKT representation and SRID. This ...
0
votes
0answers
459 views

MySQL: ROW_NUMBER() OVER PARTITION Question

I am looking to essentially recreate the ROW_NUMBER() OVER PARTITION function that I have used in SQL Server Management Studio previously to do the following in MySQL. MySQL doesn't seem to want to ...
3
votes
1answer
231 views

Why does REGEXP_REPLACE concatenate with a previous result?

This looks like strange behaviour, and I get the same on the MySQL command line as via db<>fiddle: create table t(foo varchar(255)); insert into t (foo) values ('the quick brown fox'), ('jumped ...
3
votes
1answer
946 views

MySQL restore lost data after update from 5.7 -> 8.0.11

I have a docker-compose file where I use the official mysql:latest image as my database server. After a docker pull mysql and a docker-compose up the image updated from 5.7 -> 8.0.11 This update ...
-3
votes
1answer
655 views

How to set lowercase_table_name

I've been trying to setup lower_case_table_names for ages in MySQL 8.0 without success. What is the procedure to set this up in 8.0? In previous versions of mysql I was able to override the variable ...
8
votes
1answer
368 views

What happened to MySQL 6 & 7?

With the recent release of MySQL 8, I can't seem to find any information about why version numbers 6 and 7 were skipped. Anyone know?
3
votes
3answers
203 views

High disk IO with MySQL master-master replication

We've been evaluating an active-passive master-master replication setup for our MySQL database, running on version 8.0. While diagnosing some general slowness issues, we were surprised to see very ...
1
vote
1answer
47 views

MySQL test if function is available

Since MySQL 5.8 the function GeomFromText() is no longer available and one should use ST_GeomFromText() instead, which works exactly the same. Progress, of course :-( Ref: https://dev.mysql.com/doc/...