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:\MySQL\data) to Drive_SV: and rename to MyDATA.
  6. Run a cmd.exe as an Administrator.
    >Drive_SV:
    >cd Drive_SV:\MySQL\bin
    >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:\MySQL\bin
    >mysqladmin -u root shutdown

  7. Run a cmd.exe as an Administrator.
    >Drive_SV:
    >cd Drive_SV:\MySQL\bin
    >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:\MySQL\bin 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:\Apache24\conf\extra\.
    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:Apache24\conf\).
    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.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.