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


   Continued from my last post.

The installation of MySQL 5.6.

  1. Download
  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
    • files
      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.
    >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.
    >cd Drive_SV:MySQLbin
    >mysqladmin -u root shutdown

  7. Run a cmd.exe as an Administrator.
    >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
    Extract the Zip archive.
  2. Rename the directory phpMyAdmin- to phpMyAdmin.
    Remove the in the extracted files.
    Remove three directorates: doc, examples, and setup.
    Copy my old in the phpMyAdmin. (If you don’t have an old, 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 “Drive_SV:/phpMyAdmin/libraries”>
    Require all denied

    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.

    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 *