With WAMP configuration environment, want to use CMD connection mysql how to connect

Sign: Environment configured with Wamp want to use CMD to connect to MySQL how to even

Into the D-disk directory (CD cannot be cut, just enter the disk multibyte colon return, then CD to the directory)

MySQL database runs without MySQL and Performance_schema database when Wamp is installed.

There are several possible reasons for this:

Issue One: Uninstall is not uninstalled before clean

Issue two: No administrator privileges to enter
Issue three: When logged in, the password is empty, using anonymous login

Under Windows system

The process is as follows (forgetting the local root login password is also resolved in the following way):

In the [mysqld] field of My.ini under installation path, join: Skip-grant-tables

To restart the MySQL service, MySQL does not require a password to log into the database and then enter MySQL

Mysql>use mysql;mysql>update User Set Password=password (' New password ') WHERE user= ' root '; Mysql>flush privileges;

After running, finally remove the My.ini in the Skip-grant-tables, restart mysqld can be.

This article is from "Operation and maintenance record Mei Ling" blog, please be sure to keep this source http://meiling.blog.51cto.com/6220221/1617629

With WAMP configuration environment, want to use CMD connection mysql how to connect

With WAMP configuration environment, want to use CMD connection mysql how to connect