On my local WAMP stack things are working perfectly.
When I upload the database on GOdaddy.com, this error shows up.
Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)
What does it mean?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
You are getting this error because the root account on your local machine doesn't have a password.
That's why you can login locally with
using password: NO
Probably your server on godaddy has a password set, or the root account disabled. You need to fix the credentials in your application (and probably use a login other than
MAMP seems to handle the root username differently than WAMP. I had to include the root password as 'root' in my PHP script, instead of leaving it blank, as such:
$link = mysqli_connect('localhost', 'root', 'root');