MySQL: Memperbaiki Corrupt Database: Difference between revisions

From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs)
No edit summary
Onnowpurbo (talk | contribs)
No edit summary
 
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 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


Pranala Menarik