search
HomeDatabaseMysql Tutorial配置最新的PHP加MYSQL服务器完全版_MySQL

配置最新的PHP加MYSQL服务器完全版_MySQL

Jun 01, 2016 pm 02:12 PM
phpReviseInstallup to dateserverConfiguration


  通过一个小时的研究和设置.实现了最新的 PHP 5.0 + MYSQL 5.0 + WIN2003.
  个人认为还是有必要写个教程出来.因为很多方面和老版本的不尽相同.
  说实话自己也是查阅了很多官方文档才解决了很多怪异问题.
  
  MYSQL 5.0 FOR WINDOWS
  PHP 5.0 FOR WINDOWS
  PHPMYADMIN
  WINDOWS SERVER 2003
  
  首先安装 MYSQL .本来以为新版本的安装界面应该会花哨点.
  但是仍然只看到老土的海豚.除了安装时间比 4.0 长.当然咯.因为 5.0 比 4.0 体积大很多.
  
  推荐安装在独立的 NTFS 分区上.比如我服务器的 F盘.只放服务器软件.
  路径为: F:\MYSQL
  然后进入 F:\MYSQL\BIN\ 鼠标双点 winmysqladmin.exe
  首次运行会提示输入超级用户和密码.就输入 root 密码 root
  注意啊.如果是对外服务器请设置超级复杂.比如 Wjwsfjn29szjwh~mysql
  翻译过来就是: 我叫魏舒芬.今年29岁至今未婚.
  
  到这里.MYSQL就安装完毕了.如果不明白请参看深空同学的相关文章.
  
  下面安装 PHP 5.0 其实没什么安装不安装的.解压缩文件.推荐放到路径为: F:\PHP
  到这里就应该进入关键步骤了.
  首先复制 PHP 目录下的 Php.ini-dist 到 C:\Windows\ 并将文件名修改成为 Php.ini
  
  COPY F:\PHP\Php.ini-dist C:\Windows
  Ren Php.ini-dist Php.ini
  
  如果是 WINDOWS 2000 就是: C:\WINNT如果是 WIN9X / 2003 就是: C:\Windows
  然后复制 PHP 目录下 DLLS 目录里的所有文件到 SYSTEM32 目录.
  
  COPY F:\PHP\dlls\*.* C:\Windows\System32
  如果是 WINDOWS 2000 就是: C:\WINNT\System32如果是 WIN9X / 2003 就是: C:\Windows\System32
  继续.复制PHP目录下 php4ts.dll 文件到 System32 目录里.
  
  COPY F:\PHP\php4ts.dll C:\Windows\System32
  到这里复制工作全部完成.下面修改 C:\Windows\Php.ini 文件.
  
  请注意.5.0的版本修改与4.0并不完全相同.需要注意的如下.
  
  查找 extension_dir 字串.修改为你 PHP 目录里 extensions 的路径.
  
  ; Directory in which the loadable extensions (modules) reside.
  extension_dir = F:\PHP\extensions
  
  然后与 PHP 4.0 不同的是.需要修改 Php.ini 文件里的如下内容:
  查找 cgi.force_redirect 字串.默认值为1.将其修改为0.并取消前面的;号.
  
  即:
  
  ; cgi.force_redirect is necessary to provide security running PHP as a CGI under
  ; most web servers. Left undefined, PHP turns this on by default. You can
  ; turn it off here AT YOUR OWN RISK
  ; **You CAN safely turn this off for IIS, in fact, you MUST.**
  cgi.force_redirect = 0
  
  切记如上修改的地方.否则PHP 5.0是无法运行的.会有如下提示.
  
  Security Alert! The PHP CGI cannot be accessed directly.
  
  相关官方技术资料:
  
  !NOTE!: Since 4.1.2, the php.ini setting cgi.force_redirect defaults to '1' which effectively prevents the cgi from working within IIS. You need to set
  up at least a minimal php.ini file with the following directive:
  
  cgi.force_redirect = 0
  
  If it doesn't work immidiately, make sure you have the php.ini file in the
  right place (%SYSTEMROOT%\php.ini).
  
  接下来修改 Php.ini 文件关于 MYSQL 5.0 的设置.
  
  查找 [MySQL] 字段内的内容.修改如下.
  
  mysql.default_port = 3306
  // 这里是MYSQL的端口.
  
  mysql.default_host = localhost
  // 这里是本地主机.
  
  mysql.default_user = root
  // 这里是用户
  
  mysql.default_password = Wjwsfjn29szjwh~mysql
  // 这里是密码
  
  修改到这里就可以让 Php 与 MYSQL 关联了.
  最后启动 PHP 对 MYSQL 模块支持.
  
  查找 extension=php_mysql.dll 字串.删除掉前面的 ; 号
  
  extension=php_mysql.dll
  
  请注意.如果不启动 PHP 对 MYSQL 模块支持.将无法使 PHPMYADMIN 正常工作.将提示:
  
  cannot load MySQL extension, please check PHP Configuration
  无法装入 MySQL 扩展,请检查 PHP 的配置。
  
  相关官方技术资料:
  
  To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension".
  This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically.
  Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.
  
  到这里应该就没有很大问题了.如果有配置基础的朋友应该完全可以理解了.
  本人在实际配置的时候也遇到了很多问题.最后都是耐心查询官方文档得到了解决.
  
Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
What are stored procedures in MySQL?What are stored procedures in MySQL?May 01, 2025 am 12:27 AM

