[client] port=3306 default-character-set=utf8 [mysqld] # 设置为MYSQL的安装目录 basedir=D:/dbs/mysql/mysql-5.6.25-winx64 # 设置为MYSQL的数据目录 datadir=D:/dbs/mysql/mysql-5.6.25-winx64/data port=3306 character_set_server=utf8 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
移除服务命令为：mysqld remove
net start mysql
c:>mysql –uroot
mysql>show databases;
mysql>use mysql;
mysql>UPDATE user SET password=PASSWORD("123456") WHERE user='root';
mysql>FLUSH PRIVILEGES; 【注意一定不要遗忘这句话，否则密码更改不能生效】
mysql>QUIT
