System Administrator Documents

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...

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 Go to http://dev.mysql.com/downloads/installer/ . Click the Download button. Save the installer file to your system. Starting the Installation After the download completes, run the installer as follows: Right-click the downloaded installation file (for example, mysql-installer-community-5.6.14.0.msi ) and click Run. The MySQL Installer starts. On the Welcome panel, select Install MySQL Products. On the License Information panel, review the license agreement, click the acceptance checkbox, and click Next. On the Find latest products panel, click Execute. When the operation is complete, click Next. On the Setup Type panel, choose the Custom option and click Next. On the Feature Selection panel, ensure ...

PHP 5.4 on IIS 7.5 step-by-step instructions using Microsoft Web-Platform-Installer 4.0 Here are the basic steps, and I included screen images showing visual feedback you can expect during the process. And, this whole process is only going to take a few minutes (depending on your download speed). Got the the Microsoft web page for the Web Platform Installer for PHP 5.4  ("WPI").  You will see a large button on that page saying " Install Now "... click it to download a PHP54.exe (small) program that you run to launch the WPI install process. Note: if you already have the MS WPI installed, you should be able to just use that interface directly to add PHP 5.4 -- WPI should be accessible via your start-menu, and you can find it here too:" C:\Program Files\Microsoft\Web Platform Installer\WebPlatformInstaller.exe " Run that PHP54.exe program you downloaded . This will start the platform-installer and proceed with PHP 5.4 on IIS7.5 i...

  This tutorial will guide you through setting up a new website (or virtual host if you will) on IIS 7.5. The procedure to add a new website to IIS 7.5 is the same no matter which operating system you use (Windows 7 or Server 2008). 1. Open the IIS Manager To begin, open the IIS Manager from Start > Control Panel / Administrative Tools / IIS Manager . 2. Add the website → Expand the tree on the connections column. → Right click Sites. → Select Add Web Site… 3. Configure the new website This window is the initial new website configuration. From here we will make a basic working site. → In Site name, enter a name to identify your website. The domain or name of the site is best. → In Physical path enter the path to the website files. You can put this anywhere on your hard drive but the default is c:\inetpub\wwwroot\. In the binding set, you can select how the site is bound to the server. → Type: Select HTTP if you don’t know what you...

→ On the Windows 2008 server, go to Start | Server Manager. → The Windows Server Manager console will open. Choose the option under Roles. → Select Web Server (IIS). → On selecting this, the following window will open. → Select the "Add Required Features" button.   → On the Select Server Roles, choose the Application Server check box. → On selecting this box, the following window will open. → Click the "Add Required Features" button. → On the Select Server Roles screen, choose Next. → Click Next on the Select Server Roles window. This will take you to the next section which is an informational page on the Introduction to Application Server. → Click Next. This leads to the Select Role Services menu. Select the Web Server (IIS) Support checkbox. → After selecting this, the following window will open for the required dependencies. → Click the "Add Required Role Services"...

How To Optimize Remote Desktop In Windows 7 Here's how to optimize Remote Desktop settings in Windows 7 to speed up your connections. Want faster access and a more efficient connection in the Windows 7 Remote Desktop/Terminal Services client? Just optimize the settings. Here's how. Click Start and type: mstsc Hit Enter. This opens the Remote Desktop Connection window. In the lower left corner, click Options. Enter the address of the PC you're connecting to and your user name. Don't forget to check the box next to Allow me to save credentials. Click the Display tab. Set Display Configuration to a lower resolution. Change the color depth to High Color (16 bit). This will give you faster access to the remote computer you're connecting to. Click the Local Resources tab. Check the boxes for Printers and Clipboard. Hit More. Check the box next to Drives. Your screen should look like mine, below. Click OK. Cli...