Theme: MySQL – Installation

December 31, 2013

1. Download MySQL for Windows from here.

DownloadMySQL

Installation

MyInst1MyInst2MyInst3MyInst4MyInst5MyInst6MyInst7MyInst8MyInst9MyInst10MyInst11MyInst12MyInst13MyInst14

Drag and drop this file to your server’s taskbar.
C:\Program Files\MySQL\MySQL Server 5.3\bin\mysql.exe
Click mysql icon on your server’s taskbar.
MyInst15

Copy this script to mysql’s windows.

Create database inusedata;
Create user ‘inuseuser’@'localhost’ identified by ‘password’;
Grant all on inusedata.* to ‘inuseuser’@'localhost’;

press enter key.

database name = inusedata
user name          = inuseuser
user password = password

  

Theme: Test drive VirtualBox + 2012R2 + PHP + MySQL + WordPress + WebDAV

December 22, 2013

Is anybody still using windows 2000?
It’s time to move ahead to the new technology, especially IPv6. You can try building your new Server with all these free trial software.

1. VirtualBox is free.
2. Windows Server 2012R2 is free for 180 days.
3. PHP, MySQL and WordPress are free.
4. WebDAV client for iPad is free!

Let’s cook together.
1. VirtualBox – Download & Install from here.
2. Windows Server 2012R2 – Download & Install from here.
3. Add feature see here.
- IIS
- Basic Authentication
- Windows Authentication
- SMTP
- WebDAV
- Net Framework 3.5
- Application Development (CGI)
- FTP
4. Download and run vcredist_x64.exe
vcredist_x64
5. Download PHP from here.
Extract PHP to C:\
downloadPHP

6. Download and run PHPManager from here.
downloadPHPmanager
Config PHPManager.

PHPmanagerRegisterPHPPHPcgi
To test PHP on your server, create index.php in your web’s root directory and put this code inside.

<?php
// prints e.g. ‘Current PHP version: 5.3.62.0′
echo ‘Current PHP version: ‘ . phpversion();

// prints e.g. ’2.0′ or nothing if the extension isn’t enabled
echo phpversion(‘tidy’);
?>

7. Download & Install MySQL from here.
8. Download & Install WordPress from here.
9. Add FTP site.
Filezilla connnect to Web Server.
10. Config WebDAV.
11 Access WebDAV from iPad.

I will complete the URL later.

Have fun.