Bo's Oracle Station › 博客首页 ›Oracle技术› Oracle云、Linux、MySQL和Java › 查看内容

【博客文章2026】MySQL 9.x数据库管理技巧---给初学者的建议4：在线帮助系统、mysqladmin和mysql-workbench

2026-3-13 07:27| 发布者: admin| 查看: 191| 评论: 0|原作者: Bo Tang

摘要: 通过实验，对MySQL 9.6的在线帮助系统、mysqladmin和mysql-workbench进行详细介绍

Author: Bo Tang

1. 总的帮助：

登录Mysql客户端，执行：

mysql> help contents

You asked for help about help category: "Contents"

For more information, type 'help ', where is one of the following

categories:

Account Management

Administration

Components

Compound Statements

Contents

Data Definition

Data Manipulation

Data Types

Functions

Geographic Features

Help Metadata

Language Structure

Loadable Functions

Plugins

Prepared Statements

Replication Statements

Storage Engines

Table Maintenance

Transactions

Utility

2. 查看Account Management这类帮助：

mysql> help Account Management

You asked for help about help category: "Account Management"

For more information, type 'help ', where is one of the following

topics:

ALTER RESOURCE GROUP

ALTER USER

CREATE RESOURCE GROUP

CREATE ROLE

CREATE USER

DROP RESOURCE GROUP

DROP ROLE

DROP USER

GRANT

RENAME USER

REVOKE

SET DEFAULT ROLE

SET PASSWORD

SET RESOURCE GROUP

SET ROLE

3. 查看其中SET PASSWORD的帮助：

mysql> help set password

Name: 'SET PASSWORD'

Description:

Syntax:

SET PASSWORD [FOR user] auth_option

[REPLACE 'current_auth_string']

[RETAIN CURRENT PASSWORD]

auth_option: {

= 'auth_string'

| TO RANDOM

}

The SET PASSWORD statement assigns a password to a MySQL user account.

The password may be either explicitly specified in the statement or

randomly generated by MySQL. The statement may also include a

password-verification clause that specifies the account current

password to be replaced, and a clause that manages whether an account

has a secondary password. 'auth_string' and 'current_auth_string' each

represent a cleartext (unencrypted) password.

*Note*:

Rather than using SET PASSWORD to assign passwords, ALTER USER is the

preferred statement for account alterations, including assigning

passwords. For example:

ALTER USER user IDENTIFIED BY 'auth_string';

*Note*:

Clauses for random password generation, password verification, and

secondary passwords apply only to accounts that use an authentication

plugin that stores credentials internally to MySQL. For accounts that

use a plugin that performs authentication against a credentials system

that is external to MySQL, password management must be handled

externally against that system as well. For more information about

internal credentials storage, see

https://dev.mysql.com/doc/refman/9.1/en/password-management.html.

The REPLACE 'current_auth_string' clause performs password

verification. If given:

o REPLACE specifies the account current password to be replaced, as a

cleartext (unencrypted) string.

o The clause must be given if password changes for the account are

required to specify the current password, as verification that the

user attempting to make the change actually knows the current

password.

o The clause is optional if password changes for the account may but

need not specify the current password.

o The statement fails if the clause is given but does not match the

current password, even if the clause is optional.

o REPLACE can be specified only when changing the account password for

the current user.

For more information about password verification by specifying the

current password, see

https://dev.mysql.com/doc/refman/9.1/en/password-management.html.

The RETAIN CURRENT PASSWORD clause implements dual-password capability.

If given:

o RETAIN CURRENT PASSWORD retains an account current password as its

secondary password, replacing any existing secondary password. The

new password becomes the primary password, but clients can use the

account to connect to the server using either the primary or

secondary password. (Exception: If the new password specified by the

SET PASSWORD statement is empty, the secondary password becomes empty

as well, even if RETAIN CURRENT PASSWORD is given.)

o If you specify RETAIN CURRENT PASSWORD for an account that has an

empty primary password, the statement fails.

o If an account has a secondary password and you change its primary

password without specifying RETAIN CURRENT PASSWORD, the secondary

password remains unchanged.

For more information about use of dual passwords, see

https://dev.mysql.com/doc/refman/9.1/en/password-management.html.

SET PASSWORD permits these auth_option syntaxes:

o = 'auth_string'

Assigns the account the given literal password.

o TO RANDOM

