CREATE DATABASE `final` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

DROP DATABASE final;

CREATE USER 'fanwu'@'%' IDENTIFIED BY '123456';

GRANT ALL PRIVILEGES ON final.* TO 'fanwu';

FLUSH PRIVILEGES ;

# Modify  root password

use mysql;
update user set password=PASSWORD("mynewpassword") where User='root';
flush privileges;