equal
deleted
inserted
replaced
4 MySQL/MariaBD. |
4 MySQL/MariaBD. |
5 ================ |
5 ================ |
6 .. contents:: |
6 .. contents:: |
7 :local: |
7 :local: |
8 |
8 |
9 SQL clients. |
9 SQL clients |
10 ============ |
10 =========== |
11 |
11 |
12 https://mariadb.com/kb/en/mariadb/clients-and-utilities/ |
12 https://mariadb.com/kb/en/mariadb/clients-and-utilities/ |
13 Clients and Utilities. |
13 Clients and Utilities. |
14 https://mariadb.com/kb/en/mariadb/graphical-and-enhanced-clients/ |
14 https://mariadb.com/kb/en/mariadb/graphical-and-enhanced-clients/ |
15 Graphical and Enhanced Clients. |
15 Graphical and Enhanced Clients. |
16 |
16 |
17 mysql. |
17 mysql |
18 ------ |
18 ----- |
19 |
19 |
20 Official client. Install ``mariadb-client`` package - ``mysql`` utility |
20 Official client. Install ``mariadb-client`` package. |
21 will be installed with dependent package. |
|
22 |
21 |
23 Usage:: |
22 Usage:: |
24 |
23 |
25 $ mysql -u $USER -p |
24 $ mysql -u $USER -p |
26 Enter password: <== Type password. |
25 Enter password: <== Type password. |
27 |
26 |
|
27 $ mysql --host=$HOST --user=$USER --password=$PASS |
|
28 $ mysql --host=$HOST --user=$USER --password=$PASS $DATABASE |
|
29 |
28 To save content of session interaction in ``mysql`` use:: |
30 To save content of session interaction in ``mysql`` use:: |
29 |
31 |
30 mysql> tee out.txt |
32 mysql> tee out.txt |
31 |
33 |
32 mycli. |
34 mycli |
33 ------ |
35 ----- |
34 |
36 |
35 Python command line client with completion. Usage:: |
37 Python command line client with completion. Usage:: |
36 |
38 |
37 $ mycli -u $USER |
39 $ mycli -u $USER |
38 Password: <== Type password. |
40 Password: <== Type password. |