How to install PHP and MySQL on macos
macOS is a very popular operating system, and more and more people are turning to it for programming and development work. Among them, PHP and MySQL are widely used as very important development tools. This article will introduce how to install PHP and MySQL under macOS.
Deployment environment
macOS system version: macOS Big Sur
Installation steps
- Install Homebrew
Homebrew It is a very popular package management tool under macOS, which can facilitate us to install and manage various software packages. First you need to install Homebrew, which you can do through the installation instructions provided on the official website. After the installation is complete, run the following command to update Homebrew:
brew update
- Install PHP
Installing PHP through Homebrew is very simple, just run the following command:
brew install php
After the installation is complete, you can run the following command to view the installed PHP version:
php -v
If the php command is not found, you need to add the path to the PATH environment variable:
echo 'export PATH="/usr/local/opt/php/bin:$PATH"' >> ~/.bash_profile
- Install MySQL
Currently MySQL has been acquired by Oracle, and the latest version has been renamed MySQL Community Server. You can install MySQL Community Server through Homebrew, or you can download the dmg installation package from the official website for installation. Here is a demonstration of installing MySQL Community Server through Homebrew, just run the following command:
brew install mysql
After the installation is complete, you can run the following command to start the MySQL service:
brew services start mysql
If you need to stop the MySQL service, you can run the following Command:
brew services stop mysql
Before starting MySQL, you need to initialize it. You can run the following command to initialize:
mysql_secure_installation
This command will prompt you to enter the root account password, and you need to set a new password.
- Configuring PHP and MySQL
First you need to connect PHP and MySQL, which can be achieved by installing the php-mysql extension:
brew install php-mysql
Installation completed Finally, you need to edit the PHP configuration file php.ini and remove the comments on the following two lines:
;extension=mysqli.so ;extension=pdo_mysql.so
After modification, save and exit.
- Test
Enter the following command through the command line:
php -r 'mysql_connect("localhost", "root", "");'
If no error is reported, it means that PHP and MySQL have been successfully connected.
Summary
This article introduces the process of installing PHP and MySQL under macOS Big Sur. Installation through Homebrew is very simple. After installing PHP and MySQL, you still need to configure and connect them to work. Hope this article is helpful to everyone.
The above is the detailed content of How to install PHP and MySQL on macos. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



PHP 8's JIT compilation enhances performance by compiling frequently executed code into machine code, benefiting applications with heavy computations and reducing execution times.

The article discusses securing PHP file uploads to prevent vulnerabilities like code injection. It focuses on file type validation, secure storage, and error handling to enhance application security.

The article discusses OWASP Top 10 vulnerabilities in PHP and mitigation strategies. Key issues include injection, broken authentication, and XSS, with recommended tools for monitoring and securing PHP applications.

The article discusses symmetric and asymmetric encryption in PHP, comparing their suitability, performance, and security differences. Symmetric encryption is faster and suited for bulk data, while asymmetric is used for secure key exchange.

Article discusses retrieving data from databases using PHP, covering steps, security measures, optimization techniques, and common errors with solutions.Character count: 159

The article discusses implementing robust authentication and authorization in PHP to prevent unauthorized access, detailing best practices and recommending security-enhancing tools.

Prepared statements in PHP enhance database security and efficiency by preventing SQL injection and improving query performance through compilation and reuse.Character count: 159

The article discusses strategies for implementing API rate limiting in PHP, including algorithms like Token Bucket and Leaky Bucket, and using libraries like symfony/rate-limiter. It also covers monitoring, dynamically adjusting rate limits, and hand
