1
mysqldump -uroot -p datebase > datebase.sql

1
mysql -uroot -p datebase < datebase.sql

1
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

1
FLUSH PRIVILEGES;

1
CREATE USER root @'%' identified BY '123456';

1
GRANT ALL privileges ON *.* TO root @'%' WITH GRANT OPTION;

1
FLUSH PRIVILEGES;