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.
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
Move the data directory (Current location:Drive_SV:MySQLdata) to Drive_SV: and rename to MyDATA.
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
Run a cmd.exe as an Administrator. >Drive_SV: >cd Drive_SV:MySQLbin >mysqld.exe –install
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’.
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
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.
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
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.)
Log out, and log in. The caution has gone.
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.