Setting Up the MySQL Database Server in the Windows Operating System


Setting Up the MySQL Database Server in the Windows Operating System






This document recommends a sequence of steps to set up the MySQL database server 5.6 versions in the Windows operating system.

Starting the Download


  2. Click the Download button.
  3. Save the installer file to your system.

Starting the Installation


After the download completes, run the installer as follows:

  1. Right-click the downloaded installation file (for example, mysql-installer-community-5.6.14.0.msi) and click Run.
    The MySQL Installer starts.
  2. On the Welcome panel, select Install MySQL Products.
  3. On the License Information panel, review the license agreement, click the acceptance checkbox, and click Next.
  4. On the Find latest products panel, click Execute.
    When the operation is complete, click Next.
  5. On the Setup Type panel, choose the Custom option and click Next.
  6. On the Feature Selection panel, ensure MySQL Server 5.6.x is selected, and click Next.
  7. On the Check Requirements panel, click Next.
  8. On the Installation panel, click Execute.
    When the server installation is completed successfully, the information message appears on the Installation panel. Click Next.
  9. On the Configuration panel, click Next.
  10. At the first MySQL Server Configuration page (1/3), set the following options:
    • Server Configuration Type. Select the Development Machine option.
    • Enable TCP/IP Networking. Ensure the checkbox is selected and specify the options below:
      • Port Number. Specify the connection port. The default setting is 3306 - leave it unchanged if there is not special reason to change it.
      • Open Firewall port for network access. Select to add firewall exception for the specified port.
    • Advanced Configuration. Select the Show Advanced Options checkbox to display an additional configuration page for setting advanced options for the server instance if required.

Note: Choosing this option is necessary to get to the panel for setting the network options where you will turn off the firewall for the port used by the MySQL server.

Click Next.

  1. At the second MySQL Server Configuration page (2/3), set the following options:
    • Root Account Password.
      • MySQL Root Password. Enter the root user's password.
      • Repeat Password. Retype the root user's password.

Note: The root user is a user who has full access to the MySQL database server - creating, updating, and removing users, and so on. Remember the root password - you will need it later when creating a sample database.

    • MySQL User Accounts. Click Add User to create a user account. In the MySQL User Details dialog box, enter a user name, a database role, and a password (for example, !phpuser). Click OK.

Click Next.

  1. At the third MySQL Server Configuration page (3/3), set the following options:
    • Windows Service Name. Specify a Windows Service Name to be used for the MySQL server instance.
    • Start the MySQL Server at System Startup. Leave the checkbox selected if the MySQL server is required to automatically start at system startup time.
    • Run Windows Service as. Choose either:
      • Standard System Account. Recommended for most scenarios.
      • Custom User. An existing user account recommended for advanced scenarios.

Click Next.

  1. At the Configuration Overview page, click Next.
  2. When the configuration is completed successfully, the information message appears on the Complete panel. Click Finish.

Note: To check that the installation has completed successfully, run the Task Manager. If the MySQLd-nt.exe is on the Processes list - the database server is running.

Comments

Post a Comment

Popular posts from this blog

Backup & Restore Database as SQL Dump by SqlYog

Image
Direct Connection using MySQL C API (Sqlyog) → Download SQLyog Community Edition from this url and install /run https://github.com/webyog/sqlyog-community/wiki/Downloads fter you have connected to an instance of MySQL, you can make additional connections by selecting the New Connection option from the File menu. Saved Connections Select the connection name from the list. To rename a saved connection, click on the Rename button and edit the connection name and click save option to save the changed connection name. Other details can also be changed by selecting the particular connection, changing the necessary values and then by clicking on save to save those values. MySQL Host Address Specify a host name where the database is situated or the IP address of the server. User Name Specify a user name for connecting to the database server. Note: This is MySQL username
Read more

Postfix can support per-domain outgoing IP addresses, but is not currently configured to do so

Sender Dependent Outgoing IP Address (Virtualmin) Introduction to Outgoing IPs By default, when your mail server sends out email the SMTP connection will come from the system's default IP address, typically that assigned to. eth0 Even if the email is from a domain that has its own private IP, that address will not be used when sending an email. This behavior can be changed on systems running Postfix version 2.7 and Virtualmin 3.94 or later so that outgoing email from a domain with a private IP address appears to come from that address. This can be useful for separating email from multiple domains as seen by other mail servers, or for setting up per-domain reverse DNS records. Initial Configuration This feature requires Postfix 2.7 (seen on most modern Linux distributions), Virtualmin 3.93 and ideally Webmin 1.600. The steps to set it up are as follows: SSH into the system as, root and edit the  /etc/postfix/main.cf  file. Look for a line starting with. sender_depe
Read more

Wanna-cry-ransomware

Do those following things in the windows system. 1.  Block port 138.139,445 with the firewall. 2. How to enable or disable SMB protocols on the SMB server:     Windows 7, Windows Server 2008 R2, Windows Vista, and Windows Server 2008       To enable or disable SMB protocols on an SMB Server that is running Windows 7, Windows Server 2008 R2, Windows Vista, or Windows Server 2008, use Windows PowerShell or Registry Editor.      Windows PowerShell 2.0 or a later version of PowerShell     To disable SMBv1 on the SMB server, run the following cmdlet:         Set-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters" SMB1 -Type DWORD -Value 0 -Force     To enable SMBv1 on the SMB server, run the following cmdlet:         Set-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters" SMB1 -Type DWORD -Value 1 -Force -: Windows Vista, Windows Server 2008, Windows 7, Windows Server 2008 R2, Windows 8,
Read more