ubuntu 下php的mysql 扩展模块_MySQL-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

ubuntu 下php的mysql 扩展模块_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 01, 2016 pm 01:10 PM

Ubuntu

之前php 与 nginx 环境已经搭建好了。但是php还没有集成mysql。没数据库啥也玩不转。放假下午在家没事便开始搞。

开始谷歌之旅~

坑一：最先找到 让改/usr/local/lib/php.ini 将     ;extension=php_mysqli.dll 前面的分号； （注释）去掉。应该开启mysql 模块吧。但是后来一看居然是windows下的配置。俺没仔细看文档内容啊。。 哭。习惯遇见大段英文就跳过的后果啊！坑二：接着谷歌到 我电脑的php 需要安装mysql连接插件：于是便有了一下命令：

sudo apt-get install php5-mysql php5-curl php5-gd php5-intl php-pear php5-imagick php5-imap php5-mcrypt php5-memcache php5-ming php5-ps php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl

执行后 一直报错 大致意思是php5-imagick 这个安装不正确。终端显示：

E: Sub-process /usr/bin/dpkg returned an error code (1) bug 哎。。我了个去这又是什么。谷歌说大致是因为用apt-get install 安装导致的问题。于是我又用谷歌解决了下这个问题。。不过好像也与我的目的没什么关系。

坑三：再次怀着悲壮的心情谷歌。大致的意思是 让我在php的安装目录（我是通过源码安装的） 编译出 mysql.so。在配置php.ini来生效。

当我在php的安装目录下进行
cd ext/mysql
/usr/local/bin/phpize
./configure –with-php-config=/usr/local/bin/php-config –with-mysql=/usr/local/mysql/
发生错误 –with-mysql = 后面的路径不存在。
我更改成–with-mysql 不设置地址。让内核自动寻找。
又发生错误

ubuntu ext/mysqlnd/mysqlnd.h：No such file or directory

这又是啥！这让老夫如何是好！

终于啊！ 使出大招。 卸载php 在php 安装目录下 执行 sudo make distclean 然后重新安装执行./configure  --enable-sockets=shared  --with-mysql=shared,mysqlnd --enable-fpmmakemake install 执行后。在php中写下访问mysql的代码 成功！

但是我对这块还是迷迷糊糊的。现在只能是先让它能跑再说。以后再学习吧。

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

Adding Users to MySQL: The Complete TutorialMay 12, 2025 am 12:14 AM

Mastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.

Mastering MySQL String Data Types: VARCHAR vs. TEXT vs. CHARMay 12, 2025 am 12:12 AM

ChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic

MySQL: String Data Types and Indexing: Best PracticesMay 12, 2025 am 12:11 AM

Best practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.

MySQL: How to Add a User RemotelyMay 12, 2025 am 12:10 AM

ToaddauserremotelytoMySQL,followthesesteps:1)ConnecttoMySQLasroot,2)Createanewuserwithremoteaccess,3)Grantnecessaryprivileges,and4)Flushprivileges.BecautiousofsecurityrisksbylimitingprivilegesandaccesstospecificIPs,ensuringstrongpasswords,andmonitori

The Ultimate Guide to MySQL String Data Types: Efficient Data StorageMay 12, 2025 am 12:05 AM

TostorestringsefficientlyinMySQL,choosetherightdatatypebasedonyourneeds:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseTEXTforlong-formtextcontent.4)UseBLOBforbinarydatalikeimages.Considerstorageov

MySQL BLOB vs. TEXT: Choosing the Right Data Type for Large ObjectsMay 11, 2025 am 12:13 AM

When selecting MySQL's BLOB and TEXT data types, BLOB is suitable for storing binary data, and TEXT is suitable for storing text data. 1) BLOB is suitable for binary data such as pictures and audio, 2) TEXT is suitable for text data such as articles and comments. When choosing, data properties and performance optimization must be considered.

MySQL: Should I use root user for my product?May 11, 2025 am 12:11 AM

No,youshouldnotusetherootuserinMySQLforyourproduct.Instead,createspecificuserswithlimitedprivilegestoenhancesecurityandperformance:1)Createanewuserwithastrongpassword,2)Grantonlynecessarypermissionstothisuser,3)Regularlyreviewandupdateuserpermissions

MySQL String Data Types Explained: Choosing the Right Type for Your DataMay 11, 2025 am 12:10 AM

MySQLstringdatatypesshouldbechosenbasedondatacharacteristicsandusecases:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseBINARYorVARBINARYforbinarydatalikecryptographickeys.4)UseBLOBorTEXTforlargeuns

See all articles