1、下载
https://dev.mysql.com/downloads/mysql/
2、解压缩
3、创建/修改配置文件
在MySQL安装目录下,新建my.ini,内容如下参考
[mysql] # 设置mysql客户端默认字符集 default-character-set=utf8 [mysqld] #设置3306端口 port=3306 # 设置mysql的安装目录 basedir=D:\MySQL # 设置mysql数据库的数据的存放目录 datadir=D:\MySQL\data # 允许最大连接数 max_connections=200 # 服务端使用的字符集默认为8比特编码的latin1字符集 character-set-server=utf8 # 创建新表时将使用的默认存储引擎 default-storage-engine=INNODB
4、初始化
D:\MySQL\bin>mysqld --initialize
5、安装服务
D:\MySQL\bin>mysqld install
6、启动服务
D:\MySQL\bin>net start mysql
mysql -u root -p
MySQL忘记了root密码,使用skip-grant-tables方式启动后,用set password的方式修改root密码时遇到错误
ERROR 1290 (HY000)
1.以skip-grant-tables方式启动mysql
C:\Users\>mysqld --skip-grant-tables
130411 10:09:30 [Warning] '--default-character-set' is deprecated and will be removed in a future re
lease. Please use '--character-set-server' instead.
130411 10:09:30 [Warning] Changed limits: max_open_files: 2048 max_connections: 700 table_cache: 6
69
2. 用root用户登录,不用输入密码
C:\Users\>mysql -uroot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.54-community-log MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
3.用set password 方式修改root密码遇到错误ERROR 1290 (HY000)
mysql> set password for root@'localhost'=PASSWORD('12345');
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot exe
cute this statement
4. 用update方式修改root密码正常
mysql> update mysql.user set password=password('12345') where user='root' and host='localhost';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
5.刷新权限
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
看来以skip-grant-tables方式启动mysql后,不能用set password的方式修改root密码