MySql指令

启动Mysql

net start 服务名

登录Mysql

mysql [-h 主机名] -u用户名 -p密码 [-P端口号] [-D数据库名]

修改

ALTER TABLE

删除

DROP DATABASE

修改root密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';

删除服务

sc delete MySql

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '要改的密码';

代码注释

"-- "+注释语句 -- 注意y
/*注释语句*/