MySQL – Access denied for user [duplicate]

by

The error messages gives you a hint already. Use this grant statement:

GRANT ALL ON *.* TO 'servname_shb'@'localhost';

Or better, as @grantk points out in the comments, refine the access scope to only what is actually needed.

More Related Contents:

  1. Prevent creating duplicate entries in PHP
  2. Query database then email posts from where user is subbed to
  3. Laravel – only a zero is saved to the database
  4. I am seeing this error on submitting form Error: query was empty [closed]
  5. PHP Merging Row with same value (more than one column)
  6. Reference: What is a perfect code sample using the MySQL extension? [closed]
  7. Convert from MySQL datetime to another format with PHP
  8. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  9. Having issue with matching rows in the database using PDO
  10. How can I properly use a PDO object for a parameterized SELECT query
  11. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  12. Whether to use “SET NAMES”
  13. Escaping single quote in PHP when inserting into MySQL [duplicate]
  14. How can I get enum possible values in a MySQL database?
  15. Mechanisms for tracking DB schema changes [closed]
  16. Inserting data using mysqli
  17. Import file size limit in PHPMyAdmin
  18. MySQL diacritic insensitive search (spanish accents)
  19. Detect mysql update/insertion failure due to violated unique constraint
  20. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  21. How do I construct a cross database query in PHP?
  22. How to bind SQL variables in PHP?
  23. Getting a PHP PDO connection from a mysql_connect()?
  24. Having issue with matching rows in the database
  25. PHP – Secure member-only pages with a login system
  26. MySQL ORDER BY IN()
  27. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  28. mysql_connect VS mysql_pconnect [closed]
  29. Strange problem with the length of the field gotten from database [duplicate]
  30. mysql_fetch_array skipping first row

Leave a Comment