To create a Wamp-like Web Server in Windows7-#3.

   Continued from my last post.

The installation of MySQL 5.6.

1. Download mysql-5.6.12-win32.zip.
2. Extract the Zip archive.
3. Make the directory ‘MySQL’ in Drive_SV (A partition for server wares I made), then, install the directories and files to the MySQL. You can install all of extracted things. But, I only installed the next 5 directories and 2 files because I do not use others on my server by remote.
   • directories
     bin
     data
     include
     lib
     share
   • files
     COPYING
     my.ini　　<—　　　Copy of the my-default.ini.
4. Customize the my.ini file. (See Creating an Option File)
   # basedir = …..　　—>　　basedir = Drive_SV:/MySQL　　　(*) not a backslash() but a slash(/).
   # datadir = …..　　—>　　datadir = Drive_SV:/MyDATA
   Add the next line.
   explicit_defaults_for_timestamp = true
5. Move the data directory (Current location:Drive_SV:MySQLdata) to Drive_SV: and rename to MyDATA.
6. Run a cmd.exe as an Administrator.
   >Drive_SV:
   >cd Drive_SV:MySQLbin
   >mysqld –console　　　 (See Starting the Server for the First Time)

   2013-07-30 08:22:26 3484 [Note] Plugin ‘FEDERATED’ is disabled. ・　　　　　　　　　　　　　　　　　・ ・　　　　　　　　　　　　　　　　　・ 2013-07-30 08:22:27 3484 [Warning] No existing UUID has been found, ………… ・　　　　　　　　　　　　　　　　　・ ・　　　　　　　　　　　　　　　　　・ 2013-07-30 08:22:27 3484 [Note] mysqld: ready for connections. Version: ‘5.6.12’ socket: ” port: 3306 MySQL Community Server (GPL)

   If you have other errors or warnings, customize the my.ini again. If having an alert about the port 3306 from Windows Firewall, you may accept it.

   Run another cmd.exe as an Administrator.
   >Drive_SV:
   >cd Drive_SV:MySQLbin
   >mysqladmin -u root shutdown

7. Run a cmd.exe as an Administrator.
   >Drive_SV:
   >cd Drive_SV:MySQLbin
   >mysqld.exe –install
8. Control Panel >> Administrative tools >> Services
   Select the MySQL Service name and start
   If its ‘Startup Type’ is not ‘Automatic’, you have to change it to ‘Automatic’.
9. Add the directory Drive_SV:MySQLbin to the Path.Change root password.

   Run a cmd.exe as an Administrator.
   >mysql -u root
   >SET PASSWORD FOR root@localhost=PASSWORD(‘password’);
   > quit

   Logon check.
   >mysql -u root -p
   Enter password: ************
   > quit

The installation of phpMyAdmin4.

1. Download phpMyAdmin-4.0.4.2-english.zip.
   Extract the Zip archive.
2. Rename the directory phpMyAdmin-4.0.4.2-english to phpMyAdmin.
   Remove the config.sample.inc.php in the extracted files.
   Remove three directorates: doc, examples, and setup.
   Copy my old config.inc.php in the phpMyAdmin. (If you don’t have an old config.inc.php, see Quick Install.)

   Move the phpMyAdmin to Drive_SV.

3. Make an extra conf file as phpMyAdmin.conf in Drive_SV:Apache24confextra.
   The text of phpMyAdmin.conf:
   Alias /phpMyAdmin “Drive_SV:/phpMyAdmin/”

   <Directory “Drive_SV:/phpMyAdmin”>
   Options None
   AllowOverride None
   Require ip Lan IP range.
   </Directory>
   <Directory “Drive_SV:/phpMyAdmin/libraries”>
   Require all denied
   </Directory>

   Customize the httpd.conf (Location:Apache24conf).
   Add the next two lines to at the end of the Supplemental configuration section:
   # phpMyAdmin settings
   Include conf/extra/phpMyAdmin.conf

4. Restart Apache.
   Access http://xxx.xxx.xxx.xxx/phpMyAdmin

   Username: root
   Password: MySQL root password

   I have the caution:
   The phpMyAdmin configuration storage is not completely configured,
   some extended features have been deactivated. To find out why click here.

   So, to configure the phpMyAdmin configuration storage, I import my old database phpmyadmin. (If you don’t have an old database phpmyadmin, see phpMyAdmin configuration storage.)

5. Log out, and log in. The caution has gone.
6. Delete all users except root@localhost.Make a user(WP-User) and a database(WPdatabase) for the WordPress.
   WP-user was given all Global privileges except Grant. WP-user was given no Global privileges and was given all WPdatabase privileges except Grant. Their collation is utf8_general_ci.
7. Log out.