{"id":32,"date":"2007-07-07T14:11:24","date_gmt":"2007-07-07T12:11:24","guid":{"rendered":"http:\/\/www.hermione.de\/blog\/?p=32"},"modified":"2009-04-12T20:55:15","modified_gmt":"2009-04-12T18:55:15","slug":"mysql-server","status":"publish","type":"post","link":"http:\/\/blog.hermione.de\/?p=32","title":{"rendered":"mysql server"},"content":{"rendered":"

mysql server installieren<\/h4>\n

apt-get install mysql<\/em>
\nmysqladmin -u root password geheim<\/em><\/p>\n

CREATE DATABASE xy;
\nGRANT ALL PRIVILEGES ON xy.* TO „christine“@“localhost“ IDENTIFIED BY ‚blub‘;
\noder besser gleich so […] WITH GRANT OPTION;<\/p>\n

grmpfl<\/h4>\n

\/usr\/sbin\/mysqld –skip-grant-tables
\nmysql>use mysql;
\nmysql>update users set password = password(‚geheim‘) where user=“root“;<\/em>
\nDann mysql wieder normal starten (\/etc\/init.d\/mysql start)!<\/p>\n

database dumpen und wieder aufspielen<\/h4>\n

mysqldump datenbank -h db_host -u dbuser -p > sicherung.sql<\/em>
\nmysql -u dbuser datenbank -p < sicherung.sql<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

mysql server installieren apt-get install mysql mysqladmin -u root password geheim CREATE DATABASE xy; GRANT ALL PRIVILEGES ON xy.* TO „christine“@“localhost“ IDENTIFIED BY ‚blub‘; oder besser gleich so […] WITH GRANT OPTION; grmpfl \/usr\/sbin\/mysqld –skip-grant-tables mysql>use mysql; mysql>update users set password = password(‚geheim‘) where user=“root“; Dann mysql wieder normal starten (\/etc\/init.d\/mysql start)! database dumpen und […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"_links":{"self":[{"href":"http:\/\/blog.hermione.de\/index.php?rest_route=\/wp\/v2\/posts\/32"}],"collection":[{"href":"http:\/\/blog.hermione.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.hermione.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.hermione.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.hermione.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=32"}],"version-history":[{"count":0,"href":"http:\/\/blog.hermione.de\/index.php?rest_route=\/wp\/v2\/posts\/32\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.hermione.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=32"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.hermione.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=32"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.hermione.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=32"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}