MySQL Forums - MySQL Shell

util.dump requires mysql.user read priv (no replies)

Krzysztof Wróblewski — Sun, 14 Dec 2025 19:35:26 +0000

Hello,
I would like to propagate using mysql.shell util.dump tools in developers' area (to migrate tables or databases). It's nice tool and it has many advantages... but, I cannot do this because of this error:

ERROR: Unable to check privileges for user 'user'@'localhost'. User requires SELECT privilege on mysql.* to obtain information about all roles.

For specific user, who is not administrator, I cannot give reading mysql schema privilege due security reason.
I don't see also any workaround.

Why for dumping single table or even schema, there is a need read whole mysql schema?

For mysqldump it's not needed.

Any tips how to use these tools by non-administrative accounts?
If not, then it's useless for devs.

Update Catalog through Shell gives error (no replies)

Miguel Ortega — Fri, 07 Feb 2025 16:57:51 +0000

We are trying to automatize the server upgrade process for our environments, as there are many servers. We tried creating a small powershell command that basically does:
C:\Program Files (x86)\MySql\MySql Installer for Windows\MySqlInstallerConsole.exe --update

When running this it starts but we get this:
Running Catalog upgrade on CSC2CWN00006671.CLOUD.KP.ORG
=================== Start Initialization ===================
MySQL Installer is running in Community mode

Attempting to update manifest.
Initializing product requirements
Loading product catalog
Checking for product catalog snippets
Checking for product packages in the bundle
Categorizing product catalog
Finding all installed packages.
Your product catalog was last updated at 4/14/2020 4:14:36 AM
=================== End Initialization ===================

--update is not a supported action.
=================== Start Initialization ===================
MySQL Installer is running in Community mode

Attempting to update manifest.
Initializing product requirements
Loading product catalog
Checking for product catalog snippets
Checking for product packages in the bundle
Categorizing product catalog
Finding all installed packages.
Your product catalog was last updated at 4/14/2020 4:14:36 AM
=================== End Initialization ===================

--update is not a supported action.

Why is it doing this? If we do it manually on the GUI it works fine, we just have to click on Execute twice on the Catalog part.

Why is the --update option not running for older versions? Was there any restrictions?

Issue with Temporary AWS Token Expiration During MySQL Shell dumpInstance to S3 (no replies)

Dmitry Shorokhov — Thu, 07 Nov 2024 09:49:47 +0000

Hello everyone,

I'm encountering an issue with MySQL Shell when using the util.dumpInstance() function to upload data directly to Amazon S3. Specifically, when I run:

mysqlsh -e "util.dumpInstance('$name',{'s3bucketName': '$bucket_name', 'threads': '7', 'bytesPerChunk': '2G'})"

the upload sometimes fails due to AWS temporary tokens expiring before the dump completes. Since AWS temporary tokens have a limited lifespan, this makes it difficult to reliably upload large dumps directly to S3.

It seems that MySQL Shell does not use AWS's official SDK, which would normally handle token renewal for IAM roles and temporary credentials automatically. Without SDK support, we're stuck with manual workarounds, which aren't ideal for long-running operations.

Has anyone found a way to manage or refresh these tokens during a dumpInstance operation to S3? Or is there any chance that Oracle plans to integrate AWS SDK support to make S3 interactions more compatible with temporary tokens and IAM roles?

Thanks in advance for any insights!

MySQL is updating my root password and I cannot change it anymore! (MacOS Sonoma) (no replies)

Victor Vitu — Thu, 04 Jul 2024 20:15:13 +0000

I’m trying to install and setup MySQL on my Machine MacBook Pro M3 Max with Sonoma 14.5 OS but it is not being possible to login anymore. This issue starts to happen after I shutdown the computer and opened it on the next day. It is not being possible to login on MySQL anymore.

When I run the the `mysql_secure_installation` command and try to setup a password, the following access denied error happens:

```sh
$ mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root:
Error: Access denied for user 'root'@'localhost' (using password: YES)
```

I’ve tried to change the password for the root user by executing `sudo mysqld_safe --skip-grant-tables `, but it says that a `mysqld` process already exists.

```sh
$ sudo mysqld_safe --skip-grant-tables

2024-07-04T17:57:49.6NZ mysqld_safe Logging to '/opt/homebrew/var/mysql/Victors-MacBook-Pro.local.err'.
2024-07-04T17:57:49.6NZ mysqld_safe A mysqld process already exists
```

