In: Categories » Computers and technology » Servers » Install MySQL on Windows
| We'll look at three stages: downloading, installing, and starting the server. Downloading MySQLThe first step to installing MySQL on Windows is to download the installation file. Open your browser and browse to http://www.mysql.com/downloads/index.html, which is the MySQL downloads page. You need to select the option MySQL 3.23 Production release (recommended). This will take you to a new page where you can select the package to download. For Windows, there's only one file, which at the time of writing is listed as
Download this file ready for the install by selecting the "Pick a mirror" link, so you can choose the download location closest to you. New versions are released frequently, but the actual setup procedure should remain the same. It is worth noting that a new version of MySQL (version 4) is under development and at the time of this writing is still undergoing testing. You can find out more about the MySQL version 4 release at the following URL: http://www.mysql.com/doc/en/MySQL_4.0_In_A_Nutshell.html. Installing MySQLThe downloaded install file is a .zip file, so you'll need to extract the contents of this file to a temporary location on your hard drive. Run the setup program by double-clicking setup.exe. This will start the install process. Click Next to start the installation. This dialog box gives extra information about the installation. It's important to read this information in case it applies to your installation. You can then click Next to continue. In the next dialog box, you can select the directory into which MySQL is installed. It's recommended that you leave this directory as the default, which is C:\mysql. If you change it, you will need to configure MySQL later to use your chosen path. Click Next to continue to the next dialog box, which allows you to select an installation type. It's recommended that you stick to the default option. Click Next to continue and then Finish to complete the installation. Starting the MySQL ServerNow that the MySQL server package has been installed, you need to start the server before you can perform any administration tasks and set up a new database. To start the server, open Windows Explorer and browse to the directory in which you installed MySQL. If you followed this guide, then the location is C:\mysql. Next, change to the bin subdirectory. Here you should see a tool called winmysqladmin.exe. This is used to start and stop the MySQL server, so to make it easier to get to, it's a good idea to right-click the winmysqladmin.exe file and select Create Shortcut. You can then drag this shortcut to the desktop to make it more accessible and easier to control the MySQL server. To start the server, double-click the winmysqladmin.exe file. The first time you run WinMySQLAdmin, it will prompt you for a username and password, which it will store in a file called my.ini in your Windows system directory and use to access MySQL information. The dialog box shown next will appear briefly and will then disappear. Note that the Environment tab, shown in the preceding screen shot, is useful for displaying information about the MySQL server. When the preceding dialog box has minimized, you'll be left with a green "traffic light" icon in your Windows System tray. This indicates that the MySQL server is running. If the icon is red, the MySQL server is stopped. If you right-click the MySQL "traffic light" icon and select Show me, the main winmysqladmin.exe screen is redisplayed. This tool allows you to see various categories of information about the server, such as the databases set up and how many users are connected to MySQL. To start and stop the MySQL server, you can either right-click the MySQL icon in the system tray and use the menu to stop or start the server, or you can use the Services section of Administrative tools in the Windows Control Panel. Now the server is installed and running.
|
legal disclaimer
1) Our website is not responsible for the information contained by this article as well for any and all copyright infringements by authors and writers. E-articles is a free information resource. If you suspect this article for any copyright infringements, please read the Terms of service and contact us to investigate the problem.
2) The E-articles directory team is not responsible for inaccuracies, falsehoods, or any other types of misinformation this tutorial may contain and will not be liable for any loss or damage suffered by a user through the user's reliance on the information gained here. Please read the Terms of service
Useful tools and features
If you like this article (tutorial), please link to it from your web page using the information above. Linking to this page, this is the only way to help us improve our service, the same time providing your visitors with a way to improve their online experience.
related articles
One of the improvement goals Microsoft has had with all of their products over the past few years has been to constantly improve the security in the products. More recently with all of the regulatory compliance laws and policies being implemented, Microsoft has focused a lot of security enhancements to address privacy, information archiving, and compliance support. The release of Exchange 2007 was no different—Microsoft added in several new enhancements in the areas of security and compliance support. One of the addition...
2. Designing Exchange Infrastructure
After Active Directory and the physical OS has been chosen and deployed, the Exchange infrastructure can be set up and optimized for the specific needs of the organization. With these needs in mind, you can do several things to optimize an Exchange 2007 setup, as detailed in the following sections. Determining the Exchange Version When installing Exchange, the choice of Exchange version needs to be made. As with Windows Server 2003, there are two versions of Exchange, Standard and Enterprise. The Standard Edit...
3. Synchronizing Exchange Server 2007 with Novell eDirectory
Novell eDirectory and Novell Directory Service (NDS) environments are relatively commonplace in business environments, and there is often a need to integrate them into deployed Exchange infrastructures. Several tools exist that can make this a reality, including the MIIS 2003 tools discussed. In addition, tools in the Microsoft-supplied Services for NetWare can be used to synchronize directory information between the two directory systems. NOTE Exchange 2000 Server and Exchange Server 2003 included a GroupWise ...
4. Integrating Client Access into Exchange Server 2007 Design
Although the Exchange server is a powerful systems component, it is only half the equation for an email platform. The client systems comprise the other half, and are a necessary ingredient that should be carefully determined in advance. Outlining Client Access Methods Great effort has been put into optimizing and streamlining the client access approaches available in Exchange 2007. Not only have traditional approaches such as the Outlook client been enhanced, but support for nontraditional access with POP3 and...
5. Domain Name System and Its Role in Exchange Server 2007
For computer systems to communicate with each other, whether you are talking about a local area network (LAN), a wide area network (WAN), or the Internet, they must have the ability to identify one another using some type of name resolution. Several strategies have been developed over the years, but the most reliable one to date (and the current industry standard) is the use of a DNS. Accurate name resolution is critical in a mail environment as well. For a message to reach its destination, it might pass through several syste...
6. Synchronizing Directory Information with Microsoft Identity Integration Server (MIIS) 2003
In most enterprises today, each individual application or system has its own user database or directory to track who is permitted to use that resource. Identity and access control data reside in different directories as well as applications such as specialized network resource directories, mail servers, human resource, voice mail, payroll, and many other applications. Each has its own definition of the user’s “identity” (for example, name, title, ID numbers, roles, membership in groups). Many have their own ...
7. Using DNS to Route SMTP Mail in Exchange Server 2007
The primary protocol for sending email on the Internet today is known as Simple Mail Transfer Protocol, or SMTP. SMTP has been used for quite some time in UNIX and Linux environments, and has been incorporated into Active Directory as an alternative transport mechanism for site traffic. Domains that want to participate in electronic mail exchange need to set up MX record(s) for their published zone. This advertises the system that will handle mail for the particular domain, so that SMTP mail will find the way to its destinati...