Stored procedures are precompiled SQL statements in MySQL for improving performance and simplifying complex operations. 1. Improve performance: After the first compilation, subsequent calls do not need to be recompiled. 2. Improve security: Restrict data table access through permission control. 3. Simplify complex operations: combine multiple SQL statements to simplify application layer logic.

How does query caching work in MySQL?How does query caching work in MySQL?May 01, 2025 am 12:26 AM

The working principle of MySQL query cache is to store the results of SELECT query, and when the same query is executed again, the cached results are directly returned. 1) Query cache improves database reading performance and finds cached results through hash values. 2) Simple configuration, set query_cache_type and query_cache_size in MySQL configuration file. 3) Use the SQL_NO_CACHE keyword to disable the cache of specific queries. 4) In high-frequency update environments, query cache may cause performance bottlenecks and needs to be optimized for use through monitoring and adjustment of parameters.

What are the advantages of using MySQL over other relational databases?What are the advantages of using MySQL over other relational databases?May 01, 2025 am 12:18 AM

The reasons why MySQL is widely used in various projects include: 1. High performance and scalability, supporting multiple storage engines; 2. Easy to use and maintain, simple configuration and rich tools; 3. Rich ecosystem, attracting a large number of community and third-party tool support; 4. Cross-platform support, suitable for multiple operating systems.

How do you handle database upgrades in MySQL?How do you handle database upgrades in MySQL?Apr 30, 2025 am 12:28 AM

The steps for upgrading MySQL database include: 1. Backup the database, 2. Stop the current MySQL service, 3. Install the new version of MySQL, 4. Start the new version of MySQL service, 5. Recover the database. Compatibility issues are required during the upgrade process, and advanced tools such as PerconaToolkit can be used for testing and optimization.

What are the different backup strategies you can use for MySQL?What are the different backup strategies you can use for MySQL?Apr 30, 2025 am 12:28 AM

MySQL backup policies include logical backup, physical backup, incremental backup, replication-based backup, and cloud backup. 1. Logical backup uses mysqldump to export database structure and data, which is suitable for small databases and version migrations. 2. Physical backups are fast and comprehensive by copying data files, but require database consistency. 3. Incremental backup uses binary logging to record changes, which is suitable for large databases. 4. Replication-based backup reduces the impact on the production system by backing up from the server. 5. Cloud backups such as AmazonRDS provide automation solutions, but costs and control need to be considered. When selecting a policy, database size, downtime tolerance, recovery time, and recovery point goals should be considered.

What is MySQL clustering?What is MySQL clustering?Apr 30, 2025 am 12:28 AM

MySQLclusteringenhancesdatabaserobustnessandscalabilitybydistributingdataacrossmultiplenodes.ItusestheNDBenginefordatareplicationandfaulttolerance,ensuringhighavailability.Setupinvolvesconfiguringmanagement,data,andSQLnodes,withcarefulmonitoringandpe

How do you optimize database schema design for performance in MySQL?How do you optimize database schema design for performance in MySQL?Apr 30, 2025 am 12:27 AM

Optimizing database schema design in MySQL can improve performance through the following steps: 1. Index optimization: Create indexes on common query columns, balancing the overhead of query and inserting updates. 2. Table structure optimization: Reduce data redundancy through normalization or anti-normalization and improve access efficiency. 3. Data type selection: Use appropriate data types, such as INT instead of VARCHAR, to reduce storage space. 4. Partitioning and sub-table: For large data volumes, use partitioning and sub-table to disperse data to improve query and maintenance efficiency.

How can you optimize MySQL performance?How can you optimize MySQL performance?Apr 30, 2025 am 12:26 AM

TooptimizeMySQLperformance,followthesesteps:1)Implementproperindexingtospeedupqueries,2)UseEXPLAINtoanalyzeandoptimizequeryperformance,3)Adjustserverconfigurationsettingslikeinnodb_buffer_pool_sizeandmax_connections,4)Usepartitioningforlargetablestoi

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

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

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.

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.

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment