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
MySQL and phpMyAdmin: Core Features and FunctionsMySQL and phpMyAdmin: Core Features and FunctionsApr 22, 2025 am 12:12 AM

MySQL and phpMyAdmin are powerful database management tools. 1) MySQL is used to create databases and tables, and to execute DML and SQL queries. 2) phpMyAdmin provides an intuitive interface for database management, table structure management, data operations and user permission management.

phpMyAdmin: Generating and Executing SQL QueriesphpMyAdmin: Generating and Executing SQL QueriesApr 21, 2025 am 12:03 AM

The methods of generating and executing SQL queries in phpMyAdmin include: 1. Enter the query in the SQL tab and click to execute; 2. Use JOIN to merge table data; 3. Use index and LIMIT when optimizing queries. phpMyAdmin simplifies database management through an intuitive interface, supporting SQL query operations from basic to advanced.

MySQL and phpMyAdmin: How They Work TogetherMySQL and phpMyAdmin: How They Work TogetherApr 20, 2025 am 12:05 AM

We need to combine database management with a user-friendly interface because this can improve efficiency and convenience. 1) MySQL handles complex data storage and queries, 2) phpMyAdmin provides intuitive web interface to simplify management, 3) The two collaborate to implement data operations through SQL commands, and 4) phpMyAdmin displays the results in a user-friendly way.

phpMyAdmin and SQL: Exploring the ConnectionphpMyAdmin and SQL: Exploring the ConnectionApr 19, 2025 am 12:05 AM

phpMyAdmin manages MySQL databases by generating and executing SQL statements. 1. The user operates through the web interface, 2.phpMyAdmin generates SQL statements, 3. Sends to the MySQL server for execution, 4. Returns the result and displays it in the browser.

phpMyAdmin: Key Features and Capabilities ExplainedphpMyAdmin: Key Features and Capabilities ExplainedApr 18, 2025 am 12:04 AM

phpMyAdmin is a web-based MySQL database management tool that allows users to manage databases through a graphical user interface (GUI). 1. It interacts with the MySQL database through PHP scripts, converts user operations into SQL queries and renders the results. 2. Basic usage includes creating databases and tables, such as creating databases named 'my_database' and 'users' tables. 3. Advanced usage supports complex queries and user permission management, such as finding users with specific user names. 4. Common error debugging techniques include checking SQL syntax, managing permissions, and viewing logs. 5. Performance optimization suggestions include index optimization, query optimization and ensuring security.

phpMyAdmin's Interface: Simplifying SQL OperationsphpMyAdmin's Interface: Simplifying SQL OperationsApr 17, 2025 am 12:01 AM

phpMyAdmin simplifies SQL operations through a graphical interface and improves database management efficiency. 1) Provide an intuitive GUI without directly writing SQL statements; 2) Interact with MySQL through PHP scripts to transparently handle complex operations; 3) Support basic operations such as creating tables and advanced functions such as data export. Pay attention to permissions and SQL syntax errors when using it, and optimize queries, regular backups and ensure security settings.

SQL and phpMyAdmin: A Beginner's GuideSQL and phpMyAdmin: A Beginner's GuideApr 16, 2025 am 12:02 AM

Beginners can learn SQL and phpMyAdmin from scratch. 1) Create database and tables: Create a new database in phpMyAdmin and create tables using SQL commands. 2) Execute basic query: Use SELECT statement to query data from the table. 3) Optimization and best practices: Create indexes, avoid SELECT*, use transactions, and regularly back up databases.

MySQL, phpMyAdmin, and Database Administration: A GuideMySQL, phpMyAdmin, and Database Administration: A GuideApr 15, 2025 am 12:01 AM

MySQL and phpMyAdmin are powerful database management tools. 1.MySQL is an open source relational database management system, and phpMyAdmin is a MySQL management tool based on the Web. 2.MySQL works through the client-server model, and phpMyAdmin simplifies database operations. 3. Basic usage includes creating tables and data operations, and advanced usage involves stored procedures and triggers. 4. Common errors include SQL syntax errors, permission issues and performance bottlenecks. 5. Optimization techniques include reasonable use of indexes, optimized query, regular maintenance and backup and recovery.

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 Tools

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

Atom editor mac version download

Atom editor mac version download

The most popular open source editor