Welcome to the Windows community forum and interact with 3 million technical staff to see if you want to set mysql to windows. Generally, choose to set mysql to a service, in this way, you can enable and disable the mysql database through the service. the check boxes below are also checked. In cmd mode, you do not have to execute commands in the bin directory of mysql. that is, to bring up and down
Welcome to the Windows community forum and interact with 3 million technical staff> do you want to set mysql to windows in this step? Generally, set mysql to a service, in this way, you can enable and disable the mysql database through the service. the check boxes below are also checked. In cmd mode, you do not have to execute commands in the bin directory of mysql. that is, to bring up and down
Welcome to the Windows community forum and interact with 3 million technicians>
In this step, whether to set mysql to windows is usually set as a service. In this way, you can enable and disable mysql databases through the service. the check boxes below are also checked. In cmd mode, you do not have to execute commands in the bin directory of mysql. that is, the upper and lower two hooks are marked, and the middle default is-"next"
This step is to set the mysql Super User Password. This super user is very important and has all permissions for mysql. Please set and remember the Super User Password, the following check box is used to select whether to allow remote machines to connect to your mysql server as the root user. If you need this check box, check it. here we use the default option, and enter the password in New root password and Confirm. "next"
Click "execute" for configuration. Wait a moment and check all the dots to complete the configuration.
2. Modify the Configuration:
Open D: \ WAMP \ MySQL \ my. ini
Set datadir to D:/WAMP/MySQL/data/or the directory where you want to store the data.
Iii. PHP installation
Version Description: VC9 is a script dedicated to setting values for IIS. It is compiled using the Visual Studio 2008 compiler and supports the latest Microsoft build to improve efficiency.
VC6 is a script provided for other WEB service software, such as Apache.
Thread Safe is ready-to-use security, and Thread security checks will be performed when the star starts the CGI execution method of the new Thread as required to exhaust system resources.
Non-Thread Safe is Non-Thread-Safe. No Thread security check is performed during execution.
Select the version: PHP5.3 (5.3.1) for VC6 x86 Thread Safe ZIP download
1. Installation instructions
Since we downloaded the ZIP package, we only need to extract the file to the "D: \ WAMP \ PHP" directory.
2. modify configuration
Change the E: \ WAMP \ PHP \ php. ini-development file to php. ini.
Open php. ini
; Extension_dir = "ext"
Changed to extension_dir = "E: \ WAMP \ PHP \ ext"
Remove ";" in front of these files in the first row.
Extension = php_curl.dll
Extension = php_gd2.dll
Extension = php_mbstring.dll
Extension = php_mysql.dll
Extension = php_mysqli.dll
Extension = php_pdo_mysql.dll
Extension = php_xmlrpc.dll
; Date. timezone =
Modified to (many websites do not mention the modification here. The default value is us time. If it is not modified, an error will be reported): date. timezone = Asia/Shanghai
3. Test
Restart Apache (after the configuration file is modified, it takes effect only after Apache is restarted)
Create an index. php page, enter it in the code, and save the file to the "D: \ WMAP \ www \" directory.
Open the browser and enter: // localhost/index. php. If the display is normal, it indicates that PHP is configured. You can check whether the PHP information on this page is correct.
(Note: The Input Function in the file can output a large amount of information about the current PHP status, such as the PHP version, server information, and environment .)
(Note :)
Next, we will test whether Mysql can be connected.
Create a link. php file and enter it in the code.
$ Link = mysql_connect ("127.0.0.1", "root", "password entered during Mysql installation");
If (! $ Link) echo "Mysql database connection failed! ";
Else echo "Mysql database connection successful! ";
Mysql_close ();
?>
Save the file to the "D: \ WMAP \ www \" directory.
Open the browser and enter localhost/link. php to view
4. PhpMyAdmin Installation
Description: phpMyAdmin-3.2.5
Select version: phpMyAdmin-3.2.5-all-languages.zip
1. Installation instructions
Decompress the package to D: \ WAMP \ phpMyAdmin.
2. modify configuration
Open D: \ WAMP \ phpMyAdmin \ libraries \ config. default. php
$ Cfg ['pmaabsoluteuri '] = ";
Change to (enter the absolute URL for accessing phpMyAdmin): $ cfg ['pmaabsoluteuri '] =' // localhost/PHPMyadmin /';
$ Cfg ['servers'] [$ I] ['host'] = 'localhost ';
Change to (enter the server address, which is usually the default and does not need to be modified): $ cfg ['servers'] [$ I] ['host'] = 'localhost ';
$ Cfg ['servers'] [$ I] ['user'] = 'root ';
Change to (fill in the Mysql user name, here we default): $ cfg ['servers'] [$ I] ['user'] = 'root ';
$ Cfg ['servers'] [$ I] ['Password'] = ";
Change to (enter the Mysql password): $ cfg ['servers'] [$ I] ['Password'] = 'mysql PWD;
$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';
Change to (set authentication method, security considerations, and fill in as cookie): $ cfg ['servers'] [$ I] ['auth _ type'] = 'cookies ';
$ Cfg ['blowfish _ secret'] = ";
Change to (set the phrase password. If the cookie is set above, leave it blank. Otherwise, an error will be prompted during logon): $ cfg ['blowfish _ secret'] = 'cookies ';
3. Test
Open the browser and enter localhost/phpmyadmin/to access and log in.
V. End
So far, the PHP environment in Windows 7 has been set up.
[1] [2]