<1>CMD登陆MSQL
有密码登录:
D:\Program Files (x86)\MySQL\MySQL Server 5.0>mysql -hlocalhost -uroot -p888888
无密码登录:
mysql -hlocalhost -uroot
port:3306
<2>启动和关闭
启动mysql服务
net start mysql
关闭mysql服务
net stop mysql
<3>免密登录:
skip-grant-tables
<3>刷新权限:
flush privileges;
<4>修改字符集:
alter table user change hobby hobby varchar(255) character set utf8;
<5>MySql操作工具:
MySql WorkBench
SQLyog
DbVisual