
- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
Resolve error 1045 (28000) access denied for user 'root'@'localhost' (using password: YES)?
To fix this error, you need to specify the -p option for password.
The syntax is as follows
mysql -uyourUserName -p
Let us implement it.
First, we need to open CMD using Windows+R shortcut keys. The snapshot is as follows
Type CMD and press OK button. You will get a command prompt.
The snapshot is as follows
Now reach the MySQL bin directory.
The snapshot is as follows
Now use the syntax discussed in the beginning.
The command is as follows
- Related Articles
- ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'localhost'?
- Error: Permission denied to access property ‘target’ in JavaScript
- MySQL new user access denied even after giving privileges?
- Solve ERROR 1396 (HY000): Operation DROP USER failed for 'user'@'localhost' in MySql?
- Resolve java.sql.SQLException: No suitable driver found for localhost test?
- Reset the root user password on rhel7 xcentos7 x
- Rename Root @ localhost username in MySQL?
- Redirect Output to location with Permission denied Error?
- How can we change MySQL user password by using the SET PASSWORD statement?
- How can we change MySQL user password by using the ALTER USER statement?
- HTML5 geolocation 'permission denied' error in Mobile Safari
- How to change the password in MongoDB for existing user?
- How to change the local user account password using PowerShell?
- Set special characters for password while creating a new MySQL user?
- Resolve MySQL ERROR 1064 (42000): You have an error in your syntax?

Advertisements