Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| redhat:database-redhat:start [2019/03/08 11:05] – michael | redhat:database-redhat:start [2019/03/08 13:22] (current) – [mysqladmin] michael | ||
|---|---|---|---|
| Line 179: | Line 179: | ||
| </ | </ | ||
| - | Möchten wir überprüfen, | + | <panel type=" |
| - Daemon Überprüfung mit **systemctl**: | - Daemon Überprüfung mit **systemctl**: | ||
| | | ||
| Line 205: | Line 205: | ||
| </ | </ | ||
| </ | </ | ||
| + | </ | ||
| ---- | ---- | ||
| Line 384: | Line 385: | ||
| - At this point, you have a database and user account that are each specifically made for our new environment. However, the user has no access to the database. We need to link the two components together by granting our user access to the database.< | - At this point, you have a database and user account that are each specifically made for our new environment. However, the user has no access to the database. We need to link the two components together by granting our user access to the database.< | ||
| - Now that the user has access to the database, we need to flush the privileges so that MySQL knows about the recent privilege changes that we've made: <sxh bash: gutter: false> | - Now that the user has access to the database, we need to flush the privileges so that MySQL knows about the recent privilege changes that we've made: <sxh bash: gutter: false> | ||
| - | - Once these commands have all been executed, we can exit out of the MySQL command prompt by typing: < | + | - Once these commands have all been executed, we can exit out of the MySQL command prompt by typing: < |
| <wrap em> | <wrap em> | ||
| Line 545: | Line 546: | ||
| Mit Hilfe des Hilfsprogrammes **mysqladmin** aus dem Clientpaket **mysql** können umfangreiche Abfrage gegen unsere Datenbank durchgeführt werden. Startet man das Programm ohne weitere Angaben von Optionen, werden die möglichen Optionen am Bildschirm ausgegeben. | Mit Hilfe des Hilfsprogrammes **mysqladmin** aus dem Clientpaket **mysql** können umfangreiche Abfrage gegen unsere Datenbank durchgeführt werden. Startet man das Programm ohne weitere Angaben von Optionen, werden die möglichen Optionen am Bildschirm ausgegeben. | ||
| + | <WRAP center box 100%> | ||
| < | < | ||
| # mysqladmin | # mysqladmin | ||
| </ | </ | ||
| - | <WRAP center round box 100%> | + | <sxh plain; gutter: false;> |
| - | <code> | + | |
| mysqladmin | mysqladmin | ||
| Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others. | Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others. | ||
| Line 678: | Line 679: | ||
| variables | variables | ||
| version | version | ||
| - | </code> | + | </sxh> |
| </ | </ | ||
| So können wir z.B. auch die verwendete Version von **MariaDB** abfragen. | So können wir z.B. auch die verwendete Version von **MariaDB** abfragen. | ||
| + | <WRAP center box 100%> | ||
| < | < | ||
| # mysqladmin version | # mysqladmin version | ||
| </ | </ | ||
| - | <WRAP center round box 100%> | + | <sxh plain; gutter: false;> |
| - | <code> | + | |
| mysqladmin | mysqladmin | ||
| Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others. | Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others. | ||
| Line 699: | Line 700: | ||
| Threads: 1 Questions: 27 Slow queries: 0 Opens: 1 Flush tables: 2 Open tables: 27 Queries per second avg: 0.002 | Threads: 1 Questions: 27 Slow queries: 0 Opens: 1 Flush tables: 2 Open tables: 27 Queries per second avg: 0.002 | ||
| - | </code> | + | </sxh> |
| </ | </ | ||