MySQL: Memperbaiki Corrupt Database: Difference between revisions
From OnnoCenterWiki
Jump to navigationJump 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) No edit summary |
||
| (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 02: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
