


Detailed 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
It works!
is correct.
But for PHP, it was built-in from macOS
#Install php
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 apache
打开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
Add a line in
AddType application/x-httpd-php .php
Verify whether the configuration file is correct
apachectl -tSyntax Ok appears successfully. Modify PHP configuration file
cd /opt/homebrew/etc/php/7.4 ls -l php.ini. #先检查权限,没有写全县则使用chmodConfiguration 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 phpbrew services restart php@7.4
View apache server Has php
apachectl -M sudo apachectl -k restart # 记得重启
been loaded successfully? ! !
Tested index.php file
command
shift
G, switch the path to /Library/WebServer
Open the introduction of the Documents folder
In the Documents folder, create a new index.php file (I write it in VSCode anyway)
<?php phpinfo(); ?>VerificationOpen 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 phpmyadmin
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
/blowfishModify the configuration, fill in the password as you like
and then enter it in the browser
http://localhost/phpmyadmin/index.phpJust enter your database account password and you're done! ! !
Finished scattering flowers! !
Problems encountered
It is said to be a certificate verification problem
command space
Search keychain access
Click to enter to create certificate
创建一张代码签名证书。
证书始终信任
# 对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
出现
问题解决。
推荐学习:《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!

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 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 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 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.

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.

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 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.

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


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

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
Easy-to-use and free code editor

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
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
Powerful PHP integrated development environment

SublimeText3 Chinese version
Chinese version, very easy to use