↳ This error is happening even after I kill all of the `mysqld`/`mysql` processes with `sudo kill -9` or `sudo pkill -9 mysqld` or `sudo killall -9 mysqld` or `sudo killall -9 mysqld_safe` or listing all the processes with `ps aux | grep mysql` and killing each one of them manually via `sudo kill -9 `.

So, in the end, I can’t use MySQL at all on my machine. Could someone knows what is the solution or help me with that?

Thanks!
Best regards,

MySQL Shell Syntax Error (no replies)

Brian Hiatt — Wed, 03 Jul 2024 17:20:52 +0000

Oracle Linux
MySQL shell 8.0.35
MySQL shell active (not js)

When I run this command I get a syntax error. Have run it before (on different instance). I studied the syntax and do not see a format issue.

Any ideas?

util.copyInstance('adminlogin@XXX.XXX.XXX.XXX',{dryRun:true, showProgress:true, updateGtidSet: "append", loadIndexes:false, excludeUsers: ["ocidbm"], compatibility: ["strip_restricted_grants", "strip_definers", "create_invisible_pks" ]});

Error is:
ERROR: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'util.copyInstance('adminlogin@XXX.XXX.XXX.XXXX',{dryRun:true, showProgress:tr' at line 1

Obfuscated the login and IP

using mysqlsh migrate mysql from local instance to rds (1 reply)

CHEN XU — Sat, 22 Jun 2024 00:00:45 +0000

old version:5.7.35
rds version:5.7.38

i use util.dumpSchemas to backup local schema ,then i load backup use bellow command util.loadDump("/mydumper/backup/dw",{schema:'dw_test',threads:8,'ignoreVersion':'True'

but i got this "

Target is MySQL 5.7.38-230101-log. Dump was produced from MySQL 5.7.35-log
ERROR: [Worker006]: Query returned fewer rows than expected
ERROR: [Worker002]: Query returned fewer rows than expected
Checking for pre-existing objects...
ERROR: [Worker007]: Query returned fewer rows than expected
ERROR: [Worker004]: Query returned fewer rows than expected
ERROR: [Worker005]: Query returned fewer rows than expected
ERROR: [Worker000]: Query returned fewer rows than expected
ERROR: [Worker003]: Query returned fewer rows than expected
Executing common preamble SQL
ERROR: [Worker001]: Query returned fewer rows than expected
No data loaded.
Total duration: 0 sec
8 errors and 0 warnings were reported during the load."

what does this mean " Query returned fewer rows than expected",how can I get more detail about this?

Backup to Minio (no replies)

Mahesh Doraiswamy — Thu, 20 Jun 2024 11:41:12 +0000

Trying to take a backup of MySQL to a self hosted Minio server. Enabled SSL on Minio server with self signed certificate.

mysqlsh command
util.dumpInstance("repo3",{s3BucketName: "mysql-bucket", s3EndpointOverride: "https://10.1.1.1:9000",s3CredentialsFile:"/mysqlsh/.aws/credentials",s3ConfigFile:"/mysqlsh/.aws/config",s3Profile: "default", threads: 4})

error
Util.dumpInstance: SSL certificate problem: self signed certificate (CURLcode = 60) (RuntimeError)

Tried setting ca_bundle in .aws/config file and also AWS_CA_BUNDLE and is not helping. Any suggestions on how to overcome this certificate problem?

MySQL Shell Scripting (no replies)

Simon Tann — Wed, 19 Jun 2024 09:31:36 +0000

Hi Guys

Background - I took over from my predecessor two years and have been using his python scripts and writing bash scripts to perform specific tasks on our DB's such as DB refreshes, creation of db users, etc.

We are now upgrading to MySQL 8.0.37 Replicasets and then to InnoDB Clustersets, so I want to learn MySQL Shell, and at the same time, I would like to enforce some consistency. We are also looking at modularising our scripts so that they can be called individually to do stuff like stop and start the DBs to make automating tasks easier.

So, while there is obviously more than one way to skin a cat, am I wondering if I am torturing myself for no reason for trying to script everything in javascript for use with MySQL Shell?

Is that what you folks would do, or would you instead create scripts using other languages (bash, etc) and call MySQL Shell from those?

Finally, are there any resources/tutorials that are helpful for scripting in MySQL Shell, as my Google results always return the wrong results due to the preponderance of articles about MySQL, Shell and Scripting that is not MySQL Shell Scripting!

Thanks in advance!

Problema al conectar a MySQL desde la consola: Error 2002 (HY000) (no replies)

Luis espinoza — Fri, 12 Apr 2024 16:56:33 +0000

Título del tema: Problema al conectar a MySQL desde la consola: Error 2002 (HY000)

Descripción del problema:
Hola a todos,

Recientemente he tenido dificultades para conectarme a mi servidor MySQL desde la consola en mi sistema Ubuntu. Anteriormente, podía conectarme sin problemas, pero ahora estoy recibiendo un error que dice:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Contexto:

Estoy utilizando Ubuntu como sistema operativo.
Tengo instalado MySQL Community Server versión 8.0.36.
No he realizado cambios significativos en la configuración de MySQL recientemente.
Puedo conectarme a MySQL sin problemas utilizando herramientas como MySQL Workbench y phpMyAdmin.
He verificado que el servidor MySQL esté en ejecución y que la configuración del socket en el archivo mysqld.cnf esté configurada correctamente.
He reiniciado el servicio MySQL, pero el problema persiste.
Información adicional:

Ejecutar sudo netstat -lnp | grep mysql muestra que MySQL está escuchando en el puerto 3306 y en la dirección localhost.
Ejecutar ls -la /tmp/mysql.sock muestra que el archivo de socket /tmp/mysql.sock no está presente en la ubicación esperada.
He revisado la configuración del cliente MySQL y parece estar configurada correctamente.
Acciones realizadas hasta ahora:

He verificado la configuración de MySQL tanto del servidor como del cliente.
He intentado reiniciar el servicio MySQL.
He revisado los permisos del directorio /tmp/ y /var/run/mysqld/.
He investigado otros posibles problemas en los registros de errores de MySQL.
Solicitud de ayuda:
Agradecería cualquier sugerencia o consejo sobre cómo solucionar este problema y restaurar la capacidad de conectarme a MySQL desde la consola. ¿Hay algo más que deba investigar o intentar para resolver este problema?

¡Gracias por su ayuda!

MySQL Upgrade Checker issue (2 replies)

Nick Gill — Fri, 17 May 2024 11:06:52 +0000

I'm getting a lot of spurious warnings in using the migration checker on my 5.7 DB (moving up to 8.3)... Here is just one example;

mydb.quotedJobs.jobCreated - column has zero default value: 0000-00-00
00:00:00

| quotedJobs | CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `quotedJobs` AS select `quotes`.`job` AS `jobId`,`quotes`.`created` AS `quoteCreated` on((`quotes`.`provider` = `providers`.`id`))) left join `providerRatings` on((`quotes`.`provider` = `providerRatings`.`providerId`))) | utf8mb4 | utf8mb4_general_ci |

The problematic field originates from the `jobs` table (also reduced for simplicity);

