|
|
[root@streamcontrolle ~]# mysql -uroot -p4 _0 ?/ k& Z9 \* ~: p; o
Enter password:
: e& m F9 Y+ o8 Y1 d9 xWelcome to the MariaDB monitor. Commands end with ; or \g.
9 A, ^# d- ^6 ]1 |& ^1 QYour MariaDB connection id is 16
% ^4 X7 b/ s- w0 g, S0 i6 HServer version: 10.5.27-MariaDB MariaDB Server
0 y% @" ?' h& G! H" g0 k- e
5 \+ \9 S. _; }% }Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.8 o; u. _% y1 U8 S W3 o! s& k
2 c/ X& [0 u# f( BType 'help;' or '\h' for help. Type '\c' to clear the current input statement.: L. a: u* O8 D5 r% ]1 g
' {6 @6 N" M; f/ P, X# x6 P# Q B
MariaDB [(none)]> exit
. ]: r) K: Y$ m& [$ n2 k$ v5 \# G* yBye. ^" f P; ]) v8 ~* I
[root@streamcontrolle ~]# mysql -uroot -p
: [, b/ ]" A! q$ v. L) IEnter password: 5 o5 @1 u4 ^/ o3 R; D( {, m/ `
Welcome to the MariaDB monitor. Commands end with ; or \g.
6 ]9 c# k( P8 I1 a( P( q# `% {Your MariaDB connection id is 17
9 O/ ]3 C# Y) a, q" |Server version: 10.5.27-MariaDB MariaDB Server6 }! ^6 h8 u: g# X5 W: |7 q
0 z- Z# {4 {) I" w, h
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.- M: }3 A+ g0 m$ J% e4 @* y
, @4 b" m5 C) N+ t# X0 y" \$ z: V
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.8 N/ }. ~) |+ ]$ J4 g* r
2 q; y9 v' C7 K6 m, C! l
MariaDB [(none)]> select * from mysql.user ;# V3 @2 H) N1 P. }7 \
+-----------+-------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+---------+--------------+--------------------+
& u3 t' _ H" F) s5 ?- ^5 A| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | Delete_history_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string | password_expired | is_role | default_role | max_statement_time |+ x, v5 D9 \' D$ \3 v; ~ o
+-----------+-------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+---------+--------------+--------------------+
0 o2 K* v) D+ ?( W9 P| localhost | mariadb.sys | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | mysql_native_password | | Y | N | | 0.000000 |
5 S+ T8 P: E3 F, J* g| localhost | mysql | invalid | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | mysql_native_password | invalid | N | N | | 0.000000 |; Z' W7 A, Z4 s; C1 x( G
| % | test | *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | mysql_native_password | *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 | N | N | | 0.000000 |
, G% S' n4 x0 p; N% ]+-----------+-------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+---------+--------------+--------------------+* U& j. n( h$ e- D4 @) @6 o' r0 \
3 rows in set (0.002 sec)& O/ u5 i/ w$ u2 Q$ a" N4 j0 e. G
" A/ Y$ {' s I- s' i4 r4 w$ NMariaDB [(none)]> select * from mysql.user \G;
7 K, k R' Q* d R% t*************************** 1. row ***************************6 t; L( ^* d1 Q& S
Host: localhost
* |4 N7 F( t7 U User: mariadb.sys; K' z+ s$ E) G! O2 l$ h6 N
Password:
# g$ n$ o" u+ ^9 i$ d Select_priv: N
4 e9 u' b/ k3 s% \0 b) B4 n Insert_priv: N
; k/ S0 f$ z n6 y Update_priv: N& m9 E. X4 w, b; `9 M
Delete_priv: N2 _( P, D' K+ |( H. ~- |6 o; Y
Create_priv: N
4 K1 s6 y4 \. o4 e, h; {" l/ K# r Drop_priv: N# \1 Y* ~7 b& Q ?/ I2 \! M
Reload_priv: N& h9 ]7 P5 A& m
Shutdown_priv: N
# P# T% ~( D7 m4 P h3 Z6 { Process_priv: N
/ m8 H6 q2 T1 ~- P File_priv: N. s3 u- E) W7 Q! m [
Grant_priv: N' Z# _* J% y, O+ n+ |# I5 X
References_priv: N% Y! u; N: h4 ^8 P. N; Q4 d
Index_priv: N
1 v0 X4 H* ]6 L9 [ Alter_priv: N
6 I) @ k" T5 h5 c6 F Show_db_priv: N' H! d' W6 D: Q9 |; l4 }0 l, t
Super_priv: N
0 e. X! L( x* L7 c0 H Create_tmp_table_priv: N5 j0 I9 c; x, K$ T8 z. r! T
Lock_tables_priv: N
: I ~; s- N! K4 S, y Execute_priv: N+ q6 A) |# Q/ t% t" M7 ]
Repl_slave_priv: N
0 I$ D4 b3 u0 E7 S* T& X" ` l Repl_client_priv: N
9 F1 Q t; O/ _% v Create_view_priv: N& g% `) e' B% q% ^5 y
Show_view_priv: N
) x( A0 s( j) [ q( K/ ^/ L Create_routine_priv: N. J4 N$ z5 ^0 [9 {8 W( o
Alter_routine_priv: N
. K7 {) k) E1 q: ~ Create_user_priv: N
) l! [8 P, M, s8 k0 F Event_priv: N7 O7 ]. S9 K* e& K1 F. q
Trigger_priv: N! @: k6 F; q6 j( S0 J! o& O- n
Create_tablespace_priv: N
; s2 A# A' _% l1 g Z- A+ Y Delete_history_priv: N
7 T3 p1 J m" |. ^6 Y ssl_type:
8 {3 n( ^8 C. m" i/ T) G ssl_cipher:
* x, \& X$ h7 X9 W2 x# L ^9 i x509_issuer: ( L) o# C" h6 R
x509_subject: 2 E! q8 I, p! X
max_questions: 0, [6 k8 F$ D v( _; w2 F' l# }
max_updates: 08 f% s7 v J# t# D1 t& \: ~+ ^
max_connections: 0
8 E1 _$ H5 D6 A. P* C3 ` max_user_connections: 0. @& y" _% D4 z+ F4 O4 ^& \, v
plugin: mysql_native_password! X$ Y+ o* L3 U& k1 [5 R B8 ]
authentication_string:
5 t8 |" f+ i! o+ k1 _- }9 `, o password_expired: Y
# j' b9 J3 c% U6 s) Q is_role: N
' }4 S3 F9 a1 h, D default_role: + s( C# ?2 Q4 B, Z; H
max_statement_time: 0.000000+ {) K9 E1 Y2 G5 y! [9 c
*************************** 2. row ***************************" [' w2 F0 N7 P3 h
Host: localhost
6 j. A) ?# ~3 |/ a+ @4 k User: mysql
0 p1 [% n, t7 }! f% {1 h# B* u! ` Password: invalid. F# z9 H7 x; x8 @3 n( C
Select_priv: Y7 I9 L+ F: X, g" M3 o% i8 a
Insert_priv: Y+ V( w( x3 b* i+ W8 J" i- V, ^6 |
Update_priv: Y0 y& F/ D$ x2 ]& _4 |% L
Delete_priv: Y, a0 U9 O/ f4 N
Create_priv: Y
: l% V4 |+ A1 s+ L6 T9 p! k Drop_priv: Y! _* L% h1 m, E3 [' m& w
Reload_priv: Y
& h; z# `" q& D( x# C' l; D Shutdown_priv: Y
& ?( I) q# f+ G# V Process_priv: Y
2 \: L/ g9 R3 [/ _0 h File_priv: Y* B3 L) b1 d/ A5 j! d5 S4 X9 h# X
Grant_priv: Y/ u- X/ S9 P! i! P. W7 {) f
References_priv: Y
: V0 o# Y0 Y$ _' ?9 y- _; i7 d Index_priv: Y
4 r+ C" e+ B1 C3 S9 w+ _) Z Alter_priv: Y
/ X8 K* l, L- | Show_db_priv: Y
+ C' r+ I) N7 V |2 e5 l8 k Super_priv: Y5 x6 C- O% p' d1 P9 x
Create_tmp_table_priv: Y
1 T- j) M- I% L4 c7 N, s2 v. F Lock_tables_priv: Y
* s+ l$ i* r" M9 [: Y# p Execute_priv: Y5 d. V2 \( K- @+ ]+ U7 h$ A) u
Repl_slave_priv: Y
2 Q5 N& J$ s8 y4 W+ [ Repl_client_priv: Y* L+ B8 C- C9 w, Y& n* f! N3 k) w
Create_view_priv: Y$ u2 L9 y: |) ~2 b+ t
Show_view_priv: Y
. ^- r' Z, h4 N4 S2 o- A4 r5 H Create_routine_priv: Y& q+ w4 z- M8 k B; G# X1 a1 Q( b
Alter_routine_priv: Y8 P7 @9 ~' V* L. t6 ]
Create_user_priv: Y
1 \: D1 k" d, K Event_priv: Y
) Y0 J, L) B! z l |9 K Trigger_priv: Y- n# W* D4 F! ?1 a# y
Create_tablespace_priv: Y n& i. o e5 ^7 R( l* {% o/ f9 h
Delete_history_priv: Y: A" A9 X8 J$ p- y
ssl_type: 8 q9 c2 a. E5 K
ssl_cipher:
: _4 A0 x/ c6 P x509_issuer:
5 A& i$ X( F$ W x509_subject: ( i* \7 }( L6 z) w6 f( N8 w( ^
max_questions: 0
/ A- `+ T/ Z3 s Z max_updates: 0 |& d8 h# A6 q/ W6 ~& D' \
max_connections: 05 Z5 P( N( |5 [/ q! |" [: j/ Q+ s
max_user_connections: 0
' B8 b+ Q6 C4 [# S+ d plugin: mysql_native_password
& b$ B+ K, r( {- b authentication_string: invalid
1 ?# d& U2 N" n$ R: J% ]% k1 c5 K password_expired: N" v: i: O3 D/ m$ B' |
is_role: N
* y, P" G8 V5 [; x" C" [- I% p default_role:
7 C3 l4 L; @; o' X o: y/ q max_statement_time: 0.000000
" m b% p4 S! e. W& l- B1 g*************************** 3. row ***************************9 N7 N% y, W: |" v! a u; Y: Q0 O$ ^
Host: %$ I- B' \* G7 U9 k1 _# v& ?
User: test
7 X( F: u" v: C; j Password: *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29
5 U4 ?( O0 b0 r7 i% E Select_priv: N2 N& d; ^* M# P9 [- F" C
Insert_priv: N6 R( I5 j0 d( y( k/ R- f9 ?3 l
Update_priv: N
3 J' o8 r- ~0 n. R. x, G& Y9 C Delete_priv: N9 \- z) [5 h2 w# j( E
Create_priv: N8 ~' f6 W. C( I. Q7 \4 I+ G
Drop_priv: N! m+ T+ b3 d0 A: h7 s
Reload_priv: N
9 l' w8 b$ q3 J9 f Shutdown_priv: N' j0 ^( k J# c5 w E
Process_priv: N7 F2 _8 x# t; c2 }; N, T
File_priv: N
: ~2 \( j# ~$ O( g Grant_priv: N1 ]6 N$ @) I1 t2 B3 Y; ?+ v) q" e
References_priv: N
) G+ M! D+ g. a+ s; i Index_priv: N
1 X @9 m% w5 t$ G* C9 t# R Alter_priv: N
/ j4 g/ T! b- B) H7 y" j( X/ s: n, ~- ~ Show_db_priv: N4 S0 ^1 n) @0 t6 d$ }
Super_priv: N6 Y& F0 u# U3 ~2 ]# u% d
Create_tmp_table_priv: N( X8 j3 v5 @5 [. M; i9 R' ~
Lock_tables_priv: N
. Q3 }5 u5 I; X$ y3 D" O Execute_priv: N9 C: w- n# ?! S3 t3 \
Repl_slave_priv: N
9 w# D: ?& l, y9 S% j Repl_client_priv: N3 z- {# o7 R1 i" x5 W
Create_view_priv: N
3 g# R( S1 d0 `" I1 K/ N Show_view_priv: N
( a# \/ b+ k* b Create_routine_priv: N: p" T5 \; G7 ~4 J5 V* z9 G
Alter_routine_priv: N" X+ j$ y2 E3 [
Create_user_priv: N, S9 Z" y1 _& G: Z9 X
Event_priv: N
! C4 L2 ]/ i; |$ P- X Trigger_priv: N
+ V. ^8 G6 z$ e9 O7 wCreate_tablespace_priv: N% r) {' o) t* o( \2 J% Y
Delete_history_priv: N ]9 q$ Q" L" g3 I
ssl_type: 2 E$ w7 a/ i& C
ssl_cipher: " Q6 h3 a/ p s
x509_issuer:
$ W$ |2 J. ^" s$ c& @ x509_subject: 6 ?" }$ Y7 o3 O% n& U a
max_questions: 01 Z, u; v H! |6 g8 q$ L
max_updates: 0
; |; L$ ^3 ^! ] max_connections: 02 Y1 o4 T* x0 U
max_user_connections: 0% I) @, b6 g8 a+ @; C+ J
plugin: mysql_native_password
- G6 Z- p7 C) _# I h% a9 M authentication_string: *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29% U) g% F8 ]( r4 v7 v6 m. U7 q1 s
password_expired: N
?1 W( {. o% F7 v# m c6 g- r is_role: N
6 W1 I+ r" F2 E8 ^ default_role:
& X# i2 S, x+ m1 B& P1 E max_statement_time: 0.000000& Q* K) A2 O% v
3 rows in set (0.002 sec)
, o" U5 r Z# R, y1 \: a& j
: b! C, t9 O4 O$ B1 V8 cERROR: No query specified
- `- |9 q, L; Q/ Z: Q# w5 ]" v3 ^5 E+ Z! \, e" s! }
MariaDB [(none)]> show variables like 'sql_safe%';
' |; ~7 l: I4 o5 A S+------------------+-------+5 q$ ]$ V6 K _8 G/ A% z
| Variable_name | Value |, V, u" B% A( W/ {1 x& C8 [
+------------------+-------+3 ?. h) Y+ V% d! @$ u
| sql_safe_updates | OFF |: n5 ^! @% X3 Z9 `
+------------------+-------+
( s& @5 q. X- _1 row in set (0.002 sec)
* h! J6 q1 R" G v: Y6 s0 z
% h, |9 s6 P6 R/ B8 L+ I4 aMariaDB [(none)]> select * from global_priv \G;
9 e0 W$ |* _& |2 E% WERROR 1046 (3D000): No database selected
1 s& H' i5 Y2 Q8 ~2 q& n9 DERROR: No query specified# B1 o' l" }. i( a( Z& q1 ~2 F6 X8 h
$ }7 t- u, p/ B8 W6 O2 T8 _MariaDB [(none)]> select * from mysql.global_priv \G;" b$ Y0 X0 T/ s6 [6 c- L! F
*************************** 1. row ***************************
$ e3 E: \, c# }0 L) [9 t9 o9 bHost: localhost
9 {/ N/ j% \$ x* fUser: mariadb.sys, O, V$ t1 O. e0 n, O2 p8 K& J
Priv: {"access":0,"plugin":"mysql_native_password","authentication_string":"","account_locked":true,"password_last_changed":0}: Q W7 \3 Z. I# F5 `
*************************** 2. row ***************************
# x5 I3 M1 s; `& m7 V1 r% W. kHost: localhost+ r0 h0 ~: R3 Q. }! N0 T( P
User: mysql3 Z0 M- ^2 m8 e- @4 I
Priv: {"access":18446744073709551615,"plugin":"mysql_native_password","authentication_string":"invalid","auth_or":[{},{"plugin":"unix_socket"}]}' l4 ]- g- H4 k/ R, M& d( R
*************************** 3. row ***************************
4 d% a# L) l9 h$ gHost: %
6 R7 H5 E8 F7 MUser: test
2 W9 A) s k4 w3 b! w5 MPriv: {"access":0,"version_id":100527,"plugin":"mysql_native_password","authentication_string":"*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29","password_last_changed":1739522769}
% G; e* v* @: L3 rows in set (0.001 sec)
% d3 I; u" r" f3 n5 ?8 K l+ l& t
6 C$ Y( O1 _! L u# a. ^ERROR: No query specified
1 k% z1 ?9 W J* ~! {$ C/ o- M, `6 C7 u: |, U; O# }- }
MariaDB [(none)]> select * from mysql.global_priv ;
, D6 }" D: I8 K# O0 M+-----------+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
8 O/ w% p0 U, u6 E0 L- }% r2 b* R2 I8 l| Host | User | Priv |$ a( y* I- [1 v$ P: ]
+-----------+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
, J& T$ F* }% r2 P- H| localhost | mariadb.sys | {"access":0,"plugin":"mysql_native_password","authentication_string":"","account_locked":true,"password_last_changed":0} |
3 B% k6 f) q) f5 z! e1 t| localhost | mysql | {"access":18446744073709551615,"plugin":"mysql_native_password","authentication_string":"invalid","auth_or":[{},{"plugin":"unix_socket"}]} |
6 q/ U- A' k' ?1 V8 C7 @| % | test | {"access":0,"version_id":100527,"plugin":"mysql_native_password","authentication_string":"*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29","password_last_changed":1739522769} |
5 e) F3 \; @$ o' a' Z! |+-----------+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+9 N& k% v" L0 Z/ U. N! A6 C) i
3 rows in set (0.001 sec)* R8 [8 j& z: m2 U/ A. |3 r
~4 C1 t, H' T+ b1 W) j
/ U6 S2 }8 W! Y4 g
MariaDB [(none)]> select * from mysql.global_priv;
# r, f8 N( Q' V7 r) |9 m7 ` p+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+8 S5 o4 z/ F z5 u( m7 V3 l- Q p
| Host | User | Priv |
9 y0 [, z- }* [6 `3 ~8 A$ {+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+( G) [: x" N0 a# j. i7 R( @( ^
| localhost | mariadb.sys | {"access":0,"plugin":"mysql_native_password","authentication_string":"","account_locked":true,"password_last_changed":0} |: V* \: f/ W6 L8 L1 ^
| localhost | root | {"access": 18446744073709551615, "plugin": "mysql_native_password", "authentication_string": "*C0F9333D119A6BC11CF79C9A12E656EDBBF32052", "auth_or": [{}, {"plugin": "unix_socket"}]} |
" p. C/ I# v# ~7 A| localhost | mysql | {"access":18446744073709551615,"plugin":"mysql_native_password","authentication_string":"invalid","auth_or":[{},{"plugin":"unix_socket"}]} |
3 {4 q! Z( O9 q# Y2 d3 A# K+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
8 {# u7 R! \2 `6 S% B _3 rows in set (0.001 sec)
! O2 k0 k7 P5 e- b( l$ B E0 L! k# P! l& ~( W* \4 r; u6 M0 T
MariaDB [(none)]> ALTER USER root@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD("xxxxxxx123")
" K3 c7 w9 h# ]5 E -> ;4 |( B7 c, _0 l6 a9 v1 y/ n" _
Query OK, 0 rows affected (0.001 sec)7 i O; o; g# j; E
) }2 ^, z V! |MariaDB [(none)]> select * from mysql.global_priv;
- p3 ^/ k( F, X8 R6 ~+-----------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
8 M8 S) g9 X# c+ h| Host | User | Priv |
& X: y2 }, B! S% N( G+-----------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
: N9 l6 u! [' s/ W+ R0 V7 `| localhost | mariadb.sys | {"access":0,"plugin":"mysql_native_password","authentication_string":"","account_locked":true,"password_last_changed":0} |6 Y# x. p P5 k/ U C9 G; i6 H4 q, `: S
| localhost | root | {"access": 549755813887, "plugin": "mysql_native_password", "authentication_string": "*C0F9333D119A6BC11CF79C9A12E656EDBBF32052", "auth_or": [{}],"version_id":100527,"password_last_changed":1739545230} |9 D2 `0 C4 O' t. o, c( w* l
| localhost | mysql | {"access":18446744073709551615,"plugin":"mysql_native_password","authentication_string":"invalid","auth_or":[{},{"plugin":"unix_socket"}]} |
' \7 i! @+ u& M, u% d- N4 T9 j) U; \+-----------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+$ T7 H/ m0 k. L! o
3 rows in set (0.001 sec)
5 X' [+ G1 E5 A6 a" K: N/ x
8 i. T3 a7 E! J" ]+ D& z* P+ L9 ^4 @$ J6 i8 N' v
; k5 f0 `$ r! q( }
1 N, k) D; F: N/ NMariaDB [(none)]> flush privileges;3 T. n3 n+ T- V' ]& R
Query OK, 0 rows affected (0.001 sec)
' q( n3 R8 E9 f9 L; |4 D, f+ B6 l. e0 ]9 u w9 I
MariaDB [(none)]> select user, plugin from mysql.user;
5 M# u) b" L+ W+ C- m$ ^# u& M+-------------+-----------------------+' A+ n u: t, e9 V9 A& V
| User | plugin |
' e% a4 u! `3 T* e3 z9 c# I0 P+-------------+-----------------------+$ Z( K, B- n! i( v
| mariadb.sys | mysql_native_password |
0 Q j/ C7 w( Q9 @* z/ B1 _| mysql | mysql_native_password |4 }# w1 d$ W6 E9 [, e$ ]! K3 q9 J ~
| test | mysql_native_password |
! ]( f3 K4 C5 r( Z+-------------+-----------------------+
' Z8 s; `$ d9 |& v0 o3 rows in set (0.002 sec)
5 Z- g9 h0 r E7 `* \' N" [) B5 N$ a7 {) o" s
MariaDB [(none)]> FLUSH PRIVILEGES;
- c9 Y k) A7 z2 s* LQuery OK, 0 rows affected (0.002 sec)) c4 P0 ^- |8 b; c% n, {3 }" \1 ]
8 T2 Y! M# S4 s6 S' O8 U+ A
0 C& R/ Z6 i& ~# }MariaDB [(none)]> flush privileges; p: [' l4 i/ [4 c+ u' L
Query OK, 0 rows affected (0.001 sec)
1 }4 i: ?3 N2 t2 X! V. y/ A6 q
4 v7 [3 x7 V- Y( n. E4 q
' H. c3 e2 j$ l; vMariaDB [(none)]> exit
; B! t; ]: ^0 ~1 ?Bye
8 M3 u* ]( ^" {0 J! {8 d
. y5 u7 \2 p$ M0 w2 A' U2 w/ a
0 c% T1 c" x h U[root@streamcontrolle ~]# mysql -uroot -p
# k2 l+ o& I9 g1 V8 @' x) wEnter password: 7 R+ v* S; [: J \
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)% }, k; l% i7 r. d, [" E
[root@streamcontrolle ~]# mysql -uroot -p
/ E8 a% g9 j0 r! ]" P/ u: J4 B, qEnter password: * i8 c3 e+ C6 K/ k
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
7 `" ]0 c3 B& x" I/ ]( ^& ?; \- S+ D, p* B6 s0 _
1 `; C' t+ W" B H" l
! t0 y& t0 u y7 Q0 W) g$ \
|
|
发表于 2025-2-15 08:00:01