requireluasql.mysql_luarocks错误require‘luasql.mysql'报module'luasql.mysql'notfound:

错误&＃xff1a;

require &＃39;luasql.mysql&＃39;

stdin:1: module &＃39;luasql.mysql&＃39; not found:

no field package.preload[&＃39;luasql.mysql&＃39;]

no file &＃39;/usr/local/share/lua/5.3/luasql/mysql.lua&＃39;

no file &＃39;/usr/local/share/lua/5.3/luasql/mysql/init.lua&＃39;

no file &＃39;/usr/local/lib/lua/5.3/luasql/mysql.lua&＃39;

no file &＃39;/usr/local/lib/lua/5.3/luasql/mysql/init.lua&＃39;

no file &＃39;./luasql/mysql.lua&＃39;

no file &＃39;./luasql/mysql/init.lua&＃39;

no file &＃39;/usr/local/lib/lua/5.3/luasql/mysql.so&＃39;

no file &＃39;/usr/local/lib/lua/5.3/loadall.so&＃39;

no file &＃39;./luasql/mysql.so&＃39;

no file &＃39;/usr/local/lib/lua/5.3/luasql.so&＃39;

no file &＃39;/usr/local/lib/lua/5.3/loadall.so&＃39;

no file &＃39;./luasql.so&＃39;

stack traceback:

[C]: in function &＃39;require&＃39;

stdin:1: in main chunk

[C]: in ?

环境&＃xff1a; ubuntu 已安装lua&＃xff0c;未安装mysql

解决方案

一、先安装mysql

Ubuntu上安装MySQL非常简单只需要几条命令就可以完成。

1. sudo apt-get install mysql-server

2. apt-get isntall mysql-client

3.  sudo apt-get install libmysqlclient-dev

参考链接

http://www.linuxidc.com/Linux/2016-07/133128.htm

二 安装luasql-mysql

luarocks install luasql-mysql

参考链接 http://www.runoob.com/lua/lua-database-access.html

三 安装luasql-mysql 出错

Error: Could not find header file for MYSQL

No file mysql.h in /usr/local/mysql

You may have to install MYSQL in your system and/or pass MYSQL_DIR or MYSQL_INCDIR to the luarocks command.

Example: luarocks install luasql-mysql MYSQL_DIR&＃61;/usr/local

解决方法&＃xff1a;

在终端执行whereis mysql 找到mysql 的include路径

luarocks install luasql-mysql MYSQL_INCDIR&＃61;/usr/include/mysql

注释&＃xff1a;配置自己查到的mysql.h 所在路径