mysql user plugin_【MySQL】Win7 mysql.plugin mysql.user

//

// unpack the zip file.

// Warning & Error

//

Can‘t open the mysql.plugin table. Please run mysql_upgrade to create it.For more information, see Help and Support Center at http://www.mysql.com.

Gtid table is not ready to be used. Table ‘mysql.gtid_executed‘ cannot be opened.For more information, see Help and Support Center at http://www.mysql.com.

Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private keyFor more information, see Help and Support Center at http://www.mysql.com.

Failed to open optimizer cost constant tables

For more information, see Help and Support Center at http://www.mysql.com.

Fatal error: Can‘t open and lock privilege tables: Table ‘mysql.user‘ doesn‘t existFor more information, see Help and Support Center at http://www.mysql.com.

------>

F:\mysql\bin>mysqld --initialize

F:\mysql\bin>mysqld install MySQL --defaults-file="f:\mysql\my.ini"

Service successfully installed.

F:\mysql\bin>net start mysql

MySQL 服务正在启动 .

MySQL 服务已经启动成功。

F:\mysql\bin>

///

/// set passwd

///

1131  You are using MySQL as an anonymous user and anonymous users are not allowed to change passwordsFor more information, see Help and Support Center at http://www.mysql.com.

------> deployed the windows installer

原文：http://huangchao.blog.51cto.com/10446378/1717730