Home
Accessing MySQL on VB.NET using MySQL Connector/Net, Part 2: Setup MySQL Server

Accessing MySQL on VB.NET using MySQL Connector/Net, Part 2: Setup MySQL Server

February 17, 2009 VB.NET 5 Comments
This entry is part 2 of 8 in the series Accessing MySQL on VB.NET

Accessing MySQL on VB.NET

In this post, I’ll show how to setup MySQL Server on a database PC.

Step-by-step to setup MySQL Server

  1. Download MySQL 5.1.30 Community Edition from mysql.com.
    mysql.com
  2. Double-click the setup file mysql-essential-5.1.30-win32.msi. Click Next.
    Setup MySQL Server - MySQL Server Installation
  3. On Setup Type, select Typical. Click Next.
    Setup Type - Typical
  4. On Ready to Install the Program, click Install.
    Install MySQL Server
  5. On Wizard Completed, check Configure the MySQL Server Now and click Finish.
    Finishes MySQL Server Installation
  6. On MySQL Configuration Wizard, click Next.
    Configure MySQL Server
  7. On MySQL Server Instance Configuration, select Standard Configuration.
    Note: If you want to develop in a single PC environment, you can select Detailed Configuration instead and choose Developer Machine so MySQL Server won’t consume too much resource on the PC.
    Standard Configuration
  8. On MySQL Server Instance Configuration, verify that all check boxes are checked on this page and click Next. The first and second (Install As Windows Service and Launch the MySQL Server automatically) check boxes configure MySQL as a Windows service so that you don’t have to login to the PC and start MySQL Server manually, it’ll start when the PC is on automatically.
    Install MySQL As Windows Service
  9. On MySQL Server Instance Configuration, check only the upper check box Modify Security Settings and enter the root password. The root user is the default user on MySQL who has all privileges on the MySQL Server. In this example, I set the root’s password to “password”. Click Next.
    Note: This is just an example, you should set password more complexity than this.
    Set Root's Password
  10. On MySQL Server Instance Configuration, click Execute to start the configuration.
    Execute MySQL Server Configuration
  11. When the configuration is done, click Finish to complete install and configure MySQL Server.
    Finishes Configure MySQL Server
Series Navigation<< Accessing MySQL on VB.NET using MySQL Connector/Net, Part 1: IntroductionAccessing MySQL on VB.NET using MySQL Connector/Net, Part 3: Install Sample Database >>

Related Posts

5 Comments

  1. Annela Avva September 6, 2024

    If you want to perform the Login Asus Router process, first, you need to open a web browser of your choice and type the asusrouter.com web address in the URL bar. Then, a login page appears. Now, enter your username and password in the given fields and click on ‘Sign-in’. To know more, message us!
    https://asuslogn.com/

  2. Annela Avva September 26, 2024

    You can easily perform the Asus Router Login process using the Asus Router app. To do so, launch the latest version of the app. Now, open the app asnd then create a new account by entering the valid details. Hereon, add the device to the app or approach us to know more!
    https://asuslogn.com/

  3. johnymillar October 10, 2024

    Your positivity is infectious. Thank you for brightening my day

  4. Zmodo Camera Login October 29, 2024

    Your kindness has brightened my day more than you know. Thank you for being you

  5. Aervy Setup November 12, 2024

    Thank you so much for everything you’ve done. I really appreciate it

Leave a Reply