mysqladmin: connect to server at ‘localhost’ failed

Short version: If your MySQL user root needs a password to connect, it might be a good idea to have mysqladmin provide that password 😉

Longer version: Your MySQL user root seems to need a password to connect

setting the mysql root password new

But mysqladmin tries to connect without a password

‘Access denied for user ‘root’@’localhost’ (using password: NO)’

And mysqladmin does that because you’re not telling it otherwise 😉

mysqladmin, like other MySQL-related command line tools (mysql, mysqldump, mysqlshow etc.), offers options to provide such access data.

  • h: Which host to connect to. If not provided, localhost is assumed
  • u: Which user to connect as. If not provided, root is assumed
  • p: Which password to use. If not provided, no password is used

You should be able to use something like

mysqladmin -uroot -pmysupersecretpassword proc

(be aware that there’s no space between the options and their values). You can also have MySQL ask you for the password like

mysqladmin -uroot -p proc

With that, MySQL should give you a prompt where you can enter your password.

Related Posts:

  1. MySQL root password change
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  4. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  5. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  6. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  7. MySQL server startup error ‘The server quit without updating PID file’
  8. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  9. SQL – Update multiple records in one query
  10. When to use SELECT … FOR UPDATE?
  11. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  12. Database sharding vs partitioning
  13. how to overcome ERROR 1045 (28000): Access denied for user ‘ODBC’@’localhost’ (using password: NO) permanently
  14. How to export a mysql database using Command Prompt?
  15. SQL ZOO List each continent and the name of the country that comes first alphabetically
  16. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  17. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  18. How to install Python MySQLdb module using pip?
  19. Access denied for user ‘root’@’localhost’ (using password: YES) after new installation on Ubuntu
  20. How to grant remote access permissions to mysql server for user?
  21. Dump all tables in CSV format using ‘mysqldump’
  22. Is there a Profiler equivalent for MySql?
  23. How to do a batch insert in MySQL
  24. How to use greater than operator with date?
  25. If variable equals value php [duplicate]
  26. MySQL: Cloning a MySQL database on the same MySql instance
  27. mysqldump data only
  28. PHP date() format when inserting into datetime in MySQL
  29. How to replace the domain name in a WordPress database?
  30. WordPress mysqli and PDO
  31. Alternative to mysql_real_escape_string
  32. Increment value (value = value+1) of $wpdb->update
  33. How can I debug my database connection for unit testing?
  34. Extending the database
  35. SQL query not working in alphabetical post title/content search
  36. Same option_id=0 for 2 options in wp_options?
  37. How to let a user choose an authors and save it to the database?
  38. How to remove ‘GROUP BY’ from SQL query produced from get_posts?
  39. MySQL LIKE not working
  40. Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
  41. Join new table with SQL query
  42. WordPress installation on valet php 8 (PHP Fatal error: Uncaught mysqli_sql_exception Table ‘wp_options’ doesn’t exist in wp-includes/wp-db.php:2056)
  43. MySQL crashed because of the large number of requests
  44. Why doesn’t this code add a table to my database?
  45. SQL database export-import
  46. Modify MySQL Query Based on Dropdown Menu
  47. Can Someone Help Me Fix This WordPress Missing Argument Error?
  48. How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
  49. Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
  50. SQL Database, repeated tables?
  51. Backing up and restoring multiple sites efficiently
  52. Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
  53. Alter wp_post table vs. post_meta performance/speed
  54. Code to remove authors with no posts connected to them
  55. SQL Query in WordPress – Getting Impossible WHERE error
  56. Are these WordPress tables safe to add indexes to?
  57. WordPress create database not working
  58. Import CSV to MySQL, with custom registration field information
  59. database optimization and server errors
  60. Locally restoring a ManageWP full site backup
  61. Update Custom Post Type Taxonomies with SQL
  62. Setting up WordPress Locally on WAMP for a new site (with one already)
  63. Calling mysql_query() on another database, assumes WordPress using that database
  64. WordPress VIP realpath Alternative?
  65. querying user bookmarks from a large number of bookmarks
  66. Pull post name from value of a specific meta key
  67. PHP variables in mysql query
  68. How to fix the amount of comments displayed for each post?
  69. How do I echo all users’ display_name and their meta_value who have a certain meta_key?
  70. How to install WordPress from hosting service with mysql database from Compute Engine GCP?
  71. How to simulate web traffic to test performance of a website
  72. SQL query to change custom field in WordPress database
  73. SQL. Select category descendants
  74. What is the MYSQL Query to bulk update the canonical URL of specific categories of posts in WordPress?
  75. MySQL Actibity without any active visitors via Google Analytics
  76. How to configure WordPress Database for CentOS 7
  77. Why is local wordpress install calling live site executions?
  78. Add row to SQL array
  79. Display MySQL as part of a Page
  80. SELECT statement wrong?
  81. Migration of wordpress database from mariadb 10.0.20 to 5.5.50
  82. Use custom query if main search query returns zero results in wordpress
  83. WP Meta Query – mixed AND / OR query doesn’t work
  84. Can I use mysql queries to replace query_posts()?
  85. How to Import Multiple Values in custom field
  86. Second completely independent and disposable WordPress installation in subdirectory?
  87. get_results suddenly not working on a single table
  88. Internal error (500) on local & Fatal error on live when trying to access post type edit screen
  89. Query sql for truncate post_content in wp_posts table
  90. How WP decide to show or not to show in admin panel the pop-up window with hint? Need a fix
  91. Foreach only outputs if id is 0
  92. SQL – Pull products of particular category from a remote WordPress woocommerce db
  93. Efficiently loop over huge number of posts
  94. Using queries in and i see 7000+queries?
  95. “Error 1064” when importing msql database after updating wordpress version to 4.2.1
  96. Need SQL query to find&replace image URL
  97. remove wordpress post links
  98. SQL get last entry of a specific gravity form
  99. mysqldump to a tar.gz
  100. Where is my mysql log on OS X?

Leave a Comment