


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!

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.

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.

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

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


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

SublimeText3 English version
Recommended: Win version, supports code prompts!

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
God-level code editing software (SublimeText3)

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
The most popular open source editor