How to Install the MySQL Database Server on Your Windows PC
Log into the computer as an administrator., Download the free MySQL Server Community Edition., Double-click the downloaded file., Double-click Setup.exe., Click Next., Click Custom > Next., Click Install., Click Skip Sign-Up and then Next...
Step-by-Step Guide
-
Step 1: Log into the computer as an administrator.
This will give you administrator rights, which will make the installation smoother.
Note that, once installed, the program doesn’t need to be run as an administrator. -
Step 2: Download the free MySQL Server Community Edition.
Be sure to download a version that includes a Windows Installer.
Save the file on your Windows Desktop.
If you’re not sure which version to select, download MySQL Installer for Windows. , The installation file comes as a .zip file, so double-clicking it should initiate your unzipping software and take you to an archive folder. , (It should be the only file inside your archive.) This will initialize the setup process. , This begins the setup. , This will enable you to specify where you want to install MySQL.
If you have Apache installed in C:\Server, you will want to install MySQL in the same directory.
In the next window, highlight MySQL Server, and then click the Change.
In the next window, in the text box Folder Name, change the directory to C:\Server\MySQL\ exactly as it’s written here and then click OK.
On the next window, click Next.
Now MySQL is ready to install. , Wait while the program self-installs. , Once the installation is complete, you will be presented with a MySQL Sign-Up window.
Skip signing up with MySQL for now since you can sign up later if you like.
Once you’ve skipped, your new dialogue box should say Wizard Completed. , Leave the check box Configure the MySQL Server Now checked and click Finish. , This will initialize the configuration setup. , This is the default configuration and is recommended for most users. ,, Type in what you want your root password to be and make sure Enable root access from remote machines is checked.
Make sure you choose a difficult to guess password and 'write it down so you don't forget it.
Click Next. , This will start the MySQL server.
After MySQL has done its thing, click Finish. , This will open a command window asking you for a password. , This should initiate the program. -
Step 3: Double-click the downloaded file.
-
Step 4: Double-click Setup.exe.
-
Step 5: Click Next.
-
Step 6: Click Custom > Next.
-
Step 7: Click Install.
-
Step 8: Click Skip Sign-Up and then Next.
-
Step 9: Configure MySQL.
-
Step 10: Click Next.
-
Step 11: Check Standard Configuration and then click Next.
-
Step 12: Make sure Install As Windows Service and Launch the MySQL Server Automatically are checked
-
Step 13: then click Next.
-
Step 14: Create a root password.
-
Step 15: Click Execute.
-
Step 16: From the Windows task bar
-
Step 17: go to Start > All Programs > MySQL > MySQL Server 4.x > MySQL Command line client.
-
Step 18: Enter your root password and hit Enter.
Detailed Guide
This will give you administrator rights, which will make the installation smoother.
Note that, once installed, the program doesn’t need to be run as an administrator.
Be sure to download a version that includes a Windows Installer.
Save the file on your Windows Desktop.
If you’re not sure which version to select, download MySQL Installer for Windows. , The installation file comes as a .zip file, so double-clicking it should initiate your unzipping software and take you to an archive folder. , (It should be the only file inside your archive.) This will initialize the setup process. , This begins the setup. , This will enable you to specify where you want to install MySQL.
If you have Apache installed in C:\Server, you will want to install MySQL in the same directory.
In the next window, highlight MySQL Server, and then click the Change.
In the next window, in the text box Folder Name, change the directory to C:\Server\MySQL\ exactly as it’s written here and then click OK.
On the next window, click Next.
Now MySQL is ready to install. , Wait while the program self-installs. , Once the installation is complete, you will be presented with a MySQL Sign-Up window.
Skip signing up with MySQL for now since you can sign up later if you like.
Once you’ve skipped, your new dialogue box should say Wizard Completed. , Leave the check box Configure the MySQL Server Now checked and click Finish. , This will initialize the configuration setup. , This is the default configuration and is recommended for most users. ,, Type in what you want your root password to be and make sure Enable root access from remote machines is checked.
Make sure you choose a difficult to guess password and 'write it down so you don't forget it.
Click Next. , This will start the MySQL server.
After MySQL has done its thing, click Finish. , This will open a command window asking you for a password. , This should initiate the program.
About the Author
Evelyn Hayes
Committed to making crafts accessible and understandable for everyone.
Rate This Guide
How helpful was this guide? Click to rate: