PHP environment configuration, php Environment

PHP environment configuration, php Environment

Directory:

Apache configuration 1

Installation required: VC2015 1

Decompress Apache to C: \ www \ Apache24 \ and enter C: \ www \ Apache24 \ bin 2.

Error: 2

PHP configuration 3

MYSQL configuration 3

 

Install Apache configuration: VC2015

Httpd-2.4.16-win32-VC14.zip VC14 is 2015 environment.

For example: php-5.6.12-Win32-VC11-x86 VC11 is 2012 environment.

If the corresponding environment is not installed, the prompt content will be very strange When configuring php + apache.

The system prompts "net helpmsg 3547" in

When the statement is entered correctly, the VC environment is also one of the causes. Remember.

Decompress Apache to C: \ www \ Apache24 \ and enter C: \ www \ Apache24 \ bin.

httpd.exe -k install -n "Apache24"
rem httpd.exe -k uninstall -n "Apache24"

Encountered error:

PHP configuration

Decompress php-5.6.12-win32-vc11-x86.zip to the directory and configure it in httpd. conf:

# php5 support

LoadModule php5_module "C: /php/php5apache2_4.dll"

AddHandler application/x-httpd-php .php

AddType application/x-httpd-php .html .htm

# configure thepath to php.ini

PHPIniDir " C:/php"

Writing the above behavior into a script can facilitate the next configuration and eliminate the problem of always changing the directory.

MYSQL Configuration

 

 [mysqld]

# These are commonly set, remove the # and set as required.

# Mysql root directory

basedir = "E:/BaiduBack/BaiduBack/PHPENV/mysql" 

# Mysql root directory

datadir = "E:/data" 

# Default port

port = 3306

# server_id = .....

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

# Server-side Encoding

character-set-server = utf8

[client]

# Client encoding method, preferably consistent with the server

loose-default-character-set = utf8 

Note: The MySQL administrator username is root, and the password is blank by default.

Multiple methods for changing the root password of MySQL

Method 1: use the set password command

Mysql-u root

Mysql> set password for 'root' @ 'localhost' = PASSWORD ('newpass ');

Method 2: Use mysqladmin

Mysqladmin-u root password "newpass"

If the root user has set a password, use the following method:

Mysqladmin-u root password oldpass "newpass"

Method 3: Use UPDATE to directly edit the user table

Mysql-u root

Mysql> use mysql;

Mysql> UPDATE user SET Password = PASSWORD ('newpass') WHERE user = 'root ';

Mysql> flush privileges;

When the root password is lost

Mysqld_safe -- skip-grant-tables &

Mysql-u root mysql

Mysql> UPDATE user SET password = PASSWORD ("new password") WHERE user = 'root ';

Mysql> flush privileges;