| jobs | CREATE TABLE `jobs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `createdNdx` (`created`) USING BTREE,
) ENGINE=InnoDB AUTO_INCREMENT=2891 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC |

There doesn’t seem to be any risk of a zero-date being created, given the USE of DEFAULT. I can also confirm there is not a single zero-date in the entire DB… however the checker still hundreds of these warnings.

Is this a bug, or is it expected behaviour? Presumably, I can simply ignore them, as I don't see there being any risk of a zero date ever being entered, unless by an intentionally and deliberate INSERT by a dev.

I'd prefer to reduce my warnings to zero, if possible, but I don't see how in this particular instance.

Thanks for any help in this matter. N

any environment like MYSQL_UNIX_PORT to specify socket path (1 reply)

Bing Ma — Wed, 20 Mar 2024 07:55:22 +0000

the path of my socket is customed, not in the default path, when I connect to database via localhost, I wish have a environment like MYSQL_UNIX_PORT to specify socket location

Newly installed MySQL Shell on win 11 (no replies)

Jon Jacobs — Tue, 12 Mar 2024 01:12:54 +0000

I just installed MySQL 8.3 on my brand new Win 11 computer. I then installed the shell. I entered it with mysqlsh on command line. It prompted me with MySQL JS>
Now what? It would not accept any commands. I presume I need to connect with password or something. I tried connect and session, but it did not like those commands either. What should I do to get started?

On my older win 8.1 computer I interfaced quite nicely with HeidiSQL, but I thought I would try the shell this time. Or should I install HeidiSQL or some other interface?

how to backup to minio (no replies)

Bing Ma — Tue, 24 Oct 2023 09:28:05 +0000

when use utils.dumpInstance(), may I backup to minio?

Mysql Router services not start automatically (no replies)

sabah sawor — Thu, 19 Oct 2023 02:49:55 +0000

Hi All,

I have an issue with getting Bootstrap for MySQL router to work properly after rebooting the host.
every time I restart my computer I have to run ./start.sh file to get mysql router service working.
Any idea, how to fix that?.
My file is located in /usr/share/joyrouter/

Syslog Messages (no replies)

Srinivas K — Sun, 08 Oct 2023 05:07:29 +0000

With SYSLOG integration we can view the QUERY from client side, however we do not see the response code in the log, for instance, if a incorrect SQL query is run a MYSQL error is printed to the console , however there is nothing in the syslog message to indicate if the query errored out or successful , is there any way to capture the response code in the message ?

Building mysql-shell antlr4 runtime issue (no replies)

Julio Suarez — Fri, 29 Sep 2023 21:16:24 +0000

HI All,

Building mysql-shell, I get the error below. Issue is, I'm including the runtime dir, but it still doesn't seem to work. To get the runtime dir, I am building antlr4 which puts its runtime dir at ~/antlr4/runtime.

Setting antlr4-runtime_DIR like below still yields the error (I've tried both absolute path and relative path).

Not sure what I'm doing wrong. I've also tried package installs of antlr4.

cmake antlr4-runtime_DIR=~/antlr4/runtime .. -DMYSQL_SOURCE_DIR=/home/ubuntu/mysql-server -DMYSQL_BUILD_DIR=/home/ubuntu/mysql-server/bld -DPACKAGE_YEAR=2023 -DHAVE_PYTHON=1 -DCMAKE_CXX_FLAGS="-Wno-error=maybe-uninitialized" -DCMAKE_C_FLAGS="-Wno-error=maybe-uninitialized"

```
CMake Error at CMakeLists.txt:628 (find_package):
By not providing "Findantlr4-runtime.cmake" in CMAKE_MODULE_PATH this
project has asked CMake to find a package configuration file provided by
"antlr4-runtime", but CMake did not find one.

Could not find a package configuration file provided by "antlr4-runtime"
with any of the following names:

antlr4-runtimeConfig.cmake
antlr4-runtime-config.cmake

Add the installation prefix of "antlr4-runtime" to CMAKE_PREFIX_PATH or set
"antlr4-runtime_DIR" to a directory containing one of the above files. If
"antlr4-runtime" provides a separate development package or SDK, be sure it
has been installed.

