Windows Server 2003 boot automatically starts the MySQL service Setup method

Source: Internet
Author: User

Windows Server 2003 boot automatically starts the MySQL service Setup method Published: 2014-12-19 updated: 2014-12-24 Source: Network Eaglezhong
Key words: 2003 EXE boot nbsp; Setup method

&http://www.aliyun.com/zixun/aggregation/37954.html ">nbsp; Every time I have to click on the Mysqld-nt.exe execute file to start MySQL, although will create a Mysqld-nt.exe shortcut to the desktop, but still want it to start automatically, how can be like MSSQL set boot followed by boot?

Here are some of the experiences I have summed up with you to share:

1. Open the Command Line window (CMD)
2. Switch to the MySQL directory, for example: D:\xampp\mysql\bin
3. Input Mysqld-nt--install, enter
4. System prompt (Service successfully installed.)//Can be omitted
5. Open [Control Panel-management tools-services]//Can be omitted
6. View service "MYSQL" Startup type is automatic//can be omitted

Note:
1. Step 3,mysqld-nt after--install can not add any parameters, the default configuration.
2. Use the command line mysqld-nt--remove to delete a task
3. Do not use scheduled tasks, because scheduled tasks must be configured for time.

If you are unable to start MySQL in the service through the above, please make the following settings:

According to the above method mysqld-nt--install installation into a service, see the Startup type is automatic, right click on it to start, not start, there are 1067 errors, and this time found even double-click Mysqld-nt.exe can not start, mysqld-nt- Remove Delete Service, double-click Mysqld-nt.exe can start again, the Internet to find 1067 errors, my MySQL installed in d:\mysql, online find this is the same as mine:
=================
You seemed has your MySQL installed in Windows. So the problem may becaused if you ' re not installing the MySQL in C:\mysql.

You cansimply copy all files to C:\mysql or

Create a file call My.ini (store it in%windows%) OR MY.CNF (store it in C \) and the followingcontent should is in the file
Assume you have MySQL Ind:\mysql

[Mysqld]
#set Basedir to the InstallationPath
Basedir=d:/mysql
Datadir=d:/mysql/data

Note that Theforward slashes (/) is being used. Good luck "
=================
And according to this, create a new My.ini file, add these in:
[Mysqld]
#set Basedir to the InstallationPath
Basedir=d:/mysql
Datadir=d:/mysql/data
Then put in the system Winnt directory, and then re-mysqld-nt--install, and then solve the problem.

The author tests This method to resolve the service that MySQL automatically starts under Windows Server 2003.

Windows Server 2003 boot automatically starts the MySQL service Setup method

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.