User Tools

Site Tools


mysql

Differences

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

Link to this comparison view

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>​ 
mysql.txt ยท Last modified: 2014/09/10 21:22 (external edit)