... echo "UPDATE mysql.user SET host='%' WHERE user='root'; FLUSH PRIVILEGES;" | mysql -S /var/run/mysqld/mysqld_13307.sock -uroot mysql: [Warning] Using a password on the command line interface can be insecure. echo 'SELECT host,user,plugin,password_last_changed FROM mysql.user;' | mysql -S /var/run/mysqld/mysqld_13307.sock -uroot -t mysql: [Warning] Using a password on the command line interface can be insecure. +-----------+----------------------------+-----------------------+-----------------------+ | host | user | plugin | password_last_changed | +-----------+----------------------------+-----------------------+-----------------------+ | % | root | caching_sha2_password | 2025-04-30 10:19:17 | | localhost | mysql.infoschema | caching_sha2_password | 2025-04-30 10:19:13 | | localhost | mysql.pxc.internal.session | caching_sha2_password | 2025-04-30 10:19:13 | | localhost | mysql.pxc.sst.role | caching_sha2_password | 2025-04-30 10:19:13 | | localhost | mysql.session | caching_sha2_password | 2025-04-30 10:19:13 | | localhost | mysql.sys | caching_sha2_password | 2025-04-30 10:19:13 | | localhost | percona.telemetry | caching_sha2_password | 2025-04-30 10:19:15 | +-----------+----------------------------+-----------------------+-----------------------+ mysqlshow -S /var/run/mysqld/mysqld_13307.sock -uroot mysqlshow: [Warning] Using a password on the command line interface can be insecure. +--------------------+ | Databases | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ kill -15 332245 ################################################################################ ################################################################################ # So wird das BDMS behandelt: > service mysql_port@13307.bootstrap start > service mysql_port@13307.bootstrap status > service mysql_port@13307.bootstrap stop > service mysql_port@13307 start > service mysql_port@13307 status > service mysql_port@13307 stop > mysqlshow -S /var/run/mysqld/mysqld_13307.sock > echo 'SELECT host,user,plugin,password_last_changed,authentication_string FROM mysql.user;' | mysql -S /var/run/mysqld/mysqld_13307.sock -t > echo "SHOW VARIABLES LIKE '%ssl%';" | mysql -S /var/run/mysqld/mysqld_13307.sock -t > echo "SHOW VARIABLES WHERE variable_name IN ('hostname','wsrep_node_name','wsrep_cluster_name','port','ssl_ca','ssl_cert','ssl_key'); SHOW STATUS LIKE '%Ssl_server_not_%';" | mysql -S /var/run/mysqld/mysqld_13307.sock -t > mysqlshow --ssl-ca=/etc/mysql/ca.pem --ssl-mode=VERIFY_CA -S /var/run/mysqld/mysqld_13307.sock zum kompletten und unwiederbringlichen entfernen dieser MySQL-DBMS-Instanz, ist nur dieses Kommando nötig: /root/bin/Neue_MySQL-Instanz_löschen.sh 13307 real 0m32.173s user 0m4.630s sys 0m1.172s