MySQL error with local computer access denied for user ' Root ' @ ' localhost ' (using Password:yes)

Source: Internet
Author: User

Locate the local MySQL-Installed bin directory:

Click Start-> Run, enter   services.msc
In the Open Service Manager to find MySQL and double-click, will pop out a property box, the "General" tab has an "execution path", from this path you can see its bin directory where.

cmd command into the MySQL bin directory:

MySQL error: The MySQL server is running with the--skip-grant-tables option so it cannot execute this
Solution:mysql> Flush Privilege below details how to give the user authorization.

Mysql> grant permissions 1, permissions 2, ... Permission n on the database name. Table name to User name @ user address identified by ' connection password ';

Permissions 1, Permissions 2, ... Permission N represents 14 permissions for SELECT, INSERT, UPDATE, delete, create, drop, index, alter, Grant, references, reload, shutdown, process, file, and so on.
When permissions 1, permissions 2, ... When permission n is replaced by all privileges or all, the user is given full permission.
When the database name is replaced by *. *, the user is given permission to manipulate all tables on all databases on the server.
The user address can be localhost, or it can be an IP address, a machine name, and a domain name. You can also use '% ' to indicate connections from any address.
' Connection password ' cannot be empty, otherwise the creation failed.

MySQL error with local computer access denied for user ' Root ' @ ' localhost ' (using Password:yes)

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: 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.