catalog.md

Mysql 数据库相关

安装

使用

备份

mac os install mysql.md

Mac OS 安装 Mysql

首先要安装 homebrew

brew install mysql 

brew services start mysql

mysql -uroot

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456@';

flush privileges;

mysql_back.bat

@echo mysql bak
@echo off
set yy=%date:~0,4%
set mm=%date:~5,2%
set dd=%date:~8,2%
if /i %time:~0,2% lss 10 set hh=0%time:~1,1%
if /i %time:~0,2% geq 10 set hh=%time:~0,2%
set mn=%time:~3,2%
set ss=%time:~6,2%
set date=%yy%%mm%%dd%
set time=%hh%%mn%%ss%
set filename=%date%_%time%
set "Ymd=%date%_%time%"
mysqldump -uroot -p123456 database > E:/db/database_%Ymd%.sql
@echo on