require "luasql.mysql"_luarocks错误 require ‘luasql.mysql' 报module 'luasql.mysql' not found:

错误：

require ‘luasql.mysql‘

stdin:1: module ‘luasql.mysql‘ not found:

no field package.preload[‘luasql.mysql‘]

no file ‘/usr/local/share/lua/5.3/luasql/mysql.lua‘

no file ‘/usr/local/share/lua/5.3/luasql/mysql/init.lua‘

no file ‘/usr/local/lib/lua/5.3/luasql/mysql.lua‘

no file ‘/usr/local/lib/lua/5.3/luasql/mysql/init.lua‘

no file ‘./luasql/mysql.lua‘

no file ‘./luasql/mysql/init.lua‘

no file ‘/usr/local/lib/lua/5.3/luasql/mysql.so‘

no file ‘/usr/local/lib/lua/5.3/loadall.so‘

no file ‘./luasql/mysql.so‘

no file ‘/usr/local/lib/lua/5.3/luasql.so‘

no file ‘/usr/local/lib/lua/5.3/loadall.so‘

no file ‘./luasql.so‘

stack traceback:

[C]: in function ‘require‘

stdin:1: in main chunk

[C]: in ?

环境： ubuntu 已安装lua，未安装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=/usr/local

解决方法：

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

luarocks install luasql-mysql MYSQL_INCDIR=/usr/include/mysql

注释：配置自己查到的mysql.h 所在路径

原文：http://www.cnblogs.com/a9999/p/6873868.html