search
HomeDatabasephpMyAdminDetailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1

Many tutorials on the Internet feel like they are half-covered with Pipa. Since you want to share, you have to make it clear and use more pictures. Really, it caused me to go crazy. Fortunately, I figured it out in the end, so let me post a related tutorial.

First of all, Macbook does have built-in apache

Enable the apache service through

apachectl start

You can enter localhost in the browser and see the result

Detailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1

It works! is correct. But for PHP, it was built-in from macOS

#Install phpDetailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1

brew installation

It is recommended to use brew installation

brew update # 不进行这一步我出现了missing bottle的错误
brew install php@7.4

Then you will see

That is Directly tell you how to configure apache and nginx, set them as global commands, and start them.

Configure in apacheDetailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1

打开apache的配置文件
cd /etc/apache2
sudo cp httpd.conf.bak #备份一下,防止修改文件出错
sudo chmod 666 httpd.conf #修改文件的权限,免得无法修改
# 可以通过 ls -l httpd.conf查看文件的权限
# -rw-r--r-- 初始权限,一般我们用户下是没有写权限的
vim httpd.conf #使用vim编辑
/LoadModule p   #定位在此,所有的LoadModule xxx都是按字母排序的,不要轻易打乱
i #启动插入编辑

Join

LoadModule php7_module /opt/homebrew/opt/php@7.4/lib/httpd/modules/libphp7.so

    <FilesMatch \.php$>
        SetHandler application/x-httpd-php
    </FilesMatch>

Change

to Detailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1

Add a line in Detailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1

AddType application/x-httpd-php .php

Verify whether the configuration file is correctDetailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1

apachectl -t
Syntax Ok appears successfully.

Modify PHP configuration file

cd /opt/homebrew/etc/php/7.4
ls -l php.ini. #先检查权限,没有写全县则使用chmod
Configuration of environment variables

echo 'export PATH="/opt/homebrew/opt/php@7.4/bin:$PATH"' >> ~/.zshrc
echo 'export PATH="/opt/homebrew/opt/php@7.4/sbin:$PATH"' >> ~/.zshrc
echo 'export LDFLAGS="-L/opt/homebrew/opt/php@7.4/lib"' >> ~/.zshrc
echo 'export CPPFLAGS="-I/opt/homebrew/opt/php@7.4/include"' >> ~/.zshrcsource ~/.zshrc 
#重新加载环境变量

Start php

brew services restart php@7.4

View apache server Has phpDetailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1

apachectl -M
sudo apachectl -k restart # 记得重启

been loaded successfully? ! !

Tested index.php fileDetailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1

In Finder

command

shift G, switch the path to /Library/WebServerOpen the introduction of the Documents folder

Click the lock to unlock Join the current user and give read and write permissions

Detailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1Detailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1

In the Documents folder, create a new index.php file (I write it in VSCode anyway)Detailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1

<?php     phpinfo();
    ?>
Verification

Open the browser and enter

http://localhost/index.php

You’re done! ! ! (PS: It took me more than four hours to get to this point, it’s too difficult)

Install phpmyadminDetailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1

Official website download compressed package

Address

cd /Users/zerotower/Documents
tar -zvxf xxx #你下载的压缩包
cp -rf /Users/zerotower/Downloads/phpMyAdmin-5.1.3-all-languages /Library/WebServer/Documents/phpmyadmin #把解压的文件放入apache服务器网站目录下
cd /Library/WebServer/Documents/phpmyadmin #进入服务器下的phpmyadmin目录
cp config.sample.inc.php config.inc.php #使用样例配置文件创建配置文件
vim config.inc.php

/blowfish
Modify the configuration, fill in the password as you like

and then enter it in the browser

http://localhost/phpmyadmin/index.php

Detailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1Just enter your database account password and you're done! ! !

Detailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1Finished scattering flowers! !

Problems encounteredDetailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1

Problems with certificate signing

When installing php, there will be

It is said to be a certificate verification problem

command

Detailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1spaceSearch keychain accessClick to enter to create certificate

Detailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1创建一张代码签名证书。

Detailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1证书始终信任

Detailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1

# 对php这个链接库进行签名
sudo codesign --sign "ztCA" --force --keychain  ~/Library/Keychains/login.keychain-db /opt/homebrew/opt/php@7.4/lib/httpd/modules/libphp7.so

修改httpd.conf 在原来的

LoadModule php7_module /opt/homebrew/opt/php@7.4/lib/httpd/modules/libphp7.so

改为

LoadModule php7_module /opt/homebrew/opt/php@7.4/lib/httpd/modules/libphp7.so "ztCA"复制代码

