Configure PHP+MySql environment under Mac OS, osphp+mysql

Configure PHP+MySql environment under Mac OS, osphp+mysql_PHP tutorial

WBOY

Release： 2016-07-13 10:06:07

Original

883 people have browsed it

Configure PHP+MySql environment under Mac OS, osphp+mysql

Since mantis recently needs to be deployed for bug tracking, the process is recorded here.

Since the PHP apache environment comes with Mac OS, there is no need to install the installation package elsewhere, just a simple configuration.

First open the terminal and enter the command:

Copy code The code is as follows:

sudo vim /etc/apache2/httpd.conf

There is a line like this

Copy code The code is as follows:

#LoadModule php5_module libexec/apache2/libphp5.so

Remove the # sign in front.

Then open Sharing in System Preferences and check web sharing, as shown below

Restart apache, the command is as follows:

Copy code The code is as follows:

sudo apachectl restart

In this way, you can enter http://localhost/ in the browser, and if

appears

It works!

Description of successfully configuring the php environment

Let’s configure the MySql environment.

First download the dmg installation package of MySql. The download address is: http://dev.mysql.com/downloads/mysql/

Open the dmg file. There are three installation items in it. I installed all three here. After MySQLStartupItem.pkg is installed, mysql will start automatically when the system starts. MySQL.prefPane indicates that the mysql option can be seen in the system preferences. , and the other one is the mysql installation item.

In this way, the installation is successful. Open mysql in the system preferences and enable the service. After installation, the default username is root and the password is empty. For security, we set a password.

Open the terminal. If you enter mysql and you are prompted that there is no such command, you need to configure the environment variables of the mysql bin directory. The directory is, /usr/local/mysql/bin/, add it to the PATH variable. Here I introduce another method,

Enter

in the terminal

Copy code The code is as follows:

sudo vim /etc/bashrc

Then add

in it

Copy code The code is as follows:

#mysql
alias mysql='/usr/local/mysql/bin/mysql'
alias mysqladmin='/usr/local/mysql/bin/mysqladmin'

In this way, if you enter mysql in the terminal, you will have this command. In fact, it is somewhat similar to the macro definition in our C/C++, and the alias is used instead.

Then we change the root password, the command is as follows:

Copy code The code is as follows:

mysqladmin -uroot password 12345

This will change the root password to 12345.

To manage Mysql, if it is troublesome to use the command line, the open source phpMyAdmin adopts C/S mode for easy management. Then we install phpMyAdmin. It is developed by php, and the download address is: http://www.phpmyadmin.net/home_page/downloads.php

Put the downloaded unzipped file in the /Library/WebServer/Documents/ directory. The complete directory is: /Library/WebServer/Documents/phpmyadmin/, then enter this directory with the command line,

Enter the command:

Copy code The code is as follows:

cp config.sample.inc.php config.inc.php
vim config.inc.php

Make changes as follows:

Copy code The code is as follows:

$cfg['blowfish_secret'] = '';//For cookie encryption, any long string
$cfg['Servers'][$i]['host'] = '127.0.0.1';//MySQL daemon does IP binding

Now you can enter the URL in the browser: http://localhost/phpmyadmin/

Server name: root

The password is the password you set.

You can log in to the mysql management interface.

Okay, the above is all about configuring the PHP+MYSQL environment in MAC OS. I hope you guys like it.