Assigns the account a password randomly generated by MySQL. The

statement also returns the cleartext password in a result set to make

it available to the user or application executing the statement.

For details about the result set and characteristics of randomly

generated passwords, see

https://dev.mysql.com/doc/refman/9.1/en/password-management.html#rand

om-password-generation.

*Important*:

Under some circumstances, SET PASSWORD may be recorded in server logs

or on the client side in a history file such as ~/.mysql_history, which

means that cleartext passwords may be read by anyone having read access

to that information. For information about the conditions under which

this occurs for the server logs and how to control it, see

https://dev.mysql.com/doc/refman/9.1/en/password-logging.html. For

similar information about client-side logging, see

https://dev.mysql.com/doc/refman/9.1/en/mysql-logging.html.

SET PASSWORD can be used with or without a FOR clause that explicitly

names a user account:

o With a FOR user clause, the statement sets the password for the named

account, which must exist:

SET PASSWORD FOR 'jeffrey'@'localhost' = 'auth_string';

o With no FOR user clause, the statement sets the password for the

current user:

SET PASSWORD = 'auth_string';

Any client who connects to the server using a nonanonymous account

can change the password for that account. (In particular, you can

change your own password.) To see which account the server

authenticated you as, invoke the CURRENT_USER() function:

SELECT CURRENT_USER();

If a FOR user clause is given, the account name uses the format

described in

https://dev.mysql.com/doc/refman/9.1/en/account-names.html. For

example:

SET PASSWORD FOR 'bob'@'%.example.org' = 'auth_string';

The host name part of the account name, if omitted, defaults to '%'.

SET PASSWORD interprets the string as a cleartext string, passes it to

the authentication plugin associated with the account, and stores the

result returned by the plugin in the account row in the mysql.user

system table. (The plugin is given the opportunity to hash the value

into the encryption format it expects. The plugin may use the value as

specified, in which case no hashing occurs.)

Setting the password for a named account (with a FOR clause) requires

the UPDATE privilege for the mysql system schema. Setting the password

for yourself (for a nonanonymous account with no FOR clause) requires

no special privileges.

Statements that modify secondary passwords require these privileges:

o The APPLICATION_PASSWORD_ADMIN privilege is required to use the

RETAIN CURRENT PASSWORD clause for SET PASSWORD statements that apply

to your own account. The privilege is required to manipulate your own

secondary password because most users require only one password.

o If an account is to be permitted to manipulate secondary passwords

for all accounts, it should be granted the CREATE USER privilege

rather than APPLICATION_PASSWORD_ADMIN.

When the read_only system variable is enabled, SET PASSWORD requires

the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege), in

addition to any other required privileges.

URL: https://dev.mysql.com/doc/refman/9.1/en/set-password.html

4. mysqladmin的使用指南：

查看版本：

[root@station95 ~]# mysqladmin -V

mysqladmin Ver 9.6.0 for Linux on x86_64 (MySQL Community Server - GPL)

mysqladmin的在线帮助：

[root@station95 ~]# mysqladmin --help

mysqladmin Ver 9.6.0 for Linux on x86_64 (MySQL Community Server - GPL)

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Administration program for the mysqld daemon.

Usage: mysqladmin [OPTIONS] command command....

--bind-address=name IP address to bind to.

-c, --count=# Number of iterations to make. This works with -i

(--sleep) only.

-#, --debug[=#] This is a non-debug version. Catch this and exit.

--debug-check This is a non-debug version. Catch this and exit.

--debug-info This is a non-debug version. Catch this and exit.

-f, --force Don't ask for confirmation on drop database; with

multiple commands, continue even if an error occurs.

-C, --compress Use compression in server/client protocol.

--character-sets-dir=name

Directory for character set files.

--default-character-set=name

Set the default character set.

-?, --help Display this help and exit.

-h, --host=name Connect to host.

-b, --no-beep Turn off beep on error.

-p, --password[=name]

Password to use when connecting to server. If password is

not given it's asked from the tty.

--password1[=name] Password for first factor authentication plugin.

--password2[=name] Password for second factor authentication plugin.

--password3[=name] Password for third factor authentication plugin.

-P, --port=# Port number to use for connection or 0 for default to, in

order of preference, my.cnf, $MYSQL_TCP_PORT,

/etc/services, built-in default (3306).

