{"id":1257,"date":"2025-09-13T17:09:34","date_gmt":"2025-09-13T15:09:34","guid":{"rendered":"https:\/\/pcmacb.de\/?page_id=1257"},"modified":"2025-09-18T13:44:53","modified_gmt":"2025-09-18T11:44:53","slug":"mysql-mariadb","status":"publish","type":"page","link":"https:\/\/pcmacb.de\/?page_id=1257","title":{"rendered":"mysql mariadb"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>mysql -u root -p<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW DATABASES;<\/code><\/pre>\n\n\n\n<p>database l\u00f6schen<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP DATABASE exampledb;<\/code><\/pre>\n\n\n\n<p>alle user auflisten<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT User, Host FROM mysql.user;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>SET PASSWORD FOR 'typo3user'@'localhost' = PASSWORD('NewStrongPassword!');\nFLUSH PRIVILEGES;<\/code><\/pre>\n\n\n\n<p>user l\u00f6schen<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP USER 'exampleuser'@'localhost';<\/code><\/pre>\n\n\n\n<p>Datenbanken bearbeiten<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>USE mydatabase;<\/code><\/pre>\n\n\n\n<p>To verify which database is currently selected<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>SELECT DATABASE();<\/code><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>database l\u00f6schen alle user auflisten user l\u00f6schen Datenbanken bearbeiten To verify which database is currently selected<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"class_list":["post-1257","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/pcmacb.de\/index.php?rest_route=\/wp\/v2\/pages\/1257","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pcmacb.de\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pcmacb.de\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pcmacb.de\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/pcmacb.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1257"}],"version-history":[{"count":6,"href":"https:\/\/pcmacb.de\/index.php?rest_route=\/wp\/v2\/pages\/1257\/revisions"}],"predecessor-version":[{"id":1318,"href":"https:\/\/pcmacb.de\/index.php?rest_route=\/wp\/v2\/pages\/1257\/revisions\/1318"}],"wp:attachment":[{"href":"https:\/\/pcmacb.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}