Shulou(Shulou.com)06/01 Report--

Today I want to write a blog again, cut the crap, here we go, hey. Today I practiced creating users in mysql, and BUG appeared. A deleted user can still log in through his account and password, and finally have no choice but to truncate table mysql.user; and then re-write the user into this table one by one. Grant all on. * to 'root'@'%' identified by' 123456. Every time you execute a grant command, you need to refresh the permission table of the database. Otherwise, an error will be reported. Flush privileges; is playing HIGH. I want to open the discuz forum. I will go and show me this:

A check on the Internet, my location is the problem of the database, I can see that there is no connection to the database, ah, all kinds of log check ah. Finally, find these three files / config/config_global.php,/config/config_ucenter.php,/uc_server/data/config.inc.php. Because of the long interval, I forgot the password I set, so I redefined the discuz database password and changed the account password in these three files to the one I use now (the problem of emptying the user table myself! Restart apache and mysql, and the problem is solved.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.