MySQL Forums
Forum List  »  Newbie

Re: Can't connect to DB after reboot from PHP
Posted by: bulent ozgul
Date: October 29, 2021 02:21PM

I've solved it,

first I have set the auth method to

default_authentication_plugin=mysql_native_password

in the my.ini file which is located under programdata (hidden folder)

after the I restart the MySQL service and created a new user with the command below

CREATE USER 'reporter'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

and of course grant the user

now after reboot the page is working.

Thanks for your effort

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.