MySQL installation.

Unzip the MySQL download and then run the Setup.exe installation program. Run the setup program and accept the license.

Choose a CUSTOM installation.

Install EVERYTHING – the Developer Components will be X’d out.

Underneath the installation options, change the installation path to c:\mysql5because it will make it easier to link and compile programs, especially if you’re running BCX for your programming language.

Click Next and complete the installation.

Click Next a couple of more times to get by the Enterprise Registration screens.

• At the SETUP WIZARD screen, you will keep the configuration boxes checked and click Finish.
• When the Configuration Wizard Starts, click the Next button and it will bring you to the Standard –vs- Detailed Configuration options. Select the Detailed (default) option and click Next.
• Select either Server or Dedicated machine install types. I choose Dedicated and have not had any issues in 3 years of running it 24/7. It is not a system hog. The more data you load into it – the more it will use, but you can always configure the settings. It is easy to change settings.
• When it comes time to choose the database usages types and you are only using MySQL for this project, then I suggest you choose the Non-Transactional Database only type.
• Choose the number of connections you desire. I suggested Manual-Setting of 15 connections. Your program might use 3-6 connections at one time along with database monitoring tools and such.
• The Networking screen is next. I suggest you use local connection only, unless you are interested in networking usages.
• On the Character Set screen, I usually leave it as “Standard Character Set”. Once I had to use “latin2” when running data from an “MiniSQL” 1.0 database that I converted.
• The Windows Options screen is next. Install as a Windows Service (leave the defaults please). You can select whether to launch it automatically or not. I leave mine running 24/7, but most people I know turn it on and off when they are programming with it. ** INCLUDE THE BIN DIRECTOR *** àmake sure you check this checkbox!
• OK, if you selected to install as a LOCAL only and not TCP/IP then you can use a default password here. I suggest you make it “password” because all of the demo code I write will work with user:”root” and password:”password”. Of course if you selected the networking option you will want a SUPER COMPLEX password. It is up to you. You WILL need to modify the password in demo code if you have it anything other than “password”.
• Click Next and then Execute to configure the MySQL database server. You should have gotten 4 blue check marks to show that the configuration was successful.

Run and install the MySQL GUI Tools and choose the default installation settings.

Run the Mysql Administrator and connect to the database server.

Host: “127.0.0.1

User: “root”

Pass: “password”

Details TAB:

            Check Use Named Pipe and Pipe name “mysql”

Click Connect. You should connect if your user and password is correct. You may get a cannot-connect-CLONE-CONNECTION error, but still be connected sometimes.

• It is best to now reboot and try connecting with MySQL Administrator again. Also explore the left column of options in the Administration panel.

John