--protocol=name The protocol to use for connection (tcp, socket, pipe,

memory).

-r, --relative Show difference between current and previous values when

used with -i. Currently only works with extended-status.

-s, --silent Silently exit if one can't connect to server.

-S, --socket=name The socket file to use for connection.

-i, --sleep=# Execute commands repeatedly with a sleep between.

--ssl-mode=name SSL connection mode.

--ssl-ca=name CA file in PEM format.

--ssl-capath=name CA directory.

--ssl-cert=name X509 cert in PEM format.

--ssl-cipher=name SSL cipher to use.

--ssl-key=name X509 key in PEM format.

--ssl-crl=name Certificate revocation list.

--ssl-crlpath=name Certificate revocation list path.

--tls-version=name TLS version to use, permitted values are: TLSv1.2,

TLSv1.3

--ssl-fips-mode=name

SSL FIPS mode (applies only for OpenSSL); permitted

values are: OFF, ON, STRICT

--tls-ciphersuites=name

TLS v1.3 cipher to use.

--ssl-session-data=name

Session data file to use to enable ssl session reuse

--ssl-session-data-continue-on-failed-reuse

If set to ON, this option will allow connection to

succeed even if session data cannot be reused.

--tls-sni-servername=name

The SNI server name to pass to server

--server-public-key-path=name

File path to the server public RSA key in PEM format.

--get-server-public-key

Get server public key

-u, --user=name User for login if not current user.

-v, --verbose Write more information.

-V, --version Output version information and exit.

-E, --vertical Print output vertically. Is similar to --relative, but

prints output vertically.