```

How to copy a MySQL instance ? (no replies)

Edwin Desouza — Thu, 28 Sep 2023 22:24:47 +0000

How to copy a MySQL instance ?
- https://blogs.oracle.com/mysql/post/how-to-copy-a-mysql-instance

Custom Log (no replies)

Srinivas K — Thu, 14 Sep 2023 03:25:59 +0000

We are able to log the SQL queries, however we would like to customize the Log so that the OS User ID will be appended to the log message

for instance the current SQL log output

2023-09-14 03:12:25: Info: sql: tid=2736669664: SQL: select * from cust_master limit 2

If we have way to include the OS User ,in the log it will be great for auditing

2023-09-14 03:12:25: User: ${USER} Info: sql: tid=2736669664: SQL: select * from cust_master limit 2

The ${USER} is the os env system User , any thoughts on this ?

ERROR: 3948: Loading local data is disabled (no replies)

Kennet Hafstedt — Sun, 27 Aug 2023 19:22:35 +0000

Hi all,

I have looked all over the internet, in numerus forums and followed all kinds of suggestions, but I'm still stuck. I keep on getting the same message:

ERROR: 3948: Loading local data is disabled; this must be enabled on both the client and server sides

I've done: SET GLOBAL local_infile=1;

Then:SHOW GLOBAL VARIABLES LIKE 'local_infile';

I get:

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | ON |
+---------------+-------+

Then after having reconnected to the server I get:

ERROR: 3948: Loading local data is disabled; this must be enabled on both the client and server sides

I think I'm going nuts on this issue...

Most of you guys have seen this and left it behind you, but maybe you recall something that might help me out of this spot.

By the way here is the sql-line I've tried to use when loading data from a txt file :-)

LOAD DATA LOCAL INFILE '/Users/kenne/OneDrive/Skrivbord/ArtikelDB.txt' INTO TABLE dehouse;

Thanks!

a question about bulk importing .sql files (no replies)

xie xie — Tue, 15 Aug 2023 05:51:46 +0000

I have serveral .sql files,i want to use mysqlshell to bulk import those .sql files into mysql，so i first connect root@localhost:3306,then i use the command:"\source C:\sip\main.sql" to import,but mysqlshell shows:"syntaxerror unexpected identifier ‘C’",the main.sql file consist of many lines like"source C:\sip\001.sql","source C:\sip\002.sql" and so on.mysqlshell‘s version is 8.0.34，mysql's version is 5.7.43.0.
what is the problem?how to solve it?thank you.

inability to configure instance or adopt existing async replication (1 reply)

Ivan Cauchi — Mon, 07 Aug 2023 06:15:58 +0000

I have 3 machines, let's call them Primary, Secondary 1 and Secondary 2. The Primary and Secondary 1 have an existing asynchronous replication that was set up manually that is already in production. Initially I was going to create a new replication from Primary to Secondary 2 using mysqlsh and InnoDB ReplicaSet, and leave the existing replication from Primary to Secondary 1 as is.

After installing mysql-shell and mysql-router to Primary and Secondary 2 from the MySQL repository, on the Primary I established a connection and attempted to configure the instance using the template:

dba.configureReplicaSetInstance('root@rs-1:3306', {clusterAdmin: "'rsadmin'@'rs-1%'"});

I got the below error message:

<<
Dba.configureReplicaSetInstance: This function is not available through a session to an instance belonging to an unmanaged asynchronous replication topology (RuntimeError)
>>

I thought, fair enough, I do have an existing replication set up, and therefore a managed and unmanaged replication topology cannot coexist. So logically, I thought I needed to bit the bullet and adopt the existing topology first.

So, I installed mysql-shell and mysql-router as well on Secondary 1 as well. I went back to Primary and connected to the instance using mysqlsh and issued the command from the template:

<<
A new replicaset with the topology visible from ':3306' will be created.

* Scanning replication topology...
** Scanning state of instance :3306

* Discovering async replication topology starting with db5:3306
Discovered topology:
- :3306: uuid= read_only=no

* Checking configuration of discovered instances...

This instance reports its own address as :3306
:3306: Instance configuration is suitable.

* Checking discovered replication topology...
Dba.createReplicaSet: Target server is not part of an async replication topology (MYSQLSH 51151)
>>

I guess my observation is that Primary is either part of an async replication topology, or it isn't! I'm at a loss of what to do next. I'd be grateful if anyone can point me in the right direction.

Vulnerabilities on python packages (5 replies)

Francisco de Paz — Fri, 26 Jan 2024 15:20:52 +0000

Hi team,

Running a vulnerabilities scan on the latest mysql-shell release for linux, mysql-shell-8.0.33-linux-glibc2.12-x86-64bit.tar.gz, returned a few CVEs related to a couple of python packages: cryptography (CVE-2023-0286, CVE-2023-23931, and GHSA-5cpq-8wj7-hf2v) and setuptools (CVE-2022-40897).

These 2 python packages are included as libs in the release and I understand they should be considered as fixed requirements. That said, could you confirm whether mysql-shell is indeed affected by the related vulnerabilities and if so, are there any plans to update the related dependencies?

Thanks for your time!

MySQL Shell 8.0.33: InnoDB ReplicaSet/Cluster/ClusterSet (no replies)

Edwin Desouza — Thu, 27 Apr 2023 02:39:14 +0000

MySQL Shell 8.0.33: InnoDB ReplicaSet/Cluster/ClusterSet

https://blogs.oracle.com/mysql/post/announcing-mysql-shell-8033

mysqlsh parallel import error (5 replies)

Sanjay Gupta — Wed, 01 Mar 2023 22:11:47 +0000

~ % cat test3.csv
0,0,0,"run_intf_filter is handling Data Source ID 15.",2023-01-25 02:32:38
0,0,0,"No records to filter for 15!",2023-01-25 02:32:38
0,0,0,"run_intf_filter is handling Data Source ID 17.",2023-01-25 02:32:38
0,0,0,"No records to filter for 17!",2023-01-25 02:32:38
0,0,0,"run_intf_filter is handling Data Source ID 21.",2023-01-25 02:32:38
0,0,0,"Calling INTF_FILTER.process_cddb2_interface()...",2023-01-25 02:32:38
0,0,0,"run_intf_filter is handling Data Source ID 23.",2023-01-25 02:32:38
0,0,0,"Calling INTF_FILTER.process_cddb2_interface()...",2023-01-25 02:32:38
0,0,0,"run_intf_filter is handling Data Source ID 47.",2023-01-25 02:32:38
0,0,0,"No records to filter for 47!",2023-01-25 02:32:38

mysqlsh --uri=mysql://root:xxxx@localhost:3306 -- util import-table test3.csv --schema=test table=sanjay_test1 --linesTerminatedBy="\n" --fieldsTerminatedBy=","

WARNING: Using a password on the command line interface can be insecure.
ERROR: Argument options: Separators cannot be the same or be a prefix of another.

Any idea why mysqlsh is giving error ? I have tried various combinations and unable to figure out correct syntax .

This works fine from mysql command line....

LOAD DATA INFILE '/Users/sagupta/test3.csv'
INTO TABLE sanjay_test
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

Introducing the MySQL REST Service (no replies)

Edwin Desouza — Wed, 15 Feb 2023 22:38:58 +0000

Introducing the MySQL REST Service:
- https://blogs.oracle.com/mysql/post/introducing-the-mysql-rest-service

Mysqlsh encoding output (no replies)

Luis Mendoza — Wed, 11 Jan 2023 09:21:26 +0000

Hello,

I'm working with 8.0.23-commercial for Linux on x86_64.

I work with a database containing tables that use the latin1 CHARACTER SET. This causes queries' output to be strangely encoded, specifically non ASCII characters (i.e. 'é').

Consider the following example :

CREATE TABLE `my_test_table` ( `idx_table` bigint(10) unsigned NOT NULL,`myColumn` enum('autorisé','bloqué') DEFAULT NULL, PRIMARY KEY (`idx_table`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='My comment contains é à and other non ASCII characters';

If I insert into this table via mysqlsh :
INSERT INTO my_test_table VALUES(0,'autorisé');
it works as expected.

However while using any data already inserted in my database :
INSERT INTO my_test_table SELECT idx_old_table, old_column from old_table limit 1;
I get "Warning (code 1265): Data truncated for column 'myColumn' at row 1"

The same goes for reading data already inserted in to already existing tables :
SELECT idx_old_table, old_column FROM old_table;
would ouptu something like this :
{
"idx_old_table": 421879389,
"old_column": "autoris▒e"
}

How can I go about working with a database like this with mysqlsh command prompt? Why does mysqlsh encodes differently both latin1 character sets?

Addendum, I tried hexing the output of my old table and then rencoding the result as latin1 and it does give me an accented correct version, so the data in my table is correct.

PS: does this forum use any syntax hilighting supporting format?

MySQL 8.0: How to display long transactions (no replies)

Edwin Desouza — Tue, 20 Dec 2022 17:04:39 +0000

https://blogs.oracle.com/mysql/post/mysql-80-how-to-display-long-transactions

How to dissolve an existed ClusterSet ? (1 reply)

Dee Wu — Wed, 14 Dec 2022 03:20:59 +0000

Hi ,
How to dissolve a ClusterSet ? I've searched all the document named 《MySQL Shell API 8.0.31》(https://dev.mysql.com/doc/dev/mysqlsh-api-javascript/8.0/classmysqlsh_1_1dba_1_1_dba.html), but found nothing. Is it not support yet ?

How to dissolve a ClusterSet ? (no replies)

Dee Wu — Sat, 10 Dec 2022 00:31:22 +0000

Hi ,
How to dissolve a ClusterSet ? I have searched all the 《MySQL Shell API 8.0.31》(https://dev.mysql.com/doc/dev/mysqlsh-api-javascript/8.0/), but I haven't found the Methods to do this. Is it not supported right now ?

Generating Slow Query Log with MySQL Shell (no replies)

Edwin Desouza — Mon, 07 Nov 2022 19:40:10 +0000

Generating Slow Query Log with MySQL Shell
- https://lefred.be/content/generating-slow-query-log-with-mysql-shell/