然后验证修改是否正确

apachectl -t

出现

Detailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1问题解决。

推荐学习:《phpmyadmin教程

The above is the detailed content of Detailed graphic and text explanation of the steps to install phpmyadmin on Macbook M1. For more information, please follow other related articles on the PHP Chinese website!

Statement
This article is reproduced at:juejin. If there is any infringement, please contact admin@php.cn delete
phpMyAdmin's Function: Interacting with MySQL (SQL)phpMyAdmin's Function: Interacting with MySQL (SQL)May 07, 2025 am 12:16 AM

phpMyAdmin simplifies MySQL database management through the web interface. 1) Create databases and tables: Use graphical interface to operate easily. 2) Execute complex queries: such as JOIN query, implemented through SQL editor. 3) Optimization and best practices: including SQL query optimization, index management and data backup.

MySQL vs. phpMyAdmin: Understanding the Key DifferencesMySQL vs. phpMyAdmin: Understanding the Key DifferencesMay 06, 2025 am 12:17 AM

MySQL is a database management system, and phpMyAdmin is a web tool for managing MySQL. 1.MySQL is used to store and manage data and supports SQL operations. 2.phpMyAdmin provides a graphical interface to simplify database management.

phpMyAdmin: Accessing and Managing MySQL DatabasesphpMyAdmin: Accessing and Managing MySQL DatabasesMay 05, 2025 am 12:08 AM

phpMyAdmin provides an intuitive interface through the browser to help manage MySQL databases. 1. Create a database and table: Enter the code in the "SQL" tab and execute it. 2. Optimize table: Use the "OPTIMIZETABLE" command to improve query performance. 3. Permission management: Use the "SHOWGRANTS" and "GRANT" commands to check and modify permissions. 4. Performance optimization: regularly optimize tables, use indexes, and avoid large-scale imports.

MySQL: The Engine, phpMyAdmin: The User InterfaceMySQL: The Engine, phpMyAdmin: The User InterfaceMay 04, 2025 am 12:02 AM

MySQL and phpMyAdmin are powerful database tools, and their combination provides convenience for database management. MySQL's high performance, scalability and security make it the first choice for database engines, while phpMyAdmin's database management, data import and export, and user management capabilities simplify database operations. The actual case shows how they work together, and provides optimization strategies such as index optimization, query optimization, caching mechanism and phpMyAdmin configuration tuning to improve performance.

The Role of SQL in phpMyAdmin: A Deep DiveThe Role of SQL in phpMyAdmin: A Deep DiveMay 03, 2025 am 12:07 AM

SQL's role in phpMyAdmin is multifaceted, including data operation, database design, optimization and maintenance. 1.SQL is used for basic data operations, such as querying and inserting data. 2.SQL supports complex queries, view creation and stored procedure writing. 3. In phpMyAdmin, SQL commands are executed through the MySQL server, and the results are displayed in a table form. 4. Users can perform performance optimization through SQL, such as indexing and query optimization.

Beyond the Interface: phpMyAdmin and the Power of SQLBeyond the Interface: phpMyAdmin and the Power of SQLMay 02, 2025 am 12:21 AM

The combination of phpMyAdmin and SQL allows users to directly enter and execute SQL commands, implementing more complex queries and database management. 1) In phpMyAdmin, you can execute SQL commands, such as SELECTFROMusersWHEREage>30; 2) Use the EXPLAIN command to analyze the execution plan of the query and optimize performance; 3) By creating indexes, avoiding SELECT and using LIMIT, the query efficiency can be significantly improved.

phpMyAdmin: Managing SQL Databases with EasephpMyAdmin: Managing SQL Databases with EaseMay 01, 2025 am 12:24 AM

phpMyAdmin is a tool for managing MySQL and MariaDB databases through a web interface. 1) Create a database: Use the CREATEDATABASE command. 2) Create table and insert data: Use the CREATETABLE and INSERTINTO commands. 3) Create a view: Use the CREATEVIEW command to simplify querying. 4) Optimize table: Use the OPTIMIZETABLE command to improve query speed.

Is phpMyAdmin a Database? Clarifying Its RoleIs phpMyAdmin a Database? Clarifying Its RoleApr 30, 2025 am 12:13 AM

phpMyAdminisnotadatabase;it'saweb-basedtoolformanagingMySQLandMariaDBdatabases.Itoffersfeatureslikecreating/modifyingdatabases,executingSQLqueries,managingusers/permissions,andimporting/exportingdata.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SecLists

SecLists

SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

MantisBT

MantisBT

Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use