Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to change the default installation directory of mysql under windows". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to change the default installation directory of mysql under windows.

Normal07.8 lb 02falsefalsefalseMicrosoftInternet Explorer 4st1VR * {behavior:url (# ieooui)} / * Style Definitions * / table.MsoNormalTable {mso-style-name: plain form; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent: "; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm Mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family: "Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}

After installing MYSQL5, it is found that there is an error in startup, sometimes the startup is normal, but there is an error immediately when you add it.

Error code: 1067

The solution is as follows:

Delete windows%/my.ini

Delete my.ini elsewhere

Copy my-small.ini to my.ini under the mysql installation directory

Insert in the last line of my.ini:

[mysqld]

# set the installation path where basedir points to mysql

Basedir=C:mysql-5.1.11-beta-win32

Datadir=C:mysql-5.1.11-beta-win32data

Restart.

C:mysql-5.1.11-beta-win32bin > net start mysql

The MySQL service is starting.

The MySQL service could not be started.

System error.

A system error 1067 occurred.

The process terminated unexpectedly.

C:mysql-5.1.11-beta-win32bin > mysqld-nt-- remove

Service successfully removed.

C:mysql-5.1.11-beta-win32bin > mysqld-nt-- install

Service successfully installed.

C:mysql-5.1.11-beta-win32bin > net start mysql

The MySQL service is starting.

The MySQL service has started successfully.

C:mysql-5.1.11-beta-win32bin > net stop mysql

The MySQL service is stopping..

The MySQL service stopped successfully.

(explanation: because I am also a beginner in mysql, this article is only a record of some puzzles encountered in the process of learning. The instructions are just some experience of my own exploration, for reference only, and will continue to be improved in the future.)

At this point, I believe you have a deeper understanding of "how to change the default installation directory of mysql under windows". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.