Non-installed Mysql versions

Non-installed Mysql versions
1. Decompress

Decompress the package as follows;

2. Create my. ini

My. ini

[Mysql] # set the default character set of the mysql client default-character-set = utf8 [mysqld] # set port 3306 to port 3306 # set the mysql installation directory basedir = C: \ mysql-5.6.24-win32 # Set the mysql database data storage directory datadir = C: \ mysql-5.6.24-win32 \ data # maximum number of connections allowed max_connections = 200 # the character set used by the server defaults to an 8-bit latin1 character set character-set-server = utf8 # The default storage that will be used when creating a new table engine default-storage-engine = INNODB

Run a console as an administrator

4. Install and start the service

Mysqld install service successful

Net start mysql failed to start the service

5. Go to the Event Viewer to view related errors

The following information is available:

Plugin "InnoDB 'registry as a storage engine failed.
InnoDB:. \ ibdata1 can't be opened in read-write mode

Change storage engine

Default-storage-engine = MYISAM

Nor are they good;

6. For mysql 1067 cannot be started. 1. Extract the related online discussion;

MySQL cannot be started in windows. Error 1067

Wampsever is in use. When logging on to mysql suddenly, access is forbidden or the database cannot be connected. Return to the service, open wampmysqld, and find that "windows cannot start MySQL service error 1067", it cannot be started. What should I do?
Method/step
1
Error 1067 when wampmysqld is started
MySQL cannot be started in windows. Error 1067
2
Method 1: 1. Open the my. ini file, find default-storage-engine = InnoDB, and change it to default-storage-engine = MyISAM.
2. Delete ib_logfile0 and ib_logfile1 in the Data directory under the MySQL installation directory.
3. Find the specified InfoDB directory when configuring the MySQL server and delete ibdata1
According to the my. ini file:
# *** INNODB Specific options *** innodb_data_home_dir = "D :/". 4. Restart MySQL Service

3
Method 2:
When I reinstall mysql, I always prompt "the MYSQL service cannot be started, error 1067 process unexpectedly stops restarting, And it is useless to fix the Registry. I checked it online and changed basedir, I am not using mysql5.8. I am looking for it. I think of the integrated environment, such as wampserver and pc_webserver, which will. ini, php. ini is written to the C: WINDOWS directory and set to read-only

Solution:
Delete the my. ini file in the windows directory,
Reinstall mysql. The service is started successfully.
4
Method 3:
1. Run winmysqladmin to generate my. INI file 2, mysqld-install start mysql service 3, net start mysql service display normal when through mysql-u root-p connection reported server not started error, view server service, it is true that the mysql service is not started. The error 1067 is generated when you manually start the mysql service. The error persists after you reinstall mysql several times. Check that all configurations are correct.
My system environment is win2003 mysql 4.0.12 solution. Copy my. ini generated by winmysqladmin to c: windows and start mysql. This has not been tried: in fact, you do not need to reconfigure as long as you click mysql.exe in the/bin directory in turn
Mysqld.exe
Mysqld-nt.exe
Winmysqladmin.exe
The prompt box appears, and then the cancle is dropped.
Then click winmysqladmin.exe and select start service on the small icon in the lower right corner.
5
Last trick: Turn off wamp, open the downloaded wampserver installation package, and install the package to directly overwrite the previous installation file. In this way, the mysql configuration problem is automatically fixed and MySQL is started, are you sure you can go in?

2 done

Then, you may be able to use it directly without doing anything. You can use it as well. You have created a table;

The source files and debug files in the database are not deleted. These files are useless and deleted. Delete dubug and deleted files. Of course, there are more than one directory. You can find it yourself, but do not delete it. Is it much smaller after deletion!