Difference between revisions of "MySQL: Memperbaiki Corrupt Database"

From OnnoWiki
Jump to navigation Jump to search
 
Line 14: Line 14:
  
 
  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


Pranala Menarik