linux搭sql,【IT专家】Linux下搭建sqli

本文由我司收集整编，推荐下载，如有疑问，请与我司联系

Linux下搭建sqli

2017/10/15 218 Host OS: win10Guest OS：ubuntu-14.04.5-server-amd64

使用到的工具：putty+WinSCP(上传文件)

sqli-labs下载：https://github/Audi-1/sqli-labs

使用LNMPweb集成开发环境，LNMP安装：https://lnmp/install.html

lnmp安装完成后会提示MySQL密码，默认是安装时候输入的root密码：

MySQL/MariaDB root password: yourrootpassword并且LNMP自动start了，将下载好的sqli-labs文件上传到/home/wwwroot/default/目录

切换到sqli-labs/sql-connections目录

cd /home/wwwroot/default/sqli-labs/sql-connections修改此目录下的db-creds.inc文件

?php//give your mysql connection username n password$dbuser =‘root’;$dbpass =‘yourrootpassword’;$dbname =“security”;$host = ‘localhost’;$dbname1 = “challenges”;? 接着运行setup-db.php：

php setup-db.php运行失败，提示：PHP Warning: mysql_connect(): Access denied for user ‘root’@’localhost’ (using password: YES) in /home/wwwroot/default/sqlilabs/sql-connections/setup-db.php on line 29 [*]...................Could not connect to DB, check the creds in db-creds.inc: Access denied for user ‘root’@’localhost’ (using password: YES)

切换到root用户，还是运行失败。

解决方法：修改MySQL密码：

mysql -uroot -p接着输入密码，

mysql use mysql;mysql UPDATE user SET password=PASSWORD(‘mypassword’) WHERE user=‘root’;mysql FLUSH PRIVILEGES;mysql quit;再一次php setup-db.php： ················省略[*]...................Old database ‘SECURITY’ purged if exists br br [*]...................Creating New database ‘SECURITY’ successfully br br [*]...................Creating New Table ‘USERS’ successfully br br [*]...................Creating