Skip to content
Fix Code Error

Access denied for user ‘[email protected]’ (using password:NO)

March 13, 2021 by Code Error
Posted By: Anonymous

I’m new to MySQL, I’m trying to run WordPress in my Windows desktop and it needs MySQL.

I install everything with Web Platform Installer which is provided by Microsoft. I never set a root password for MySQL and in the final step of installing WordPress, it asks for a MySQL server password.

What is the default password for root (if there is one) and how to change it?

I tried:

mysql -u root password '123'

But it shows me:

Access denied for user '[email protected]' (using password:NO)

After this I try:

mysql -u root -p

However, it asks for a password which I don’t have.


Update: as Bozho suggested, I did the following:

  1. I stopped the MySQL Service from Windows services
  2. Opened CMD
  3. Changed the location to c:program filesmysqlbin
  4. Executed the command below

    mysqld --defaults-file="C:\program files\mysql\mysql server 5.1\my.ini" --init-files=C:\root.txt

  5. The command ran with a warning about character set which I mentioned below

  6. I start the MySQL service from Windows services
  7. I write in the command line

    mysql -u root -p
    EnterPassword: 123 // 123 was the password

  8. The command line shows the following error

    Access denied for user '[email protected]' (using password:**YES**)

How do I solve this? I’m waiting to hear from you.

Solution

You can reset your root password. Have in mind that it is not advisable to use root without password.

Answered By: Anonymous

Related Articles

  • SQLException: No suitable Driver Found for…
  • Problems Installing CRA & NextJS from NPM…
  • When I'm testing a web app by JUnit and Mockito I…
  • Error 'Map', but got one of type 'Null' flutter web…
  • VUE Error when run test unit
  • How can I find the product GUID of an installed MSI setup?
  • Ukkonen's suffix tree algorithm in plain English
  • How to solve Internal Server Error in Next.Js?
  • Fastest way to iterate over all the chars in a String
  • Using enums in a spring entity
  • Polymer conflict with moment.js?
  • Android Studio 4.2.1 NullPointer Exception on startup
  • How to remove MySQL completely with config and…
  • Get operating system info
  • Error: the entity type requires a primary key
  • Making macOS Installer Packages which are Developer ID ready
  • How to prevent scrolling the whole page?
  • JUNIT @ParameterizedTest , Parameter resolution Exception
  • ClassNotFoundException thrown
  • How to install Intellij IDEA on Ubuntu?
  • How to parse JSON file with Spring
  • Webpack: Unable to find module with ID: main --…
  • Mock MQRFH2 header in JUnit Testing Error [MQRFH2…
  • How to use html template with vue.js
  • Chocolatey Install Arguments Syntax
  • How can I exclude all "permission denied" messages…
  • Runing vue/cli app under docker simple index.html is opened
  • I want to create a SQLite database like in the…
  • Detect if Visual C++ Redistributable for Visual…
  • How to update Python?
  • How to filter a RecyclerView with a SearchView
  • Regex on htaccess file gives INTERNAL REDIRECT error
  • What are the undocumented features and limitations…
  • Error creating bean with name 'entityManagerFactory'…
  • Vaadin Spring Boot - There was an exception while…
  • How do SO_REUSEADDR and SO_REUSEPORT differ?
  • How can I set hours and minutes of date with oracle sql?
  • Can Windows Containers be hosted on linux?
  • How do I install Java on Mac OSX allowing version switching?
  • Visual Studio debugging/loading very slow
  • The definitive guide to form-based website authentication
  • Changing Icon Color behind ListTile in an…
  • Set up adb on Mac OS X
  • How to create an installer for a .net Windows…
  • Multipart File Upload Using Spring Rest Template +…
  • How to use Python's "easy_install" on Windows ...…
  • Change private static final field using Java reflection
  • Unhandled Promise Rejection when trying to call…
  • Xamarin 2.0 vs Appcelerator Titanium vs PhoneGap
  • Installation of VB6 on Windows 7 / 8 / 10
  • How do I use 3DES encryption/decryption in Java?
  • How to keep link hover animation after clicking?
  • MySQL ERROR 1045 (28000): Access denied for user…
  • ERROR 1698 (28000): Access denied for user…
  • Install Visual Studio 2013 on Windows 7
  • How I can resolve exception…
  • How do I install SciPy on 64 bit Windows?
  • OperationalError, no such column. Django
  • What is the difference between Visual Studio Express…
  • npm install -g less does not work: EACCES: permission denied
  • Access denied for user 'root'@'localhost' while…
  • Design DFA accepting binary strings divisible by a…
  • How to set root password to null
  • Auto-fit TextView for Android
  • How Spring Security Filter Chain works
  • ComboBox.SelectedItem giving Null value
  • How do I connect to this localhost from another…
  • Vue - How to make active dynamically based on…
  • Vuetify stepper alert message when blanks not filled
  • Should MySQL have its timezone set to UTC?
  • How to build next.js production?
  • Moving away from bower in 2.15.1 ember-cli version
  • How to add fade animation for this tab
  • What does do?
  • create a trusted self-signed SSL cert for localhost…
  • How is TeamViewer so fast?
  • Why am I getting a "401 Unauthorized" error in Maven?
  • Start redis-server with config file
  • Logging best practices
  • flutter - add network images in a pdf while creating…
  • Error creating bean with name
  • Keycloak/Wildfly How to configure all console logs…
  • Use Combine to route SwiftUI Views
  • Convert a PHP script into a stand-alone windows executable
  • wp-admin shows blank page, how to fix it?
  • Relative URLs in WordPress
  • Instance member can't be accessed using static access
  • SecurityException: Permission denied (missing…
  • discord.ext.commands.errors.CommandInvokeError:…
  • How should I deal with "package '✘✘✘' is not…
  • Use SQL Server Management Studio to connect remotely…
  • What are the correct version numbers for C#?
  • Python: Float to Decimal conversion and subsequent…
  • Can't install laravel installer via composer
  • Generate .pem file used to set up Apple Push Notifications
  • Is there a float input type in HTML5?
  • Changing PowerShell's default output encoding to UTF-8
  • How to force Docker for a clean build of an image
  • Postman gives 401 Unauthorized - Spring Boot & MYSQL
  • How to install PyQt5 on Windows?

Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.

Post navigation

Previous Post:

Create a Date with a set timezone without using a string representation

Next Post:

How do I break a string in YAML over multiple lines?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

.net ajax android angular arrays aurelia backbone.js bash c++ css dataframe ember-data ember.js excel git html ios java javascript jquery json laravel linux list mysql next.js node.js pandas php polymer polymer-1.0 python python-3.x r reactjs regex sql sql-server string svelte typescript vue-component vue.js vuejs2 vuetify.js

  • you shouldn’t need to use z-index
  • No column in target database, but getting “The schema update is terminating because data loss might occur”
  • Angular – expected call-signature: ‘changePassword’ to have a typedeftslint(typedef)
  • trying to implement NativeAdFactory imports deprecated method by default in flutter java project
  • What should I use to get an attribute out of my foreign table in Laravel?
© 2022 Fix Code Error