|
|
[root@streamcontrolle ~]# mysql -uroot -p
. e9 ~! s& `2 g$ R k! J3 AEnter password:
( E: B8 j/ x" x/ VWelcome to the MariaDB monitor. Commands end with ; or \g.
( i$ z1 b6 T0 f* D ]/ ~Your MariaDB connection id is 16
0 M3 f& I3 @/ f7 [, BServer version: 10.5.27-MariaDB MariaDB Server. r1 _7 f& W1 |: O- t
0 M+ j: m. v$ i" g1 f& C$ ]: mCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
. L5 _% Z, n6 Q+ w
2 F. T! @; w+ ^; `6 n6 a" Q% |* FType 'help;' or '\h' for help. Type '\c' to clear the current input statement.% m1 T& c! ^3 u A
' T* z% M$ Y" F# pMariaDB [(none)]> exit8 Z5 O- x7 o `6 F# x& Q2 ^$ v
Bye
4 W/ e3 i" S4 T9 f& o1 [[root@streamcontrolle ~]# mysql -uroot -p( P% x* o/ ~4 M7 T( x
Enter password: * r( _4 i0 E1 B
Welcome to the MariaDB monitor. Commands end with ; or \g.; H1 m/ {* e/ k+ W0 h7 p3 u% L% |
Your MariaDB connection id is 17- K4 Q/ Q8 D: s# C* s& o/ l/ j
Server version: 10.5.27-MariaDB MariaDB Server
3 O6 P S5 \# ~, _$ y, Z
2 {1 {3 K2 d" i4 O. ^) O' @Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others., j( \$ r0 L3 k+ s
0 a% p5 D# [& ^( @+ F; DType 'help;' or '\h' for help. Type '\c' to clear the current input statement.' l+ M: \& b. i/ s
* h1 N1 I O3 T1 h" G; T$ @
MariaDB [(none)]> select * from mysql.user ;
3 ?6 R; V) t' Z$ l: X+ t+-----------+-------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+---------+--------------+--------------------+4 z8 [+ v1 L8 l; K& `8 k- K( |
| 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 |# k% z- r! E6 w* t
+-----------+-------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+---------+--------------+--------------------+" O7 |) h5 t" s$ \# R
| 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 |7 h. t- X7 B3 u" f
| 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 |
/ h0 ?9 P7 B' U% u0 Q' B% C| % | 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 |
$ H5 L9 T i/ w) G8 Y+-----------+-------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+---------+--------------+--------------------+) V; I- U4 m& r/ O1 F- c$ D
3 rows in set (0.002 sec): R+ Y4 q, K: N4 P8 I- f" J7 T
7 S" T7 l, c% |- |) Z
MariaDB [(none)]> select * from mysql.user \G;7 U9 G2 J8 I! u v
*************************** 1. row ***************************" V3 M" v3 l, ?3 N8 J3 }! R
Host: localhost
# R, S6 `+ ~ L1 b& ~ User: mariadb.sys$ I9 D9 |1 c. v
Password:
! e! c* W! `% `' X1 T' E5 v' j Select_priv: N
* V; X, Z. O, P, P; @/ q Insert_priv: N
1 A; W6 r! l+ w+ s% X% [ Update_priv: N& `3 e+ {6 o- o: b% k8 x. p8 k
Delete_priv: N& S& G" F! y) `; O
Create_priv: N
3 H) P$ [9 J- h# o( V Drop_priv: N
4 Q- n- m* A! `) S Reload_priv: N$ j" _( [% Y# {5 w( b7 q$ K
Shutdown_priv: N
" c3 E# B# o- t Process_priv: N" M& G# c }' d3 H0 g
File_priv: N3 ]3 ?$ C4 b6 T) f* q$ u. Y( j& h
Grant_priv: N5 @: d" P1 b6 l
References_priv: N
% S2 e: A7 y( K: @ Index_priv: N
& Y& a b; z/ ?5 s Alter_priv: N
0 K5 v* _7 B8 `' _5 I Show_db_priv: N
& l& }6 V6 v$ P Super_priv: N1 m/ |8 Y7 x7 O
Create_tmp_table_priv: N$ {0 j) g, M2 b0 y7 y
Lock_tables_priv: N
4 \) R) `3 D" O+ N+ L Execute_priv: N
% i% F; T6 k; u' O2 K) H5 H5 c Repl_slave_priv: N* i' u. |9 h* ?+ z
Repl_client_priv: N
, T0 V" c1 G, i( I. B0 g. L J Create_view_priv: N
( R% o6 T7 N w& S$ | Show_view_priv: N& p! j4 }2 ]" j' @$ B
Create_routine_priv: N
W' c' C5 Y) I/ Z6 q6 o1 s Alter_routine_priv: N4 ?/ j: u9 u. ]1 g$ t
Create_user_priv: N
8 g# a# _' H- k" \3 _* q Event_priv: N: w" W6 q# \7 {2 Z
Trigger_priv: N+ z3 h$ G9 r# Q
Create_tablespace_priv: N
5 s) x5 s/ h8 p5 O& m* i, h Delete_history_priv: N+ O1 j! @: i& g8 s1 Z( Y" Y5 j' u8 w
ssl_type: . D3 C2 z0 b2 h9 D2 h5 o7 @+ f) g: |" @- o
ssl_cipher:
6 H7 N3 I1 p9 c- o x509_issuer: 1 y1 C/ c) G" d! m/ f0 R
x509_subject: # O h3 {$ {) K9 b
max_questions: 0
% @6 k9 e; c, [4 H max_updates: 0
) X- A9 q3 _' T max_connections: 0
# X! R% O7 g3 I max_user_connections: 0. ?. @' @" t8 j. l# _" s2 D
plugin: mysql_native_password
3 Z. \% h9 V, O8 i% l( _( x authentication_string: * }1 `& l7 H" b
password_expired: Y5 c9 b6 J$ T) `+ T
is_role: N
( w8 t4 e; {5 | I default_role: : h M! \( r6 v" @
max_statement_time: 0.000000; U7 t& \+ @0 L: F; Y( r
*************************** 2. row ***************************2 }2 ?" I8 ^+ B" j9 @
Host: localhost
6 q! \1 x2 X0 H. L2 |1 q User: mysql8 U5 O- U t U/ T
Password: invalid7 g- o3 m9 S$ Z
Select_priv: Y9 E. l) Y4 F0 J" L4 d; D
Insert_priv: Y$ I6 n( ?4 N" {' Y8 a; A* g; }
Update_priv: Y( r# ]* l, h/ n. [/ {$ c; O
Delete_priv: Y O& t/ G7 D0 Z. b, u: B
Create_priv: Y
$ Z) G9 \/ z' M5 t! m0 Y% O Drop_priv: Y
: S( D" Z* U9 f. H# Z- V Reload_priv: Y+ ^3 _$ @3 e; p) o# D' ?
Shutdown_priv: Y
% T# m, O, v m" [1 { Process_priv: Y
( l* y9 T" q! a5 M7 ~- n File_priv: Y
, k/ n. @& t( `" f" l9 }6 c Grant_priv: Y
5 S, Y3 O4 a1 i+ M G g( c References_priv: Y
+ E D* _- Q+ |4 S9 @* e Index_priv: Y* @' N9 T+ n; A& F# K
Alter_priv: Y
/ R( e/ C: }" n- h Show_db_priv: Y
& x* T+ d/ i; d* B2 `# f# k: L Super_priv: Y2 ]1 Q3 v- g" A. z1 @2 u' o
Create_tmp_table_priv: Y
$ l! ~. y0 f: J2 M; _5 r' H Lock_tables_priv: Y
8 u. `( n# X5 [9 C- k2 t6 e Execute_priv: Y
1 o/ W" V0 N- Z8 u5 P$ _ Repl_slave_priv: Y: D* H, _7 v) t/ s8 L0 `
Repl_client_priv: Y
( D, T# {: P! n$ M, Y Create_view_priv: Y! o4 D8 S" W, W" m, n% p; Y
Show_view_priv: Y
+ b3 s+ Z$ Z. G' D4 B, q5 e# u Create_routine_priv: Y
" m" Q9 H7 x/ L+ `) M1 p! m Alter_routine_priv: Y. e n9 \& w9 K7 ~
Create_user_priv: Y
( q7 T6 u' a" S: @/ L. ]" M+ D Event_priv: Y$ `; N2 O7 b/ x2 U
Trigger_priv: Y# |: S* T9 [1 P: I# ^8 D" `
Create_tablespace_priv: Y
, J7 F+ [6 k' e0 z2 x: N. g4 O Delete_history_priv: Y
/ k4 J8 W9 ~ _# K7 i6 c# ^ ssl_type:
; C% F7 a7 Q0 S+ f' q ssl_cipher:
8 |1 v a; l$ k* _/ d x509_issuer:
7 Y& e8 e: R% a9 I3 w( ^. Q# u x509_subject:
2 r# D: E9 D1 u$ ] max_questions: 05 `" q/ U: U/ Z
max_updates: 0& D6 C6 j, V4 b! }/ M
max_connections: 0
& [& j1 p2 Q7 N; c$ h max_user_connections: 0! Y5 L2 _! V4 b
plugin: mysql_native_password+ T- z6 o) q% Y% I4 D* M. Z6 [; H
authentication_string: invalid* Z1 H% t& r& t
password_expired: N/ u/ k, b) G/ m5 p# C% n
is_role: N
9 W' I$ N4 [& @, U! v7 }4 p default_role:
) z8 B# E, m9 N. l max_statement_time: 0.000000# U4 I$ j" }& S2 y& V
*************************** 3. row ***************************
6 G- @1 z+ `% f Host: %
8 w2 {5 Y2 B, E1 i7 A, w# _ User: test* J! L; }2 S' g; D
Password: *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29" Q' o% U' m( H4 g3 A+ Y+ x' v( C
Select_priv: N7 ?0 @7 c; C9 x! x/ ~
Insert_priv: N
. ] V* ^5 F$ |: I% a9 a Update_priv: N4 ]* a% t& {* d) ]9 P
Delete_priv: N
" P, y: P! ?1 a+ F; ` Create_priv: N( l& ^4 @7 Y; r8 P
Drop_priv: N
4 O: Y. R. m8 u e M/ G; U Reload_priv: N- f3 Q5 @; @+ Q0 m9 v* l3 ]2 T) m
Shutdown_priv: N1 G/ J7 K/ D1 G. c2 K9 W. I0 K+ c
Process_priv: N- ? r1 U+ e8 ~3 }8 q
File_priv: N' L3 W3 i, v: P
Grant_priv: N
0 I* C/ m( S4 x9 s6 p p References_priv: N
' `( \% I8 b. {0 M" {; ]2 D/ T Index_priv: N; ]( O0 j- ^+ n; ]# X
Alter_priv: N
( [: V5 H# }. W' D+ p# K* r Show_db_priv: N5 ^# ^ |9 N- r0 x3 h5 C5 H
Super_priv: N
3 S% Z2 c* |( W, K3 l* M9 v. ~3 [ Create_tmp_table_priv: N- b0 x4 K% C+ K7 [& D$ Y3 p
Lock_tables_priv: N2 f. ^ Z! P2 p) n; K
Execute_priv: N
2 u2 E0 l8 @. i6 X: w Repl_slave_priv: N# q/ y' G- O f/ i. e
Repl_client_priv: N K& j" O5 X. A3 B$ o+ ^8 w
Create_view_priv: N; e" D) e* h( |: T( L
Show_view_priv: N$ d" E0 G* @8 _8 u; O2 d$ o8 J
Create_routine_priv: N' \9 \; u$ U$ [4 V
Alter_routine_priv: N
) Z9 ~9 T0 M* v t! n# ^ Create_user_priv: N; T3 S6 F+ p; b1 u! @
Event_priv: N
/ _% b2 K4 U8 l/ @- u1 ] Trigger_priv: N% [' q4 z U" V
Create_tablespace_priv: N
# [" d* k' s+ P, o; T Delete_history_priv: N2 o& n) a3 c* \
ssl_type:
, ]1 l" O/ I2 W% \7 l8 R( g! k7 b ssl_cipher:
y( h% ?$ J& W8 p/ S x509_issuer: 6 s0 Z' a/ E; Q5 ?+ f: {; q
x509_subject: 0 e8 O; J2 d" y- l9 V# g5 X
max_questions: 0# C, I+ v( ?& Y- Q& c4 v/ U
max_updates: 0
0 c# B5 N( y! H max_connections: 0- F( Y' @ S. o
max_user_connections: 0) G( g4 i, i, \
plugin: mysql_native_password+ N0 P ~1 U3 M! \( B
authentication_string: *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29
" S; E' t+ c- ^6 c/ g4 @ password_expired: N# x0 K+ {' {7 W) k
is_role: N6 ~) w# c7 K) C9 _8 z
default_role: / c, ]* Y! W; @" o- y* w1 G' q+ z
max_statement_time: 0.000000
, s C6 v7 O4 Z7 O# Z) r$ [3 rows in set (0.002 sec)
$ g7 ~- b% A8 O" a J- x: x" \
ERROR: No query specified
5 \/ H; g4 K$ z$ d4 I0 z q% R6 V; H7 H: k/ B5 l% k5 a2 h
MariaDB [(none)]> show variables like 'sql_safe%';
# I0 |) J+ Y3 X+ Y) `+------------------+-------+
8 m4 h4 Q. R9 K| Variable_name | Value |
. D: Y$ W8 N( A+------------------+-------+
5 \% _0 O* z# h8 ]# b| sql_safe_updates | OFF |
* z) `/ F; g- T$ d+ K; a+------------------+-------+
) L8 X4 O! S6 L1 row in set (0.002 sec)
3 M# |% [/ U& s6 {0 Y* u1 q9 g: K. X2 `# `: }# m( V% l2 d
MariaDB [(none)]> select * from global_priv \G;4 K. i2 `! Q- t8 P0 T* J: s
ERROR 1046 (3D000): No database selected
" |8 Q& ]6 u7 HERROR: No query specified
0 i0 C2 X7 I5 R: Q, f& K# T+ y; W8 ~1 \& S, D) }
MariaDB [(none)]> select * from mysql.global_priv \G;- ^; P k- Y, _7 B! e: O, \+ i
*************************** 1. row ***************************2 T! L& G; r7 [" D5 N+ B
Host: localhost
p0 A8 r* E* u5 pUser: mariadb.sys
1 A# c8 k! V9 `9 h( ?1 wPriv: {"access":0,"plugin":"mysql_native_password","authentication_string":"","account_locked":true,"password_last_changed":0}
" y8 T- n5 g9 {# z& H3 K*************************** 2. row ***************************. A. }8 o6 @7 |1 Y, c
Host: localhost! i' F2 M+ ~9 L0 o4 F3 s
User: mysql
- `* n6 Y5 J$ \- GPriv: {"access":18446744073709551615,"plugin":"mysql_native_password","authentication_string":"invalid","auth_or":[{},{"plugin":"unix_socket"}]}
( O# m0 Z+ }% X$ [5 j: C*************************** 3. row ***************************
; L: j2 [) V1 ?1 K( Y% T4 rHost: %' m9 r4 Q. V* \# g& a( }
User: test/ R: x& n! `* X" X* |) h8 l
Priv: {"access":0,"version_id":100527,"plugin":"mysql_native_password","authentication_string":"*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29","password_last_changed":1739522769}% P0 G. U/ `6 c- b# y
3 rows in set (0.001 sec)
1 O/ y g- X8 K" c$ A! l
6 {3 X+ |! G4 c5 @4 J3 yERROR: No query specified# d2 w* v! [, T5 p! {& ^ T
/ |1 n/ y g% R* Q6 b* j q' g1 q7 `' W1 n
MariaDB [(none)]> select * from mysql.global_priv ;
1 _5 \( D0 {( u+-----------+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
. g4 Q$ Q1 L& B& f1 e| Host | User | Priv |# ]5 G" x; p" l2 w
+-----------+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+6 r2 e' z9 \: ^3 u
| localhost | mariadb.sys | {"access":0,"plugin":"mysql_native_password","authentication_string":"","account_locked":true,"password_last_changed":0} |- C: h8 s% X$ ]- u
| localhost | mysql | {"access":18446744073709551615,"plugin":"mysql_native_password","authentication_string":"invalid","auth_or":[{},{"plugin":"unix_socket"}]} |) c+ x9 i% @* r6 Z0 j% }+ t5 d7 x+ c
| % | test | {"access":0,"version_id":100527,"plugin":"mysql_native_password","authentication_string":"*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29","password_last_changed":1739522769} |
Y2 q7 d5 i9 o$ V+-----------+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+3 i) U5 ]% R! O2 A% _( m2 |
3 rows in set (0.001 sec)
# A. l1 V; q$ w O, l! G& ?; z9 p# c: C/ B0 c" N* O
7 z' h m: c# f3 TMariaDB [(none)]> select * from mysql.global_priv;
2 A4 m) [. P3 t9 ?: @- q+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
3 g7 Y- ]% B4 d| Host | User | Priv |# t7 u1 u! k+ Q/ a- O
+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+) R2 M" y' ~$ w
| localhost | mariadb.sys | {"access":0,"plugin":"mysql_native_password","authentication_string":"","account_locked":true,"password_last_changed":0} |
: [6 @: e1 @( \- [# ]| localhost | root | {"access": 18446744073709551615, "plugin": "mysql_native_password", "authentication_string": "*C0F9333D119A6BC11CF79C9A12E656EDBBF32052", "auth_or": [{}, {"plugin": "unix_socket"}]} |4 p: s: e. R3 \ Y
| localhost | mysql | {"access":18446744073709551615,"plugin":"mysql_native_password","authentication_string":"invalid","auth_or":[{},{"plugin":"unix_socket"}]} |
" ~( n! f( B; i, L. L* |+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+/ ~) t9 {& @0 u9 S
3 rows in set (0.001 sec)$ k$ ?6 w8 u0 E& {# S7 ]* x
% k+ F+ v2 _" V- o9 l% H
MariaDB [(none)]> ALTER USER root@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD("xxxxxxx123")( w. u' o+ M" }7 Y2 _
-> ;' f+ x5 ~2 U6 S) X& C( O
Query OK, 0 rows affected (0.001 sec)
y; X3 ]' O3 ?, J+ [8 F3 n- `$ A# s* i1 s
MariaDB [(none)]> select * from mysql.global_priv;
. J5 x0 C+ V% ^+-----------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
! w4 ?; t' o; T+ @2 ~8 _| Host | User | Priv |
% ~9 l5 U2 C0 ~6 O$ E9 B+-----------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+. K0 P8 r) @. X, C" ^
| localhost | mariadb.sys | {"access":0,"plugin":"mysql_native_password","authentication_string":"","account_locked":true,"password_last_changed":0} |8 e; G* n1 s( e" X
| localhost | root | {"access": 549755813887, "plugin": "mysql_native_password", "authentication_string": "*C0F9333D119A6BC11CF79C9A12E656EDBBF32052", "auth_or": [{}],"version_id":100527,"password_last_changed":1739545230} |3 Z4 f# ]' J2 g
| localhost | mysql | {"access":18446744073709551615,"plugin":"mysql_native_password","authentication_string":"invalid","auth_or":[{},{"plugin":"unix_socket"}]} |
7 _6 n5 P0 e% r% a- t+-----------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+# E% L- C# k1 H8 e6 j( R
3 rows in set (0.001 sec)
% O& P. o* m1 G$ C R$ J [, H& O9 l4 A! k% `
* ]/ c" D: N/ x
" P$ j" _5 o* U+ ?- x- t' o; M8 c9 [8 l/ W
MariaDB [(none)]> flush privileges;( ?) Y$ D" s* z/ s8 f! ?9 s. X1 n1 e g
Query OK, 0 rows affected (0.001 sec)
3 b/ y) M- h- ^
7 N- K v2 b% G5 Z3 P) yMariaDB [(none)]> select user, plugin from mysql.user;+ f' X r A9 |5 |* k2 E
+-------------+-----------------------+! R v" ?9 z# Z5 y5 x- t
| User | plugin |* ^; U5 O7 c Z
+-------------+-----------------------+
; T3 X6 X e( b) @2 E| mariadb.sys | mysql_native_password |
# @! M! G% Y7 E) s* Y& I3 v| mysql | mysql_native_password |
) z6 B: {- m; C0 A: v| test | mysql_native_password |$ }0 x: f4 l+ l% l( [4 q4 z
+-------------+-----------------------++ v# q1 j* ^( W$ o7 X7 {0 V6 o% [7 d
3 rows in set (0.002 sec)! W: p4 J& [6 h0 l
6 j3 [* E# N' G! z# g7 D3 m
MariaDB [(none)]> FLUSH PRIVILEGES;
2 S" N8 Z9 S1 kQuery OK, 0 rows affected (0.002 sec) U% w, c& d! u4 T
5 U; s+ P+ R7 `5 C" C
/ H$ G/ j& A! ?# c& {MariaDB [(none)]> flush privileges;
8 Z) R& {; G9 x$ d. l) o. y: ^' {Query OK, 0 rows affected (0.001 sec): S9 y* F, F7 \: V5 G3 [
y9 p8 s3 W6 F9 E/ d& [2 U
3 v# [# W- H d& @/ `
MariaDB [(none)]> exit. ~0 i8 a* l1 ]: ^
Bye R# E+ c7 h( G% Z& Z! Z( n
) P% `6 \/ G; @. H) R6 y: X
" S$ Q9 x. Y1 A* _0 c
[root@streamcontrolle ~]# mysql -uroot -p
/ ]1 @* V% M! W5 z: K$ uEnter password: $ A; ~( W1 p* v* G
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)" T- D- r4 p$ x
[root@streamcontrolle ~]# mysql -uroot -p
6 g* H" o; y8 Q$ [4 b; LEnter password:
4 k: H; _; X5 ~6 a+ ?: \ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)3 k: |- H) J; p& }" J
! E- R/ T9 t: ]# C
- L3 h: y3 e6 ^& x2 V
U8 D+ W5 ^) _0 l+ u8 x+ P |
|
发表于 2025-2-15 08:00:01