wupher
2/1/2017 - 9:36 AM

Create Database and adding user for it

Create Database and adding user for it

new_gist_file.sql
content_copyfile_download
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;