ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)

Note: For MySQL 5.7+ please see answer from @Lahiru to this question. That contains more current information.

For MySQL < 5.7:

The default root password is blank (i.e. empty string) not root. So you can just login as:

mysql -u root

You should obviously change your root password after installation

mysqladmin -u root password [newpassword]

In most cases you should also set up individual user accounts before working extensively with the DB as well.

Related Posts:

  1. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  2. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  3. How to restart remote MySQL server running on Ubuntu linux?
  4. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  5. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  6. MySQL config file location – redhat linux server
  7. How to configure WordPress Database for CentOS 7
  8. 403 Forbidden home on localhost with nginx server
  9. What is the debian-sys-maint MySQL user (and more)?
  10. Undefined function mysql_connect()
  11. Cannot add or update a child row: a foreign key constraint fails
  12. How to make MySQL table primary key auto increment with some prefix
  13. sql query with multiple where statements
  14. Cannot delete or update a parent row: a foreign key constraint fails
  15. Syntax error due to using a reserved word as a table or column name in MySQL
  16. MySQL root password change
  17. Installation of MySQL for Visual Studio 1.2.8 failed
  18. How do I import an SQL file using the command line in MySQL?
  19. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  20. Ubuntu: OpenJDK 8 – Unable to locate package
  21. Select from multiple tables without a join?
  22. SQL Query Where Field DOES NOT Contain $x
  23. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  24. Mysql command not found in OS X 10.7
  25. MySQL – UPDATE query based on SELECT Query
  26. “Unable to find remote helper for ‘https'” during git clone
  27. grabbing first row in a mysql query only
  28. mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
  29. Order a MySQL table by two columns
  30. MySQL AS keyword
  31. Should I use the datetime or timestamp data type in MySQL?
  32. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  33. How do I change the data type for a column in MySQL?
  34. Generating a random & unique 8 character string using MySQL
  35. MySQL > Table doesn’t exist. But it does (or it should)
  36. Unknown Column In Where Clause
  37. Cannot connect to Database server (mysql workbench)
  38. mysqld: Can’t change dir to data. Server doesn’t start
  39. How to solve “Error: MySQL shutdown unexpectedly”?
  40. Can you do a For Each Row loop using MySQL?
  41. Drop all databases in MySQL
  42. How to properly create composite primary keys – MYSQL
  43. MySQL – count total number of rows in php
  44. How to get the count of each distinct value in a column?
  45. Data is not constantly loading from custom wordpress table
  46. How to run WordPress across 2 VMs for high availability
  47. Mysqldump add drop table?
  48. How to disable `SQL_CALC_FOUND_ROWS` [duplicate]
  49. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  50. #1115 – Unknown character set: ‘utf8mb4’
  51. WordPress Deadlock Error
  52. How to do a MySQL dump from production site without using a search and replace script for local development?
  53. How to bulk edit canonical url’s in SQL?
  54. Concurrent / simultaneous MySQL connections
  55. How to check for empty and not a failure
  56. How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
  57. Keeping database within limits, please help!
  58. Best settings for MySQL to speed up site? [closed]
  59. HTML Entities in Post Title
  60. Can’t find my wordpress DB in phpmyadmin
  61. Deprecated: mysql_connect():
  62. $wpdb select all meta for each post
  63. Calculate average crossing post categories
  64. Replacing link URL ending strings via MySQL
  65. Many slow queries post_type = ‘attachment’;
  66. SQL command to convert all tags in lowercase?
  67. Problem with admin login after deployment
  68. Find out how many times the user has logged in
  69. Is it possible to create a WordPress table using array and loop?
  70. Can’t run database query
  71. How to stop $wpdb from prepending database name
  72. Match tag names with form titles
  73. Error missing MySQL extension
  74. Getting Error Trying to Create Table
  75. Best approach for a custom database filling in WP custom post types
  76. Why doesn’t custom mysql query return results? Is syntax correct?
  77. Insert two row in wordpress database
  78. Way to extract wordpress data from folder backup
  79. SQL statement using placeholder is not returning results
  80. How to Bulk find and replace MySQL for post image url
  81. Wpdb query with dynamic table name
  82. Regular XML-RPC timeouts
  83. update multiple rows in mysqli table base on two values
  84. How can I verify WordPress nonce from the following code?
  85. How to write in MySQL more characters in user_nicename
  86. $wpdb->get_var not returning count
  87. Custom user query – orderby meta_key (that may not exist)
  88. How to get Attachments(image) with specific width\height ratio
  89. What is the cron doing?
  90. Apache Redirect based on WordPress permissions
  91. SQL error on restoring database
  92. MySQL database gives blank page (white screen of death)
  93. Datatabase error: Commands out of sync
  94. why is $wpdb->update() causing a DB error from within wp_set_password()
  95. Global MySQL replacing of text patterns/matches
  96. Need SQL query to find&replace image URL
  97. InnoDB: Error: log file ./ib_logfile0 is of different size
  98. Postgres equivalent to MySQL’s \G?
  99. Heartbleed: how to reliably and portably check the OpenSSL version?
  100. How to check what port mysql is running on

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)