redhat:database-redhat:start

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
redhat:database-redhat:start [2019/03/08 11:15] – [Der erste Start] michaelredhat:database-redhat:start [2019/03/08 13:22] (current) – [mysqladmin] michael
Line 385: 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.<sxh bash: gutter: false>GRANT ALL PRIVILEGES ON mydatabase.* TO dbuser@localhost IDENTIFIED BY 'dbuserpasswort';</sxh>   - 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.<sxh bash: gutter: false>GRANT ALL PRIVILEGES ON mydatabase.* TO dbuser@localhost IDENTIFIED BY 'dbuserpasswort';</sxh>
   - 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>FLUSH PRIVILEGES;</sxh>   - 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>FLUSH PRIVILEGES;</sxh>
-  - Once these commands have all been executed, we can exit out of the MySQL command prompt by typing: <sxh bash: gutter: false>exit</sxh>+  - Once these commands have all been executed, we can exit out of the MySQL command prompt by typing: <sxh plain: gutter: false>exit</sxh>
  
 <wrap em>ACHTUNG: UM Zugriff mit php auf die mariadb zu erhalten, muss hierfür noch das php-mysql Packet installiert werden!</wrap> <wrap em>ACHTUNG: UM Zugriff mit php auf die mariadb zu erhalten, muss hierfür noch das php-mysql Packet installiert werden!</wrap>
Line 546: 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%>
 <code> <code>
  # mysqladmin  # mysqladmin
 </code> </code>
  
-<WRAP center round box 100%> +<sxh plain; gutter: false;>
-<code>+
 mysqladmin  Ver 9.0 Distrib 5.5.41-MariaDB, for Linux on x86_64 mysqladmin  Ver 9.0 Distrib 5.5.41-MariaDB, for Linux on x86_64
 Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others. Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.
Line 679: Line 679:
   variables             Prints variables available   variables             Prints variables available
   version               Get version info from server   version               Get version info from server
-</code>+</sxh>
 </WRAP> </WRAP>
  
 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%>
 <code> <code>
 # mysqladmin version # mysqladmin version
 </code> </code>
  
-<WRAP center round box 100%> +<sxh plain; gutter: false;>
-<code>+
 mysqladmin  Ver 9.0 Distrib 5.5.41-MariaDB, for Linux on x86_64 mysqladmin  Ver 9.0 Distrib 5.5.41-MariaDB, for Linux on x86_64
 Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others. Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.
Line 700: 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>
 </WRAP> </WRAP>
  
  • redhat/database-redhat/start.1552040109.txt.gz
  • Last modified: 2019/03/08 11:15
  • by michael