Cannot connect to Database server (mysql workbench)

The issue is likely due to socket authentication being enabled for the root user by default when no password is set, during the upgrade to ubuntu 16.04.

The solution is to revert back to native password authentication. You can do this by logging in to MySQL using socket authentication by doing:

sudo mysql -u root

Once logged in:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

which will revert back to the native (old default) password authentication.

Now use password as the password whenever required by MySQL.

Related Posts:

  1. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  2. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  3. String concatenation in MySQL
  4. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  5. Create a new database with MySQL Workbench
  6. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  7. MySQL error code: 1175 during UPDATE in MySQL Workbench
  8. Is there a naming convention for MySQL?
  9. How to unblock with mysqladmin flush hosts
  10. Access denied for user ‘root@localhost’ (using password:NO)
  11. MySQL error 2006: mysql server has gone away
  12. Which MySQL data type to use for storing boolean values
  13. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  14. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  15. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  16. Your password does not satisfy the current policy requirements
  17. what does “/index.php?admin/admin_dashboard” in my url mean
  18. How to join two tables by multiple columns in SQL?
  19. How to get size of mysql database?
  20. Selecting data from two different tables without using joins
  21. SQL – Update multiple records in one query
  22. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  23. mysqladmin: connect to server at ‘localhost’ failed
  24. mysql update multiple columns with same now()
  25. Usage of MySQL’s “IF EXISTS”
  26. How can I loop through all rows of a table? (MySQL)
  27. Generating a random & unique 8 character string using MySQL
  28. MySQL > Table doesn’t exist. But it does (or it should)
  29. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  30. mysql count duplicates
  31. MySQL Calculate Percentage
  32. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  33. Repair all tables in one go
  34. MySQL config file location – redhat linux server
  35. Failed building wheel for mysql-python
  36. Create boolean column in MySQL with false as default value?
  37. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  38. MySql – HAVING vs WHERE 
  39. How to stop mysqld
  40. mysql: connection refused when trying to connect to localhost using remote IP
  41. Is merge statement available in MySQL
  42. GROUP_CONCAT comma separator – MySQL
  43. Complex meta query with 3 keys
  44. Set page template for all pages?
  45. Optimize Multiple Taxonomy Term MySQL Query?
  46. WordPress MySQL & PHP Performance
  47. What specific database privileges does WordPress need?
  48. Using source control with WordPress
  49. My WordPress site always displays a cached version of its homepage
  50. Updating User Meta with SQL Query
  51. wpdb prepare syntax
  52. How to run this SQL query of wp_terms database
  53. Configure WordPress to connect to Mysql DB using SSH tunneling
  54. Proper way to work with wpdb to get user’s firstname
  55. How to change post format from Aside to Image for all posts?
  56. Inserting Hundreds of Thousands of Posts at Once
  57. wp_admin edit.php slow with lots of queries
  58. How to add and SQL query of posts only published
  59. Slow Mysql Queries
  60. can database and media folder be moved to a different drive?
  61. Find duplicate posts with same slug and author
  62. writing inner join in wpdb
  63. How to get data from WordPress site sql file
  64. Unknown collation when I import a dump from an existing site into a development database?
  65. PHP script can’t connect to Database on port 3307
  66. WordPress with php5-fpm and nginx
  67. How to split the a table in database?
  68. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  69. How to translate this mySQL query to $wpdb query
  70. $wpdb to insert html form information
  71. Proper usage of $wpdb->update()?
  72. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  73. Separate DB by yearly archive of WordPress
  74. What should a WordPress developer know about MySQL? [closed]
  75. Copyright: Get first and last date of post type
  76. Update MySQL query so that it functions again
  77. Query posts by custom taxonomy and sort by post_modified
  78. WordPress $wpdb get posts from category and sort by custom meta
  79. WordPress tables and aliases?
  80. What’s the sql for this condition?
  81. Copy usermeta value where ID matches in the same table
  82. Array Formation Issue
  83. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  84. WordPress $wpdb no result
  85. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  86. How to run SQL query from WordPress ‘WP Crontrol’ plugin
  87. edit_user_created_user hook – using to update Groups
  88. Mysql Error in querying form entries in Gravity Form plugin
  89. Improving performance of SQL sub-queries in WordPress
  90. Saving custom term value to the database in new table
  91. MySQL errors after a WordPress clone
  92. MYSQL Join on meta key value?
  93. Complicated MySQL Query
  94. problem with quotes on new post
  95. remove wordpress post links
  96. SQL get last entry of a specific gravity form
  97. mysqldump to a tar.gz
  98. Postgres equivalent to MySQL’s \G?
  99. How to check what port mysql is running on
  100. Where is my mysql log on OS X?

Leave a Comment