This shows you the differences between two versions of the page.
mysql [2014/01/05 09:07] mh |
mysql [2014/09/10 21:22] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | Datenbank anlegen | ||
- | <code> | ||
- | > mysql --user=root mysql --password='pwd' | ||
- | |||
- | mysql> create database wordpress; | ||
- | |||
- | |||
- | mysql> GRANT ALL PRIVILEGES ON wordpress.* TO wp@localhost IDENTIFIED BY 'pwd' WITH GRANT OPTION; | ||
- | Query OK, 0 rows affected (0.03 sec) | ||
- | </code> | ||
- | |||
- | |||
- | Kaputte/gecrashte mysql Tables reparieren | ||
- | |||
- | <code> | ||
- | myisamchk wp_*.MYI > /tmp/out | ||
- | myisamchk -r wp_comments.MYI | ||
- | myisamchk -r wp_options.MYI wp_ratings.MYI wp_sfsettings.MYI wp_sftopics.MYI wp_sftrack.MYI | ||
- | </code> |