Last active
May 27, 2021 06:39
-
-
Save tanaka-geek/9d86dd83ae97e933c012175aa3419c8e to your computer and use it in GitHub Desktop.
Create a new account and set up database/tables
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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