登录数据库失败

Question

I found a login tutorial (forget the URL) and I am making it into a game via PHP and HTML, but for users to be able to play they have to login. When I visited my webpage myself I went to the login and used the database credentials I entered with PHPmyAdmin through my webhost, 6te.net. I made fake credentials as a sort of test: vSpark123 and ChloeGrace417. I got the following error message:

Database Login failed! Please make sure that the DB login credentials provided are correct mysqlerror:Access denied for user 'prasanth'@'localhost' (using password: YES) Database login failed!`.

When I went to the register.php in my site I got the same message.

With PHPmyAdmin it default set the database name to 619154 and I created the table inside with the name Login and the two columns are Username and Password. Is it something I'm doing wrong with PHPmyAdmin or something that needs to fixed in my PHP?

Answer 1

It seems you have entered wrong database username or password in database connection file.

If you have forgot your password you can use following query to update it.

UPDATE mysql.user SET Password=PASSWORD('newpassword') WHERE User='prasanth' AND Host='localhost';