轉(zhuǎn)載于:https://www.cnblogs.com/ichunqiu/articles/6831785.html
總結(jié)一下:
MySQL數(shù)據(jù)庫(kù)拿到訪問(wèn)權(quán)之后的一些信息收集語(yǔ)句:
顯示版本:select version();
顯示字符集:select @@character_set_database;
顯示數(shù)據(jù)庫(kù)show databases;
顯示表名:show tables;
顯示計(jì)算機(jī)名:select @@hostname;
顯示系統(tǒng)版本:select @@version_compile_os;
顯示mysql路徑:select @@basedir;
顯示數(shù)據(jù)庫(kù)路徑:select @@datadir;
顯示root密碼:select User,Password from mysql.user;
開(kāi)啟外連:GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;