Latest News
Đẩy log exception của spring boot lên elasticsearch
  • About
  • EmEditor
  • Register Google Adsense

Love Coding

Note anything I want

  • Home
  • Web Development
    • HTML
    • Javascript
    • jQuery
    • CSS
    • PHP
    • ASP
    • JSP
    • Fix Bug
  • Other Development
    • Desktop Java
    • Mobile J2ME
    • VBS
  • Operating System
    • Windows
    • Linux
  • Database
    • MySQL
    • Oracle
  • Software
Home » MySQL » Love Coding: Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and should be repaired

Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and should be repaired

HuyPV
Add Comment
MySQL
Friday, October 4, 2013
Problem:
C:\huypv>net start mysql
The mysql service is starting.
The mysql service could not be started.

#eventvwr
A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.

# mysql error log
Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and should be repaired
For more information, see Help and Support Center at http://www.mysql.com.

Solved:
Edit file my.ini
Add line
innodb_force_recovery = 1
for [mysqld]

Start MySQL server with option --skip-grant-tables

Use MySQL client:
check table user;
repair table user;

Stop MySQL. Remove appended line in my.ini. Start MySQL server again, without option --skip-grant-tables
Tweet
Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and should be repaired Title: Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and should be repaired
Description: Problem: C:\huypv>net start mysql The mysql service is starting. The mysql service could not be started. #eventvwr A system error h... ...
Rating: 4

No comments :

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments ( Atom )
Quảng cáo

Popular Posts

  • VBS - Upload file HTTP Post
    Source: http://www.ericphelps.com/scripting/samples/Reference/Web/HTTP_POST.txt   Sub Upload(strUploadUrl, strFilePath, strFileField, strD...
  • Add other collapse div to your forum
    Collapse <div style="height: 16px; padding-right: 4px; font-weight: bold;" class="blockhead"> <span style=...
  • Use the YouTube API with PHP
    Process and integrate data from YouTube into your PHP application with PHP's SimpleXML extension Summary:   The YouTube vide...
  • Check Laravel version
    Đối tác bảo đang code và dùng Laravel, giờ muốn biết version Laravel tương ứng là bao nhiêu để xem mà code theo. Làm sao check? Cách 1: Sử...
  • Hàm chuyển từ ngày dương lịch sang âm lịch (PHP)
    <?php function INT($d) {     return floor($d); } function jdFromDate($dd, $mm, $yy) {     $a = INT((14 - $mm) / 12);     $y = $yy + 4800 ...
  • Trong laravel thì queue:work với queue:listen khác nhau thế nào?
    Trong laravel thì queue:work với queue:listen đều chạy jobs trong queue. Vậy 2 cái này cũng phải có gì đó khác nhau chứ, nếu ko thì nó là ...
  • Character Set và Collation trong MySQL là gì? Tạo DB thì để UTF8_GENERAL_CI hay UTF8_BIN
    Character Set là một tập các ký tự và dạng số hóa của các ký tự đó Collation là một tập các luật để so sánh các xâu được sinh ra từ các ký ...
  • git checkout file from other branch
    Đang làm trên nhánh dev. Muốn lấy 1 file, ví dụ: xxx/helper.php ở trên nhánh master về dev thì làm thế nào? Cách 1: nông dân nhiều bước nh...
  • mysql_error: Undeclared variable: INF
    mysql_error: Undeclared variable: INF PHP Code: $limit = 10; $page = isset($_GET['p']) ? $_GET['p'] : 1; $offset = ($pa...
  • Download media files (video, audio) from VnExpress.Net
    Download media files (video, audio) from VnExpress.Net Example: http://vnexpress.net/GL/Vi-tinh/Giai-tri/2010/02/3BA18A0E/page_4.asp htt...
Back to top!
Copyright 2010 Love Coding - All Rights Reserved Design by Newbie_PC - Powered by Blogger