I am assuming in this article that you're installing MySQL so that you can use it to test a web application on your own computer. As such, you will probably need to install the Apache web server and a programming language like PHP. If you have not already done so, you may be interested in the guides listed below. The guide is meant for installing MySQL on your own computer for the purpose of testing your own scripts offline.
A server that is connected to the Internet requires you to take security precautions to protect your computer. This tutorial ignores all that. This guide is primarily written with Vista in mind, since the machine I tested this procedure on is running Vista. I don't know if the steps are any different on XP.
The way to invoke various Start menu or Control Panel items will also differ. Like all procedures, the exact steps may vary according to the version of the program you download. The version I used was 5. If you find that the dialog boxes and messages are different when you install, it may be because you have a later version.
In such a case, use my procedure as a general guide to help you understand what to do, and if you have the time, drop me a note to let me know of any differences so that I can update this guide, if need be. Look for the "Windows Essentials x86 " package and download it. Note: you may have to work a bit to find it: that is, scroll down pages, click links and whatnot.
Double-click the MySQL installer that you downloaded. Read the information displayed in the install screens and click the necessary buttons eg, "Next". When you come to a screen entitled "Setup Type", leave the radio button selected at "Typical" and click the "Next" button. The installer should display a summary of its settings. Click the "Install" button to let it proceed with the installation. Vista will issue a "User Account Control" dialog box, asking you for permission to let the installer do its job.
Click "Continue". Finally, a "Wizard Completed" dialog box should appear. Don't worry, we'll do it manually from the Start menu ourselves. Then click the "Finish" button. Click the Start menu the round button that has the Windows logo on the bottom left of your computer monitor. Vista's User Account Control will appear, asking you for permission to let the program run. The MySQL config wizard should appear. Click "Next" to go to the dialog box that lets you select the type of configuration you want.
Select "Detailed Configuration" if it's not already chosen, then click "Next". The next screen lets you select a server type. Since you're just using MySQL to test your scripts, and you will be running your editor, browser, etc, on the same computer, you should probably select the "Developer Machine". This way MySQL does not eat up a lot of your system memory, allowing your other programs to run smoothly.
Click "Next". Leave the default of "Multifunctional Database" selected in the window asking you about your "database usage", unless you know specifically how you're going to be using the database. Click "Next" when you're through deciding. The next screen in the dialog box lets you select the drive where your database is to be stored. If you have no particular preference, leave it at the default and click "Next". You will now need to set the number of concurrent connections that can be made to the MySQL server.
If this is not true, feel free to select one of the other options, or to manually set the maximum number of simultaneous connections. Note: even if there are a few other people in your office or home helping you test your scripts, chances are that 20 connections is more than enough. If it isn't, you may need to rewrite your script so that it isn't quite so connection-intensive. Click "Next" when you're through.
By default, MySQL will listen to connections made through port on your computer. Unless you know for sure that port is being used by another program, just leave it at the default. If you don't know what I'm talking about, leave it at the default.
Tick the "Add firewall exception for this port". This will open up the port in Vista's firewall so that MySQL will be able to receive connection attempts made by other programs. If you use third-party firewalls or an antivirus program that includes a firewall, you will have to configure those firewalls to allow MySQL to receive connections yourself. The exact method, unfortunately, differs from firewall to firewall, so I can't give a general procedure that works with every program. Networking Software.
Trending from CNET. Download Now. Full Specifications. What's new in version 8. Version 8. Release April 21, Date Added April 21, Operating Systems. Additional Requirements None. Total Downloads , Downloads Last Week Report Software. Related Software. Facilitate transfer of data between Microsoft Office System files and non-Microsoft Office applications.
Microsoft Access Runtime bit Free. Enable you to distribute Access applications to users who do not have the full version of Access installed on their computers. Rainier Parcon. Benjamin Bengfort. Kevin VC. Sanjay Bisht. Sanjay Makvana. Scott Leckie. Harold Murray. John McPeek. Osman Soysalan. Uwe Baemayr. Senica Gonzalez. Bob Liu. Michael Chan. Jeff Vichiarelli. Chip Long. Jaco Groenewald. Anthony Perry. Joe Monteray. Greg Gibson. Jone Black. Sorry, you can't reply to this topic.
0コメント