-w, --wait[=#] Wait and retry if connection is down.

--connect-timeout=#

--shutdown-timeout=#

--plugin-dir=name Directory for client-side plugins.

--default-auth=name Default authentication client-side plugin to use.

--enable-cleartext-plugin

Enable/disable the clear text authentication plugin.

--show-warnings Show warnings after execution

--compression-algorithms=name

Use compression algorithm in server/client protocol.

Valid values are any combination of

'zstd','zlib','uncompressed'.

--zstd-compression-level=#

Use this compression level in the client/server protocol,

in case --compression-algorithms=zstd. Valid range is

between 1 and 22, inclusive. Default is 3.

Variables (--variable-name=value)

and boolean options {FALSE|TRUE} Value (after reading options)

----------------------------------------- --------------------------------

bind-address (No default value)

count 0

force FALSE

compress FALSE

character-sets-dir (No default value)

default-character-set auto

host (No default value)

no-beep FALSE

port 3309

relative FALSE

socket (No default value)

sleep 0

ssl-ca (No default value)

ssl-capath (No default value)

ssl-cert (No default value)

ssl-cipher (No default value)

ssl-key (No default value)

ssl-crl (No default value)

ssl-crlpath (No default value)

tls-version (No default value)

tls-ciphersuites (No default value)

ssl-session-data (No default value)

ssl-session-data-continue-on-failed-reuse FALSE

tls-sni-servername (No default value)

server-public-key-path (No default value)

get-server-public-key FALSE

user (No default value)

verbose FALSE

vertical FALSE

connect-timeout 43200

shutdown-timeout 3600

plugin-dir (No default value)

default-auth (No default value)

enable-cleartext-plugin FALSE

show-warnings FALSE

compression-algorithms (No default value)

zstd-compression-level 3

Default options are read from the following files in the given order:

/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf

The following groups are read: mysqladmin client

The following options may be given as the first argument:

--print-defaults Print the program argument list and exit.

--no-defaults Don't read default options from any option file,

except for login file.

--defaults-file=# Only read default options from the given file #.

--defaults-extra-file=# Read this file after the global files are read.

--defaults-group-suffix=#

Also read groups with concat(group, suffix)

--login-path=# Read this path from the login file.

--no-login-paths Don't read login paths from the login path file.

Where command is a one or more of: (Commands may be shortened)

create databasename Create a new database

debug Instruct server to write debug information to log

drop databasename Delete a database and all its tables

extended-status Gives an extended status message from the server

flush-hosts Flush all cached hosts

flush-logs Flush all logs

flush-status Clear status variables

flush-tables Flush all tables

flush-privileges Reload grant tables (same as reload)

kill id,id,... Kill mysql threads

password [new-password] Change old password to new-password in current format

ping Check if mysqld is alive

processlist Show list of active threads in server

reload Reload grant tables

refresh Flush all tables and close and open logfiles

shutdown Take server down

status Gives a short status message from the server

start-replica Start replication

start-slave Deprecated: use start-replica instead

stop-replica Stop replication

stop-slave Deprecated: use stop-replica instead

variables Prints variables available

version Get version info from server

使用mysqladmin显示当前变量值：

[root@station95 ~]# mysqladmin -u root -p variables | grep host

Enter password:

| host_cache_size | 279 |

| hostname | station95.lab.example.com |

| performance_schema_hosts_size | -1 |

| report_host |

5. MySQL图形界面----mysql-workbench的安装：

下载mysql-workbench的RPM包：

[root@station95 ~]# wget https://downloads.mysql.com/archives/get/p/8/file/mysql-workbench-community-8.0.45-1.el8.x86_64.rpm

--2026-03-15 03:31:59-- https://downloads.mysql.com/archives/get/p/8/file/mysql-workbench-community-8.0.45-1.el8.x86_64.rpm

Resolving downloads.mysql.com (downloads.mysql.com)... 184.50.187.187, 2600:1417:76:58b::2e31, 2600:1417:76:589::2e31

Connecting to downloads.mysql.com (downloads.mysql.com)|184.50.187.187|:443... connected.

HTTP request sent, awaiting response... 302 Moved Temporarily

Location: https://cdn.mysql.com/archives/mysql-workbench/mysql-workbench-community-8.0.45-1.el8.x86_64.rpm [following]

--2026-03-15 03:32:00-- https://cdn.mysql.com/archives/mysql-workbench/mysql-workbench-community-8.0.45-1.el8.x86_64.rpm

Resolving cdn.mysql.com (cdn.mysql.com)... 23.49.112.119, 2600:1417:76:588::1d68, 2600:1417:76:580::1d68

Connecting to cdn.mysql.com (cdn.mysql.com)|23.49.112.119|:443... connected.

HTTP request sent, awaiting response... 200 OK

Length: 50959488 (49M) [application/x-redhat-package-manager]

Saving to: ‘mysql-workbench-community-8.0.45-1.el8.x86_64.rpm’

mysql-workbench-community-8.0.45-1.el8. 100%[============================================================================>] 48.60M 4.02MB/s in 12s

2026-03-15 03:32:13 (4.00 MB/s) - ‘mysql-workbench-community-8.0.45-1.el8.x86_64.rpm’ saved [50959488/50959488]

为了安装，而配置EPEL的yum源，首先下载：

[root@station95 ~]# wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm

--2026-03-15 04:03:43-- https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm

Resolving dl.fedoraproject.org (dl.fedoraproject.org)... 38.145.32.23, 38.145.32.24, 38.145.32.22

Connecting to dl.fedoraproject.org (dl.fedoraproject.org)|38.145.32.23|:443... connected.

HTTP request sent, awaiting response... 200 OK

Length: 25216 (25K) [application/x-rpm]

Saving to: ‘epel-release-latest-8.noarch.rpm’

epel-release-latest-8.noarch.rpm 100%[============================================================================>] 24.62K 78.7KB/s in 0.3s

2026-03-15 04:03:46 (78.7 KB/s) - ‘epel-release-latest-8.noarch.rpm’ saved [25216/25216]

然后安装EPEL的yum源：

[root@station95 ~]# yum install epel-release-latest-8.noarch.rpm

Updating Subscription Management repositories.

Unable to read consumer identity

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Last metadata expiration check: 1:14:20 ago on Sun 15 Mar 2026 03:42:02 AM CST.

Dependencies resolved.

=====================================================================================================

Package Architecture Version Repository Size

=====================================================================================================

Installing:

epel-release noarch 8-22.el8 @commandline 25 k

Transaction Summary

=====================================================================================================

Install 1 Package

Total size: 25 k

Installed size: 34 k

Is this ok [y/N]: y

Downloading Packages:

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

Preparing : 1/1

Installing : epel-release-8-22.el8.noarch 1/1

Running scriptlet: epel-release-8-22.el8.noarch 1/1

Many EPEL packages require the CodeReady Builder (CRB) repository.

It is recommended that you run /usr/bin/crb enable to enable the CRB repository.

Verifying : epel-release-8-22.el8.noarch 1/1

Installed products updated.

Installed:

epel-release-8-22.el8.noarch

Complete!

安装mysql-workbench：

[root@station95 ~]# yum install mysql-workbench-community-8.0.45-1.el8.x86_64.rpm

Updating Subscription Management repositories.

Unable to read consumer identity

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Extra Packages for Enterprise Linux 8 - x86_64 3.2 MB/s | 14 MB 00:04

Last metadata expiration check: 0:00:12 ago on Sun 15 Mar 2026 04:57:36 AM CST.

Dependencies resolved.

===================================================================================================

Package Architecture Version Repository Size

===================================================================================================

Installing:

mysql-workbench-community x86_64 8.0.45-1.el8 @commandline 49 M

Installing dependencies:

libglvnd-opengl x86_64 1:1.2.0-6.el8 AppStream 48 k

libzip x86_64 1.5.1-2.module+el8.1.0+3202+af5476b9 AppStream 63 k

proj x86_64 6.3.2-4.el8 epel 2.0 M

proj-datumgrid noarch 1.8-6.3.2.4.el8 epel 5.4 M

python38-libs x86_64 3.8.3-3.module+el8.3.0+7680+79e7e61a AppStream 8.3 M

python38-pip-wheel noarch 19.3.1-1.module+el8.3.0+7187+a27ec44b AppStream 1.2 M

python38-setuptools-wheel noarch 41.6.0-4.module+el8.3.0+7187+a27ec44b AppStream 304 k

Installing weak dependencies:

python38 x86_64 3.8.3-3.module+el8.3.0+7680+79e7e61a AppStream 78 k

python38-pip noarch 19.3.1-1.module+el8.3.0+7187+a27ec44b AppStream 1.9 M

python38-setuptools noarch 41.6.0-4.module+el8.3.0+7187+a27ec44b AppStream 667 k

Enabling module streams:

httpd 2.4

nginx 1.14

php 7.2

python38 3.8

Transaction Summary

=====================================================================================================

Install 11 Packages

Total size: 68 M

Total download size: 20 M

Installed size: 315 M

Is this ok [y/N]: y

Downloading Packages:

(1/10): libglvnd-opengl-1.2.0-6.el8.x86_64.rpm 5.3 MB/s | 48 kB 00:00

(2/10): libzip-1.5.1-2.module+el8.1.0+3202+af5476b9.x86_64.rpm 5.5 MB/s | 63 kB 00:00

(3/10): python38-3.8.3-3.module+el8.3.0+7680+79e7e61a.x86_64.rpm 4.6 MB/s | 78 kB 00:00

(4/10): python38-pip-wheel-19.3.1-1.module+el8.3.0+7187+a27ec44b.noarch.rpm 20 MB/s | 1.2 MB 00:00

(5/10): python38-pip-19.3.1-1.module+el8.3.0+7187+a27ec44b.noarch.rpm 21 MB/s | 1.9 MB 00:00

(6/10): python38-setuptools-wheel-41.6.0-4.module+el8.3.0+7187+a27ec44b.noarch.rpm 18 MB/s | 304 kB 00:00

(7/10): python38-setuptools-41.6.0-4.module+el8.3.0+7187+a27ec44b.noarch.rpm 14 MB/s | 667 kB 00:00

(8/10): python38-libs-3.8.3-3.module+el8.3.0+7680+79e7e61a.x86_64.rpm 26 MB/s | 8.3 MB 00:00

(9/10): proj-6.3.2-4.el8.x86_64.rpm 1.6 MB/s | 2.0 MB 00:01

(10/10): proj-datumgrid-1.8-6.3.2.4.el8.noarch.rpm 2.6 MB/s | 5.4 MB 00:02

-------------------------------------------------------------------------------------------------------------------------------------------------------------

Total 7.7 MB/s | 20 MB 00:02

warning: /var/cache/dnf/epel-fafd94c310c51e1e/packages/proj-6.3.2-4.el8.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID 2f86d6a1: NOKEY

Extra Packages for Enterprise Linux 8 - x86_64 1.6 MB/s | 1.6 kB 00:00

Importing GPG key 0x2F86D6A1:

Userid : "Fedora EPEL (8) "

Fingerprint: 94E2 79EB 8D8F 25B2 1810 ADF1 21EA 45AB 2F86 D6A1

From : /etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-8

Is this ok [y/N]: y

Key imported successfully

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

Preparing : 1/1

Installing : proj-datumgrid-1.8-6.3.2.4.el8.noarch 1/11

Installing : proj-6.3.2-4.el8.x86_64 2/11

Installing : python38-setuptools-wheel-41.6.0-4.module+el8.3.0+7187+a27ec44b.noarch 3/11

Installing : python38-pip-wheel-19.3.1-1.module+el8.3.0+7187+a27ec44b.noarch 4/11

Installing : python38-libs-3.8.3-3.module+el8.3.0+7680+79e7e61a.x86_64 5/11

Installing : python38-3.8.3-3.module+el8.3.0+7680+79e7e61a.x86_64 6/11

Running scriptlet: python38-3.8.3-3.module+el8.3.0+7680+79e7e61a.x86_64 6/11

Installing : python38-setuptools-41.6.0-4.module+el8.3.0+7187+a27ec44b.noarch 7/11

Running scriptlet: python38-setuptools-41.6.0-4.module+el8.3.0+7187+a27ec44b.noarch 7/11

Installing : python38-pip-19.3.1-1.module+el8.3.0+7187+a27ec44b.noarch 8/11

Running scriptlet: python38-pip-19.3.1-1.module+el8.3.0+7187+a27ec44b.noarch 8/11

Installing : libzip-1.5.1-2.module+el8.1.0+3202+af5476b9.x86_64 9/11

Installing : libglvnd-opengl-1:1.2.0-6.el8.x86_64 10/11

Installing : mysql-workbench-community-8.0.45-1.el8.x86_64 11/11

Running scriptlet: mysql-workbench-community-8.0.45-1.el8.x86_64 11/11

Verifying : libglvnd-opengl-1:1.2.0-6.el8.x86_64 1/11

Verifying : libzip-1.5.1-2.module+el8.1.0+3202+af5476b9.x86_64 2/11

Verifying : python38-3.8.3-3.module+el8.3.0+7680+79e7e61a.x86_64 3/11

Verifying : python38-libs-3.8.3-3.module+el8.3.0+7680+79e7e61a.x86_64 4/11

Verifying : python38-pip-19.3.1-1.module+el8.3.0+7187+a27ec44b.noarch 5/11

Verifying : python38-pip-wheel-19.3.1-1.module+el8.3.0+7187+a27ec44b.noarch 6/11

Verifying : python38-setuptools-41.6.0-4.module+el8.3.0+7187+a27ec44b.noarch 7/11

Verifying : python38-setuptools-wheel-41.6.0-4.module+el8.3.0+7187+a27ec44b.noarch 8/11

Verifying : proj-6.3.2-4.el8.x86_64 9/11

Verifying : proj-datumgrid-1.8-6.3.2.4.el8.noarch 10/11

Verifying : mysql-workbench-community-8.0.45-1.el8.x86_64 11/11

Installed products updated.

Installed:

libglvnd-opengl-1:1.2.0-6.el8.x86_64 libzip-1.5.1-2.module+el8.1.0+3202+af5476b9.x86_64

mysql-workbench-community-8.0.45-1.el8.x86_64 proj-6.3.2-4.el8.x86_64

proj-datumgrid-1.8-6.3.2.4.el8.noarch python38-3.8.3-3.module+el8.3.0+7680+79e7e61a.x86_64

python38-libs-3.8.3-3.module+el8.3.0+7680+79e7e61a.x86_64 python38-pip-19.3.1-1.module+el8.3.0+7187+a27ec44b.noarch

python38-pip-wheel-19.3.1-1.module+el8.3.0+7187+a27ec44b.noarch python38-setuptools-41.6.0-4.module+el8.3.0+7187+a27ec44b.noarch

python38-setuptools-wheel-41.6.0-4.module+el8.3.0+7187+a27ec44b.noarch

Complete!

6. MySQL图形界面----使用mysql-workbench：

运行：

[root@station95 ~]# mysql-workbench

连接数据库，并执行SQL：

查看性能页面：

路过

雷人

握手

鲜花

鸡蛋

收藏邀请

上一篇：【博客文章2026】MySQL 9.x数据库管理技巧---给初学者的建议3：认识各种MySQL数据库的日志

【博客文章2026】MySQL 9.x数据库管理技巧---给初学者的建议4：在线帮助系统、mysqladmin和mysql-workbench

相关分类