Change the value of the timezone depends on your location or preference.Find date.timezone using CTRL + F in your text editor.In the Apache service config button or select box, click php.ini.Mysql > GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY 'yourpassword' WITH GRANT OPTION ģ.To save changes using the execute FLUSH PRIVILEGES.īy default PHP timezone is date.timezone=Europe/Berlin, to change timezone, follow the steps below. Run the following query to grant all privilage of your user in any valid host.Go to phpMyadmin or CLI login using root account or any SUPER USER.To fix the following problem, this is the solution. Even adding new connection to your database management tool like HeidiSQL and Navicat is not working. It means that you are not allowed to connect to the MySQL database over the network, but you can use it in your host PC or server and use with your project. Grant All Privileges To MySQL User in Any Hostīy default root account are not accessible outside your localhost And change the auth_type, user, password, and AllowNoPassword Authentication type and info.In the Apache service config button or select box, click.The go back to the XAMPP control panel and restart the Apache service.Go to the following line and change the Require local by Require all granted.
In the Apache service config button or select box, click nf.The following are the steps to fix the problem: If you think this is a server error, please contact the webmaster.Īpache/2.4.37 (Win32) OpenSSL/1.1.1a PHP/7.3.1 This setting can be configured in the file "nf". In my case I have an allocated drive for all my development applications and I never put it in drive C.īy default you will get the following error when accessing the phpMyadmin over network in during fresh installation.Īccess to the requested directory is only available from the local network. Decide where your XAMPP folder will be created.
0 kommentar(er)
