Difference between revisions of "MySQL: Memperbaiki Corrupt Database"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) (New page: '''Error:''' Table 'mysql.user' doesn't exist '''Solusi:''' Untuk username root, password 123456 mysqlcheck -u root -p123456 --all-databases --auto-repair) |
Onnowpurbo (talk | contribs) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 4: | Line 4: | ||
'''Solusi:''' | '''Solusi:''' | ||
| + | |||
| + | Ini biasanya karena instalasi mysql tidak beres. | ||
| + | Cara yang manjur: | ||
| + | |||
| + | mysql_install_db --user=mysql | ||
| + | |||
Untuk username root, password 123456 | Untuk username root, password 123456 | ||
mysqlcheck -u root -p123456 --all-databases --auto-repair | mysqlcheck -u root -p123456 --all-databases --auto-repair | ||
| + | |||
| + | |||
| + | ==Pranala Menarik== | ||
| + | |||
| + | * [[Perintah MySQL]] | ||
| + | * [[Instalasi MySQL]] | ||
| + | * [[Linux Howto]] | ||
| + | * [[Backup isi database MySQL]] | ||
| + | * [[Reset Password MySQL]] | ||
| + | * [[Mengatasi Masalah Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock']] | ||
| + | * [[Masalah 'mysqld.sock' yang cukup menjengkelkan]] | ||
| + | * [[MySQL: Memperbaiki Corrupt Database]] | ||
| + | * [[MariaDB]] | ||
| + | |||
| + | |||
| + | [[Category: Linux]] | ||
| + | [[Category: Database]] | ||
Latest revision as of 09:57, 24 December 2012
Error:
Table 'mysql.user' doesn't exist
Solusi:
Ini biasanya karena instalasi mysql tidak beres. Cara yang manjur:
mysql_install_db --user=mysql
Untuk username root, password 123456
mysqlcheck -u root -p123456 --all-databases --auto-repair