mysql 惯用语句 - IDC云服务

mysql 常用语句

mysql bat 文件

c:

cd C:\Program Files\MySQL\MySQL Server 5.5\bin

##for /f “tokens=2 delims=:” %%i in (‘ipconfig ^|findstr /i “ip address”‘) do set ip=%%i

##echo %ip%

set “Ymd=%date:~,4%%date:~5,2%%date:~8,2%”

echo %ymd%

mysqldump -u a -pa pwvm > d:\pwvm__%ymd%_dump.sql

mysqldump -u a -pa monitor > d:\monitor_%ymd%_dump.sql

copy d:\pwvm__%ymd%_dump.sql \\10.10.55.140\140共享\db\dump

copy d:\monitor_%ymd%_dump.sql \\10.10.55.140\140共享\db\dump

———————–

创建用户

CREATE USER ‘a’@’%’ IDENTIFIED BY ‘a’;

GRANT all ON *.* TO ‘a’@’%’;

CREATE SCHEMA `pwvm` DEFAULT CHARACTER SET utf8 ;

CREATE SCHEMA `monitor` DEFAULT CHARACTER SET utf8 ;

SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(“a”);

——————————————————

赋权限

GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@’%’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;

FLUSH PRIVILEGES;

相关文章：

你感兴趣的文章：

标签云：