1067 error occurred while starting MySQL

Source: Internet
Author: User

0. Open mysql\bin\my.ini, look for [mysqld], add a line of text under [Mysqld], Skip-grant-tables is composed of [mysqld] skip-grant-tables "I pass this method once success"

Method One: 1, open My.ini file, find Default-storage-engine=innodb this line, change it to Default-storage-engine=myisam.

2. Remove Ib_logfile0 and Ib_logfile1 from the data directory in the MySQL installation directory

3. Locate the Infodb directory that you specified when configuring the MySQL server to remove ibdata1

According to the My.ini file:

#*** INNODB Specific Options * * * innodb_data_home_dir= "d:/". 4. Restarting the service for MySQL

    1. 3

Method Two:

Reload MySQL, always prompt "Unable to start the MySQL service, error 1067 process unexpectedly stop restarting, repair the registry is useless, on-line check, change what basedir, also useless I use is mysql5.8, find to go to, remember before loaded wampserver,pc_ Webserver and other integrated environments, these software will My.ini, php.ini written to c:windows directory, and set as read-only

Workaround:

Remove the My.ini file from the Windows directory,

Reload MySQL, service started successfully

    1. 4

Method Three:

1. Execute winmysqladmin, generate My.ini file 2, mysqld-install start MySQL service 3, net start MySQL service display normal when the server is not started by mysql-u Root-p connection Error, look at the Server service, do not start the MySQL service, manual start to produce 1067 errors, reinstall several times MySQL, error is still. No errors are observed for each configuration.

My system environment win2003 MySQL version 4.0.12 solution, will winmysqladmin generated My.ini copy to C:windows and start MySQL all OK. This has not been tried: actually do not need to reconfigure you just click Mysql.exe in the/bin directory

Mysqld.exe

Mysqld-nt.exe

Winmysqladmin.exe

When the cue box appears, cancle it out directly.

Then click on Winmysqladmin.exe to select the start service on the small icon on the right.

    1. 5

The last trick: Turn off Wamp, and then open your download good Wampserver installation package, to install, directly overwrite the previous installation files, so that the configuration problem of MySQL directly automatically fixed, start MySQL, is not found to go in?

    1. 6

Ok,mysql appearance of this problem is almost such a fix, the relevant method of course is also through a lot of information to find, here to share, I hope to help everyone!

1. In the bottom left search (Cortana) enter MySQL into MySQL command prompt to enter the password and then build the table   must first work in a database, so you must create a database. Using CREATE DATABASE + (database name), come out creating databases   Create well must use it, take advantage of using + (database name)   Statements   You can familiarize yourself with the statements that show the database and see how many databases you have created  show databases;   can then create a table. Using the CREATE TABLE + (table name)    create table Employee (    id int primary KEY,      name varchar (+),     age int    );   If you say ' Query OK ', you have created a good form. Remember the Guide Pack Mysql-connector-java-5.1.28-bin.jar package com. JDBC; Import java.sql.*; Use JDBC to access SQL Server (or MySQL)/* First create Employee table  * CREATE TABLE Employee ( id int primary KEY,  name varchar (2 0),  age int);  */public class Test {

 /**   * @param args   * @throws Exception   */ public static void Main (string[] args) throws Cl assnotfoundexception {  //JDBC Four configuration parameters  // string Driverclassname = " Com.microsoft.sqlserver.jdbc.SQLServerDriver ";  // string url = "jdbc:sqlserver://localhost:1433; Databasename=gy ";   string driverclassname = "Com.mysql.jdbc.Driver";   string url = "JDBC:MYSQL://LOCALHOST:3306/MYDB1";   string username= "root";   string password= "123456";   connection conn = null;   statement stmt = null;   resultset rs = null;   try{   class.forname (driverclassname);//Register driver   do only once    conn = Drivermanager.getconnection (Url,username,password);//Establish connection    stmt = Conn.createstatement ();// Create an Execute SQL statement,    stmt.execute ("INSERT into Employee values (1, ' hubin ', ' 22 ')");//EXECUTE statement     Stmt.execute ("INSERT INTO EmployeeVALUES (2, ' Xiaomi ', ') '),//   rs  =stmt.executequery ("SELECT * from Employee");    while (Rs.next ()) {    system.out.println (Rs.getint (1) + "" + rs.getString (2) + "+rs.getint (3));//processing execution result    }   }catch (SQLException e) {   throw new RuntimeException (e);   }finally{   try{                  if (Rs!=null) rs.close ();     if (Stmt!=null) stmt.close ();     IF (conn!=null) Conn.close ();     }catch (SQLException e) {     system.out.println (E.getmessage ());    }   }  }  

}

2.mysql and MySQL Workbench relationship is the time to build a table is a mouse click, one is input command line

1067 error occurred while starting MySQL

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.