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

Source: Internet
Author: User

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5A/26/wKioL1T4AsHxdzSkAAEpjSgc_tY555.jpg "title=" 1.png " alt= "Wkiol1t4ashxdzskaaepjsgc_ty555.jpg"/>


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

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5A/2A/wKiom1T4A2ugJ0XyAAJF1qeVv1g698.jpg "title=" 2.png " alt= "Wkiom1t4a2ugj0xyaajf1qevv1g698.jpg"/>

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

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5A/2B/wKiom1T4DlrxuR-GAAIxyTPDLoM396.jpg "title=" 3.png " alt= "Wkiom1t4dlrxur-gaaixytpdlom396.jpg"/>

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.