mysql初始化windows_Windows下初始化mysql以及升级mysql

【初始化】

前提：有my.ini，且数据目录不能有对应文件：

mysqld --initialize

-------------------------------------------------------------------

会初始化建立系统库，并在error日志中打印‘临时密码’，需要修改。

-------------------------------------------------------------------

-------------------------------------------------------------------

【仅控制台方式启动】

To start the server, enter this command:

C:\> "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --console

-------------------------------------------------------------------

【修改root密码】

连接后：

GRANT ALL ON *.* TO 'root'@'localhost' IDENTIFIED BY '123456';

或者:

也可以使用下面的方式修改 root 帐号的密码

SET PASSWORD FOR 'root'@'localhost' = PASSWORD(123456);

FLUSH PRIVILEGES;

或者：

alter user 'root'@'localhost' identified by ’123456‘;

-------------------------------------------------------------------

【关闭】

You can stop the MySQL server by executing this command:

C:\> "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqladmin" -u root

shutdown

-------------------------------------------------------------------

【安装为系统服务】

Install the server as a service using this command:

C:\> "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --install

bin>mysqld.exe --install mysql5.6 --defaults-file=my.ini

-------------------------------------------------------------------

【升级】

对于windows下mysql升级(既有的mysql5.6已安装为系统服务)：

1，停止既有mysql服务

2，删除mysql既有服务

3，备份“datadir”和“innodb_data_home_dir”

4，新版本复制覆盖mysql的二进制文件(除数据文件和my.ini之外所有文件)

5，安装新服务

6，启动服务

-------------------------------------------------------------------

【检查版本】：

>mysqld --version

mysqld  Ver 5.7.21 for Win32 on AMD64 (MySQL Community Server (GPL))

-----------------------------------------------------------------------------------------------------------

【Windows下删除mysql服务】

Removing the service

> net stop mysql5.6

>mysqld --remove mysql5.6

-----------------------------------------------------------------------------------------------------------

之前的数据库文件版本是5.6+，后来升级到5.7+之后一直出现Table 'performance_schema.session_status' doesn't exist错误，解决办法

1. 进入Mysql的安装目录的bin文件夹

2. 打开cmd进入该目录执行mysql_upgrade -u root -p --force命令然后输入密码问题解决

*****

[官方文档:mysql_upgrade -u root -p]

mysql_upgrade examines all tables in all databases for incompatibilities with the current version of MySQL.

mysql_upgrade also upgrades the mysql system database so that you can take advantage of new privileges or capabilities.

-----------------------------------------------------------------------------------------------------------------------------