“Connect failed: Access denied for user ‘root’@’localhost’ (using password: YES)” from php function [duplicate]

by

I solved in this way:
I logged in with root username

mysql -u root -p -h localhost

I created a new user with

CREATE USER 'francesco'@'localhost' IDENTIFIED BY 'some_pass';

then I created the database

CREATE DATABASE shop;

I granted privileges for new user for this database

GRANT ALL PRIVILEGES ON shop.* TO 'francesco'@'localhost';

Then I logged out root and logged in new user

quit;
mysql -u francesco -p -h localhost

I rebuilt my database using a script

source shop.sql;

And that’s it.. Now from php works without problems with the call

 $conn = new mysqli("localhost", "francesco", "some_pass", "shop");

Thanks to all for your time 🙂

More Related Contents:

  1. PHP PDO and Mysql [closed]
  2. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  3. The requested URL was not found on this server.
  4. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  5. How to create a secure mysql prepared statement in php?
  6. strange character encoding of stored data , old script is showing them fine new one doesn’t
  7. SQL injections in ADOdb and general website security
  8. PHP PDO prepared statement — MySQL LIKE query
  9. How can I use mysqli_fetch_array() twice?
  10. Best practice multi language website
  11. Prevent InnoDB auto increment ON DUPLICATE KEY
  12. How to know if MySQLnd is the active driver?
  13. using nulls in a mysqli prepared statement
  14. How to solve time out in phpmyadmin?
  15. MySQL: Add sequence column based on another field
  16. How to run the PHP script at scheduled time
  17. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  18. How to handle error for duplicate entries?
  19. How to handle PDO exceptions [duplicate]
  20. MySql PHP select count of distinct values from comma separated data (tags)
  21. mysql_insert_id() returns 0
  22. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  23. Change name of Laravel’s created_at and updated_at
  24. How do I get database column names in Laravel?
  25. PDO and MySQL Fulltext searches
  26. How to avoid “Using temporary” in many-to-many queries?
  27. Difference between mysql_fetch_array and mysql_fetch_row?
  28. mysql_fetch_array skipping first row
  29. 500 Internal Server Error?
  30. Aggregated query without GROUP BY

Leave a Comment