首先是进入数据库
mysql -uroot -p123456;
进入mysql
use mysql;
执行:
create database newdatabase;
source /root/new.sql;
此时去连接数据库会发现连接不上,是因为没有给root权限
grant all privileges on *.* to 'root'@'%'identified by '123456' with grant option;"
grant all privileges on *.* to 'root'@'localhost'identified by '123456' with grant option;
添加完权限,需要刷新
grant all privileges on *.* to 'root'@'localhost'identified by '123456' with grant option;
flush privileges