|
|
[root@streamcontrolle ~]# mysql -uroot -p8 R8 M- r1 K; w/ r4 J& P
Enter password:
$ e* ]& S% m9 x' h$ M) y0 lWelcome to the MariaDB monitor. Commands end with ; or \g.
8 Y- e* C) I, k4 l$ o% W3 h0 ]Your MariaDB connection id is 16
. V7 n' y& x/ b" MServer version: 10.5.27-MariaDB MariaDB Server7 v1 ^2 W& ]9 r x8 P
6 T+ k7 C4 a# A% f1 ?
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.: r# G7 B8 o+ @* o0 |( a+ I$ Y
, H: x. W/ {/ f1 Q5 _$ Z; GType 'help;' or '\h' for help. Type '\c' to clear the current input statement.% k3 x0 n, O7 j
1 V4 S8 P) a2 n6 h C6 F7 {7 IMariaDB [(none)]> exit* Q* ^/ O6 l1 f" I" F" X6 [# }
Bye
1 t" k% {- x% e+ _( G! k[root@streamcontrolle ~]# mysql -uroot -p
3 G* D. E9 V) y% f# z" sEnter password: % k0 E0 L' d1 ]1 y
Welcome to the MariaDB monitor. Commands end with ; or \g.
6 D+ d9 T9 i2 M/ p( zYour MariaDB connection id is 17
1 ^& H0 f9 _5 x; I0 fServer version: 10.5.27-MariaDB MariaDB Server
3 q) o2 q& B9 r' I7 b) G
, {. H% E7 [) ?$ f- W4 |Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
6 g# Q9 B k* ~. l7 G* M; p# m1 I" K
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
0 C" c5 F1 q x& t9 M; J( C; L4 `# E: c" J8 {+ X
MariaDB [(none)]> select * from mysql.user ;+ d& v' M% t8 ?& L4 t) m
+-----------+-------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+---------+--------------+--------------------+
& y" B+ a# R( X- p7 }8 e| 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 |2 ~2 ?: S8 U9 u# @! e
+-----------+-------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+---------+--------------+--------------------+3 @( d( u8 s6 X$ j; t5 U/ W6 [ k
| 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 | M- N) G" X- ?. E7 s7 R
| 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 |
. A- K+ U2 a# R/ t| % | 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 |
8 H* z' n% q9 w( I5 ~+-----------+-------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+---------+--------------+--------------------+
5 }8 }$ P- T3 [; F" V4 N3 rows in set (0.002 sec)
! \+ i/ M$ T- u% J8 r6 U' H9 l6 t2 P; D, r
MariaDB [(none)]> select * from mysql.user \G;0 B9 c6 f. Y7 u! K9 e
*************************** 1. row ***************************) E: n+ F7 ?- f7 K& y {
Host: localhost$ `* Q6 K/ ?; K! R/ s& n; F2 a. [
User: mariadb.sys
6 V4 W l' c2 j D7 R% }% T Password:
+ q' L" ~3 f: E Select_priv: N
9 o( F* n: [8 p9 ^: I Insert_priv: N2 A5 g) p8 Q0 D# i
Update_priv: N
: g! g4 _- |. |# w+ q Delete_priv: N d+ F+ n7 ~) o" r& J/ \
Create_priv: N
& j% P4 p* V% {: `4 G( W Drop_priv: N
6 e0 @( k% {2 K& x/ q& ^ Reload_priv: N+ z' v+ q+ G1 @) d5 b$ B& J: {
Shutdown_priv: N: Y! T- q6 h/ x' m
Process_priv: N. V( E# P( a A8 Z5 e2 R
File_priv: N# A c3 D7 H- E$ {$ j7 l
Grant_priv: N
7 E9 b- y- o, o: e0 u' F- _ References_priv: N
4 o3 m' A3 w. i; q, ? Index_priv: N
O" [) `( o3 a Alter_priv: N3 R4 Q' l1 y1 ]# d9 }0 Q
Show_db_priv: N; s* E' ^" i# g" m4 A/ {1 N, s% p
Super_priv: N
) p# V. e) m/ W Create_tmp_table_priv: N
+ p( Q( B$ e- ^8 x3 f0 C# _ Lock_tables_priv: N
& z3 `, w# r7 ~! k Execute_priv: N
' g; Z8 }" U: F% Y, W Repl_slave_priv: N& ~' ^& M3 U- J9 n! ~$ u/ I/ |9 l
Repl_client_priv: N2 |- N# G( b J8 q- _& X
Create_view_priv: N" |. M, D: z3 M! i/ ~7 K- m
Show_view_priv: N
8 ~' }! x+ k1 j# U* U4 Q Create_routine_priv: N
/ \1 N. h- F3 G Alter_routine_priv: N
( u8 F1 p" ^( u% A Create_user_priv: N
) W) {( v% l/ r Event_priv: N
' [6 L$ Q: [+ \4 X2 B) X. ^' K) F Trigger_priv: N6 k5 a0 O( ]/ S4 N6 i( ]6 m4 Y" E9 ~
Create_tablespace_priv: N
% a; z6 k5 M$ j+ E/ N; r- ? Delete_history_priv: N
" Z! U# c5 @$ s2 {' l ssl_type: ) p, f6 X) z2 o+ T8 c" Z6 m( i
ssl_cipher:
% o+ f; i9 h$ R' E) J# Q7 ? x509_issuer:
: Z' v W0 C; F S' r2 G x509_subject: * R# e" v, \- u) _& g* y
max_questions: 0: C$ X$ N7 z6 v8 F" D; @5 q6 B
max_updates: 04 v B/ i! F7 F9 Y- f/ t
max_connections: 0 _1 i7 e+ Y. J% X/ w( U
max_user_connections: 0
+ r$ k* B% I0 C& X5 G9 f plugin: mysql_native_password
2 s8 z. q+ x# T. X* y authentication_string:
3 }1 _: m7 v+ ^. p. T& s1 p7 f password_expired: Y; Q. L U6 l& d- a: r& K2 _( V9 U
is_role: N
, {3 q O% S; k: {3 c+ K6 i, R default_role: , O5 ]+ I) ^9 H/ k
max_statement_time: 0.000000
; S( o, n9 X7 g*************************** 2. row **************************** C( Z* {5 q) l' x1 d* T" K
Host: localhost
1 ?. f& Q$ e5 ?* Y+ `5 Y# k User: mysql
& F2 U# ?; ~9 h. w# ? ~ Password: invalid
+ \ X' g# [6 W8 C( i! u( [* `# ^, k9 x Select_priv: Y
7 F( J% _! V1 y+ h Insert_priv: Y
C' ^1 y6 p+ M/ R* d: U Update_priv: Y
) V) r/ o2 F0 _$ b Delete_priv: Y8 ]# p7 F! H: _2 G$ _$ | S
Create_priv: Y; \$ ]7 r, Z1 m% C) t, \8 M
Drop_priv: Y
( w; l7 R) T! ? Reload_priv: Y j7 {2 P2 ]* b6 M
Shutdown_priv: Y
4 n/ @% B" f; u& b" }3 F( g Process_priv: Y
! f: s% @- `2 }( o File_priv: Y4 o2 c7 r0 i) [1 f' \* D# `1 x
Grant_priv: Y
% R& I3 T: _+ G# N1 S( n+ Z) s References_priv: Y$ v& N0 }/ Y! F
Index_priv: Y$ v# x* ?9 F, r; O
Alter_priv: Y
6 e* V% {. J1 @& g6 G+ \ Show_db_priv: Y; W w5 W( c. W! F' m# Y$ `8 o" o
Super_priv: Y6 _& o& O" y4 I8 _, A. l1 D
Create_tmp_table_priv: Y; a7 M! ]+ u |& H0 I! W0 X
Lock_tables_priv: Y1 W8 ]; |" n9 E8 [" R. |
Execute_priv: Y/ p. f) N4 j$ z* m% D9 A
Repl_slave_priv: Y
- W' a' c( E0 K. L$ n Repl_client_priv: Y. k% O/ q& n8 X" g
Create_view_priv: Y
- m- e4 O. P2 ^6 o/ | Show_view_priv: Y- J% z, K" @4 k0 e% |) m$ n; k5 U
Create_routine_priv: Y
* r) h; g& d- s) T4 i- |) S Alter_routine_priv: Y! R. I5 r$ w9 _2 w/ }( n V8 b
Create_user_priv: Y& N6 c* @7 {7 m3 h
Event_priv: Y
& `6 y! J5 Z$ ^; j& ?+ w Trigger_priv: Y
; H# @4 N. ?0 w6 l6 QCreate_tablespace_priv: Y
* L/ j% c# Y" n0 {7 J$ o Delete_history_priv: Y
$ H' ^# Y3 c: _ ^: G) G# K! X) M ssl_type:
9 B& ~9 b3 X8 z. |2 c ssl_cipher:
% Z: L" ]( {& s+ H x509_issuer:
- k1 ^& G/ Q5 r4 n x509_subject:
3 i/ p8 U) q1 X max_questions: 0& O, d7 E. l o( E, k
max_updates: 0
, b" s! J3 s. c8 {- O$ | }7 R max_connections: 0
7 U/ ?" c: M6 |; z% w' W5 x0 S max_user_connections: 02 P4 w3 s4 u; U+ K
plugin: mysql_native_password
1 M& u8 Y3 f4 {" [2 p authentication_string: invalid! O) n8 v; e* i
password_expired: N1 l; @7 L$ W# _9 |" v! c1 m! U
is_role: N
( n' v, ~2 i1 L ^9 a( H default_role: : J( z& C! W) C; `2 o" Z
max_statement_time: 0.000000& q n% Z# `, k# J8 y8 @/ \. E
*************************** 3. row ***************************6 C* a' L+ h: z9 d- b
Host: %2 q2 K2 y) ^/ i+ V
User: test' u$ N. B; v7 a. w# c C( N+ R. G
Password: *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29& U' d1 b+ w! m0 e/ M1 s6 W1 S
Select_priv: N
$ _8 s7 n# g$ T Insert_priv: N
W3 A9 {6 Y* V3 u9 ^ Update_priv: N
! s: ]* L' b5 D% T9 ?: K Delete_priv: N
9 p7 c6 Q; K( ]5 F9 s+ U) H Create_priv: N* p1 k' Y8 a/ S
Drop_priv: N
+ }; s4 f0 ?7 g; t Reload_priv: N @% g, q2 W+ ?0 |$ g8 S
Shutdown_priv: N
4 l, B4 U( L; @" g! u Process_priv: N
J, u" C& [# M4 U+ J2 O3 V8 ` File_priv: N
3 _8 B; s. |( q# \ Grant_priv: N
- T7 E" b1 d' p# i4 a3 F References_priv: N
0 `+ e) U, z9 B. M& | n Index_priv: N
- ?0 _! W# Z3 a. y% B Alter_priv: N+ k: D3 s( I, k6 z( F& {* x! X
Show_db_priv: N
& A$ Z) a6 _+ f: v Super_priv: N- G. c4 `4 a/ o0 n( i, {
Create_tmp_table_priv: N$ [; {; H- Y1 z, k
Lock_tables_priv: N! R! j1 v' j M5 }9 J
Execute_priv: N
3 [7 i6 F) ?% s. C A* ^* u$ h Repl_slave_priv: N' O6 j. H: ~, g. P! z
Repl_client_priv: N) I& L: b; @7 g$ _" w% [. n w
Create_view_priv: N
& j( @5 M2 [! s( W2 m0 a+ P0 d% _ Show_view_priv: N
+ ~2 `6 m/ m0 |4 V Create_routine_priv: N
/ @" W4 r) d6 W Alter_routine_priv: N5 u8 ]2 b8 ^$ s+ r6 b$ q* U
Create_user_priv: N5 m6 w# k% i/ w1 N' s- L. G# c
Event_priv: N
) L$ l( ~3 P/ ? Trigger_priv: N" N' z# w! t9 | e
Create_tablespace_priv: N
3 S. F) P* ~8 M. |% r. r Delete_history_priv: N
# g; O; }& x: h: o. v4 a! G ssl_type:
, v& c, l: V% @' y6 e ssl_cipher:
- i1 v/ F2 E( F! @7 C x509_issuer: 3 y! K& _1 R7 K# u4 l W1 |, `
x509_subject: 7 h) ^- t6 Q" I) j) x$ t! v
max_questions: 06 [3 b2 X7 v) B: N& s/ [
max_updates: 0' A+ s$ U, x& Y" ~% _) L/ d& [2 J2 F
max_connections: 04 O7 |: D+ T9 x# l/ M6 [! K* |
max_user_connections: 0
1 r: {! e7 u8 m6 c$ Z9 ?, ?1 e plugin: mysql_native_password
4 A% Z9 _$ u3 v+ F; B9 ~7 E authentication_string: *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29
( s1 U7 s8 [/ g, s4 [ password_expired: N
z# H/ m ~; [& I is_role: N! b8 O1 Y. Y6 ^3 v" `
default_role: ! L& P; }, V( @& R7 @' |
max_statement_time: 0.000000
5 t" s% z q# L6 E+ h$ i! `4 }$ V3 rows in set (0.002 sec)2 B2 R3 }( F9 T: z
/ Y( x* s8 m0 O: g# k3 I
ERROR: No query specified# a3 r+ e( S$ m. N- d* g8 a* S
% v' X7 z, B% o* N4 F# FMariaDB [(none)]> show variables like 'sql_safe%';$ k5 L' S' g' x' O- G7 u7 A6 F
+------------------+-------+
9 @* ?" N+ E" T( W+ s" ]3 || Variable_name | Value |+ d! W4 c# @- F
+------------------+-------+, ~& u- b- u; R: w ^
| sql_safe_updates | OFF |5 }4 D. z: b: Z" p; G
+------------------+-------+# Z! M; S' a: G) e! p/ z3 h
1 row in set (0.002 sec)5 a/ W8 e9 h# g0 R
3 ]' z" u! y, Z. j0 K) ?( u% ?
MariaDB [(none)]> select * from global_priv \G;
# z+ @' b7 J9 f' u! h9 H6 YERROR 1046 (3D000): No database selected
; S5 ^. E" d9 ^$ JERROR: No query specified
2 n/ Y. s8 u4 |1 W( u' P! e2 q9 I$ Z. d: K& x! m0 m3 z
MariaDB [(none)]> select * from mysql.global_priv \G;) ?4 I) E# K$ A- B2 U. Y
*************************** 1. row ***************************
) E( I7 p2 j! H7 z& Z, i* RHost: localhost: X0 S& M$ F5 Y) v$ o: S
User: mariadb.sys
* f. h+ n5 N* K) r, yPriv: {"access":0,"plugin":"mysql_native_password","authentication_string":"","account_locked":true,"password_last_changed":0}) j/ g& ?( w$ O1 {7 a
*************************** 2. row ***************************
9 O8 k5 T4 G4 |( H9 J A8 `Host: localhost
& g. A1 a" c0 g6 r3 N. yUser: mysql0 A5 l" q% o9 t0 v, P
Priv: {"access":18446744073709551615,"plugin":"mysql_native_password","authentication_string":"invalid","auth_or":[{},{"plugin":"unix_socket"}]}0 G' Y3 W5 Q7 C% r# A4 H1 s
*************************** 3. row ***************************
, T9 m4 |5 g- D4 E8 FHost: %
( o: P- Z2 _1 }; A) Q1 NUser: test# G; a: E! ?$ {! q; H+ e) {; K
Priv: {"access":0,"version_id":100527,"plugin":"mysql_native_password","authentication_string":"*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29","password_last_changed":1739522769} W1 k$ t U: U8 L5 ]' ?& l
3 rows in set (0.001 sec)
2 o/ I4 g9 s* n* R+ A0 P
7 e2 a- B6 R+ d, P. vERROR: No query specified3 Z# ^7 p0 u& F
. ~5 t7 X: ?9 E# i/ ]
MariaDB [(none)]> select * from mysql.global_priv ;& Y: U3 K0 Q4 a. f
+-----------+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
7 V o, R8 E, d3 a8 }" f| Host | User | Priv |) _4 V9 Z( u: E5 b8 B; ~6 ?& y! J
+-----------+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+2 S/ c( I: Q+ [; M" m! q n
| localhost | mariadb.sys | {"access":0,"plugin":"mysql_native_password","authentication_string":"","account_locked":true,"password_last_changed":0} |: S" W2 w) c, j) t( S
| localhost | mysql | {"access":18446744073709551615,"plugin":"mysql_native_password","authentication_string":"invalid","auth_or":[{},{"plugin":"unix_socket"}]} |
# f8 Q8 p6 ^) h) [$ @| % | test | {"access":0,"version_id":100527,"plugin":"mysql_native_password","authentication_string":"*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29","password_last_changed":1739522769} |
5 c9 w3 y" g. ^$ Z; T# n: G7 u+-----------+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
5 o* i+ f( X* H8 w6 i3 rows in set (0.001 sec)
& l1 h' J' m$ r5 V( Y. w; |* u6 }4 _. _$ r8 G% \
( V' J0 a! s) J( MMariaDB [(none)]> select * from mysql.global_priv; X- n% x! D I) t
+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
4 d5 K8 n" H P4 K* k9 y3 ^4 l| Host | User | Priv |
' }1 }8 O& W& x) c+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+$ B- h3 d+ B( z1 q7 l, c8 X
| localhost | mariadb.sys | {"access":0,"plugin":"mysql_native_password","authentication_string":"","account_locked":true,"password_last_changed":0} |
# P7 e+ n. o! h3 w" I" r& U& @8 V| localhost | root | {"access": 18446744073709551615, "plugin": "mysql_native_password", "authentication_string": "*C0F9333D119A6BC11CF79C9A12E656EDBBF32052", "auth_or": [{}, {"plugin": "unix_socket"}]} |
! J" M2 E- }& @- S1 v8 e| localhost | mysql | {"access":18446744073709551615,"plugin":"mysql_native_password","authentication_string":"invalid","auth_or":[{},{"plugin":"unix_socket"}]} |
9 H7 b2 v' h3 Q3 e+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
$ @ R V9 [+ V: S3 rows in set (0.001 sec)* e# Q( A% E7 A9 r6 ` z$ O
; f$ o4 K9 G8 ?6 K( f* p" k8 ~1 lMariaDB [(none)]> ALTER USER root@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD("xxxxxxx123")6 I5 y) _3 {2 o6 {( B
-> ;
! A8 ]* ~* u$ w# R6 g: BQuery OK, 0 rows affected (0.001 sec)& k: B( Y9 E6 C; Z
$ V- N4 H; p$ S5 A& aMariaDB [(none)]> select * from mysql.global_priv;
l. |2 W$ g" k2 ]8 m+-----------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+* e" i( z/ y: [! M2 u
| Host | User | Priv |" d: h! c5 z0 |" z0 ^
+-----------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
_3 x7 e5 p; A: P| localhost | mariadb.sys | {"access":0,"plugin":"mysql_native_password","authentication_string":"","account_locked":true,"password_last_changed":0} |, g* B$ l4 s/ S# v1 ]/ |
| localhost | root | {"access": 549755813887, "plugin": "mysql_native_password", "authentication_string": "*C0F9333D119A6BC11CF79C9A12E656EDBBF32052", "auth_or": [{}],"version_id":100527,"password_last_changed":1739545230} |* G0 y7 Q D3 w/ I' j Z" i
| localhost | mysql | {"access":18446744073709551615,"plugin":"mysql_native_password","authentication_string":"invalid","auth_or":[{},{"plugin":"unix_socket"}]} |- ^" d9 H+ ^. x# y0 j% G* o
+-----------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+3 ^/ J. E" I5 Q5 M
3 rows in set (0.001 sec)
5 H5 a1 b/ I% n ]- ]+ u* _3 o4 ^2 t2 z) k
7 I" d# l1 [2 X/ S0 t& L: F2 ]; s8 y3 i7 _; F. t: [! a% _
9 m7 N7 H+ m5 O% [8 j
MariaDB [(none)]> flush privileges;
( K) k o" Y) p3 ]- w1 K( {, J! YQuery OK, 0 rows affected (0.001 sec)- [ N" Y. b6 i, r/ v
8 \/ F+ `, i$ z [5 M& R8 F0 pMariaDB [(none)]> select user, plugin from mysql.user;5 v/ O' {* P. C3 V/ l
+-------------+-----------------------+
y$ {) s: T' l| User | plugin |
5 K7 Q* o/ ^3 U, Z' {+-------------+-----------------------+
5 C' t( [" K x; l; B| mariadb.sys | mysql_native_password |5 |, i; T& E' V, Q4 w( s
| mysql | mysql_native_password |
2 B* y. S3 Q; k9 ], k) _! E| test | mysql_native_password |
5 Y) H: z9 x6 R0 w! ^+-------------+-----------------------+
4 ~0 a, i! D2 ~' @# l+ G3 rows in set (0.002 sec)7 `0 L% P& F) O- k8 ]6 t3 t
5 x W5 L, Y8 G* M* t3 RMariaDB [(none)]> FLUSH PRIVILEGES;
* O8 Z. Q- F) f, p* R+ x; qQuery OK, 0 rows affected (0.002 sec)+ j, e( k& R) Q) z; r h, I
: E: E8 k3 ]) C, m1 I+ q" M
2 B r/ ~. P- D6 s/ k& o8 U8 O3 SMariaDB [(none)]> flush privileges;
" V' q' ?: P, CQuery OK, 0 rows affected (0.001 sec)2 Q4 }/ G2 f* x6 T* K) u! [: B
, Y8 W9 Z" v( g
. R, d9 }. G2 y- `8 V4 ?5 TMariaDB [(none)]> exit O, @. V7 G1 x" O3 q: U6 X
Bye8 J6 E* ^$ ^/ [
& D L& n" V& p- Y7 [
8 }. @5 l/ ~0 l! A- K[root@streamcontrolle ~]# mysql -uroot -p
. ~$ C% H! z" \0 r6 F% QEnter password:
- f u$ ^: u1 t+ j4 P7 R" fERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
2 y9 O$ T( x7 B6 M3 K[root@streamcontrolle ~]# mysql -uroot -p8 s7 z! {; o5 ]2 Q3 x
Enter password:
( |& ?9 X* G& ?ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
5 F1 G6 p# B! E# k
1 P2 x8 y' E1 ? ]5 M5 p
) S$ d; M4 r! Z0 E0 @
5 b0 |2 E- V- j7 [7 w |
|
发表于 2025-2-15 08:00:01