Unlike a typical LAMP (Linux – Apache – PHP – MySQL) server, where we usually use cPanel or Plesk or any Web Hosting Control Panel, Microsoft’s IIS has several proprietary softwares, command line tool, software through GUI on server to create a MySQL Database and User. For a bland new server, PHP and MySQL needed to be installed before proceeding.
Making MySQL to Work Before Creating a MySQL Database and User in IIS #
Install MySQL 5.0 GUI Tools. Configured it to work properly. Your username will be root and password will be whatever you want. Usually we set the server host as localhost. For frontend, you can install PHPMyAdmin. It is possible to create database through PHPMyAdmin too.
This process needs full access. Most “ready made” low end shared server users need not to perform it :
- Copy a file named libmysql.dll from C:\PHP folder to C:\WINDOWS\SYSTEM32 folder. Taking that C partition is where Windows is installed. If a same name file exists, rename the old dll file in SYSTEM32 folder to something memorable name.
- Install free software named Gedit for Windows, using Notepad can add line breaks while editing. Open Gedit, drag the php.ini (in C:\WINDOWS folder) file to Gedit to open and Edit :
Uncomment the following and edit the proper path :
extension_dir="c:\php\ext" extension=php_mysql.dl extension=php_mysqli.dll
Restart the server.
Creating a MySQL Database and User in IIS #
By following the above method, there will be a default root user with your password. Username root is preferred to avoid the complexities.
Creating a MySQL user via the command line can also be done just like Linux servers. Please refer to your Web Host for proper installed components; many uses proprietary web hosting softwares and PHPMyAdmin is included. In that case, please follow the official guide on PHPMyAdmin website for creation of MySQL Database and User (it is becoming OS independent). This ways are to emulate WordPress we use for Linux servers. There are softwares for Windows Server which directly installs WordPress :