I can't go into phpmyadmin after I set the password of it

Problems with the Windows version of XAMPP, questions, comments, and anything related.

I can't go into phpmyadmin after I set the password of it

Postby dotKer » 07. March 2024 10:30

I installed xampp-windows-x64-8.1.10-0-VS16 about 2 years ago and used it for 2 years without serious problems.

2 weeks ago, Some problems happened in XAMPP.
As I failed in fixing it, I installed new one which is xampp-windows-x64-8.2.12-0-VS16 twice today.
Actually I installed XAMPP more than 10 times for the last 2 weeks.
Everytime I install it, I met a problem in changing password of phpmyadmin.

http://127.0.0.1/phpmyadmin/ is well open without any password because there is no password at first

(1) I click the button "user account"
(2) I click the button "changing password"
(3) I click the button "authentification" of "127.0.0.1" or "localhost"
(4) I enter my Password. "********" and confirm the password "*******"

After I change the password of phpmyadmin, I can't enter into phpmyadmin any more because it denies my approach.
if http://127.0.0.1/phpmyadmin/ shows login page, I think I can enter into phpmyadmin as I know the password which I made.
But I can't enter into login page of phpmyadmin or phpmyadmin because it simply denies my approach.


How can I enter into loaing page of phpmyadmin of phpmyadmin by setting password of it correclty?


if You click the link below, you can see the image of http://127.0.0.1/phpmyadmin how it denies my approach.
http://dot.kr/phpmyadmin.jpg
dotKer
 
Posts: 40
Joined: 09. November 2020 13:28
XAMPP version: 7.4.11
Operating System: windows

Re: I can't go into phpmyadmin after I set the password of i

Postby Nobbie » 07. March 2024 12:54

Where is this button "user account"?

Anyway, you have to apply your new password in config.inc.php in folder phpmyadmin. You will find the appropriate line, its self explaining.
Nobbie
 
Posts: 13176
Joined: 09. March 2008 13:04

Re: I can't go into phpmyadmin after I set the password of i

Postby dotKer » 08. March 2024 05:11

Anyway, you have to apply your new password in config.inc.php in folder phpmyadmin. You will find the appropriate line, its self explaining.

betterwoun said he couldn't.

In my case, I could and it works.


However, I can't go into loginpage, It goes to phpmyadmin directly without loging page.
Anyway, It is okay to log in without a login procedure since 127.0.0.1 means it is my computer only
dotKer
 
Posts: 40
Joined: 09. November 2020 13:28
XAMPP version: 7.4.11
Operating System: windows

Re: I can't go into phpmyadmin after I set the password of i

Postby Nobbie » 08. March 2024 12:05

If you want to have a login dialog for phpmyadmin, edit config.inc.php again and replace the value of auth_type (you will find the appropriate line) from 'config' to 'cookie '. This causes phpmyadmin to ignore the given values of user (i.e. 'root') and password from config.inc.php, you may delete these values if you like. Instead phpmyadmin prompts with a login dialog where you have to apply user and password.
Nobbie
 
Posts: 13176
Joined: 09. March 2008 13:04

Re: I can't go into phpmyadmin after I set the password of i

Postby dotKer » 09. March 2024 02:05

after I succeed in approaching with http://127.0.0.1/phpmyadmin.

I modify S:\xampp240306\apache\conf\extra\httpd-vhosts .config for my own use like the following
The following is the all of httpd-vhosts.config
# Virtual Hosts
#
# Required modules: mod_log_config

# If you want to maintain multiple domains/hostnames on your
# machine you can setup VirtualHost containers for them. Most configurations
# use only name-based virtual hosts so the server doesn't need to worry about
# IP addresses. This is indicated by the asterisks in the directives below.
#
# Please see the documentation at
# <URL:http://httpd.apache.org/docs/2.4/vhosts/>
# for further details before you try to setup virtual hosts.
#
# You may use the command line option '-S' to verify your virtual host
# configuration.

#
# Use name-based virtual hosting.
#
##NameVirtualHost *:80
#
# VirtualHost example:
# Almost any Apache directive may go into a VirtualHost container.
# The first VirtualHost section is used for all requests that do not
# match a ##ServerName or ##ServerAlias in any <VirtualHost> block.
#
##<VirtualHost *:80>
##ServerAdmin webmaster@dummy-host.example.com
##DocumentRoot "S:/xampp240306/htdocs/dummy-host.example.com"
##ServerName dummy-host.example.com
##ServerAlias http://www.dummy-host.example.com
##ErrorLog "logs/dummy-host.example.com-error.log"
##CustomLog "logs/dummy-host.example.com-access.log" common
##</VirtualHost>

##<VirtualHost *:80>
##ServerAdmin webmaster@dummy-host2.example.com
##DocumentRoot "S:/xampp240306/htdocs/dummy-host2.example.com"
##ServerName dummy-host2.example.com
##ErrorLog "logs/dummy-host2.example.com-error.log"
##CustomLog "logs/dummy-host2.example.com-access.log" common
##</VirtualHost>

<VirtualHost *:80>
DocumentRoot "F:/load"
ServerName load.dot.kr
<Directory "F:/load">
Require all granted
</Directory>
</VirtualHost>

<VirtualHost *:80>
DocumentRoot "F:/ld"
ServerName ld.dot.kr
<Directory "F:/ld">
Require all granted
</Directory>
</VirtualHost>

<VirtualHost *:80>
DocumentRoot "S:/xampp221121/htdocs"
ServerName dot.kr
ServerAlias *.dot.kr
<Directory "S:/xampp2201121/htdocs">
Require all granted
</Directory>
</VirtualHost>


Now http://127.0.0.1/phpmyadmin/ is well open.
However, when I open http://dot.kr/, it says like the following.
Forbidden
You don't have permission to access this resource.

Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12 Server at dot.kr Port 80


The XAMPP Control Panel says like the folloowing
오전 9:32:45 [main] Initializing Control Panel
오전 9:32:45 [main] Windows Version: Enterprise 64-bit
오전 9:32:45 [main] XAMPP Version: 8.2.12
오전 9:32:45 [main] Control Panel Version: 3.3.0 [ Compiled: Apr 6th 2021 ]
오전 9:32:45 [main] You are not running with administrator rights! This will work for
오전 9:32:45 [main] most application stuff but whenever you do something with services
오전 9:32:45 [main] there will be a security dialogue or things will break! So think
오전 9:32:45 [main] about running this application with administrator rights!
오전 9:32:45 [main] XAMPP Installation Directory: "s:\xampp240306\"
오전 9:32:45 [main] Checking for prerequisites
오전 9:32:45 [main] All prerequisites found
오전 9:32:45 [main] Initializing Modules
오전 9:32:45 [Apache] XAMPP Apache is already running on port 80
오전 9:32:45 [Apache] XAMPP Apache is already running on port 443
오전 9:32:45 [main] The FileZilla module is disabled
오전 9:32:45 [main] The Mercury module is disabled
오전 9:32:45 [main] The Tomcat module is disabled
오전 9:32:45 [main] Starting Check-Timer
오전 9:32:45 [main] Control Panel Ready



And the following is AMPP Control Panel > Apache > Logs > Apache(error.log)
Sat Mar 09 09:30:40.051476 2024] [ssl:warn] [pid 5596:tid 424] AH01909: http://www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat Mar 09 09:30:40.108632 2024] [core:warn] [pid 5596:tid 424] AH00098: pid file S:/xampp240306/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Sat Mar 09 09:30:40.111632 2024] [ssl:warn] [pid 5596:tid 424] AH01909: http://www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat Mar 09 09:30:40.587991 2024] [mpm_winnt:notice] [pid 5596:tid 424] AH00455: Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12 configured -- resuming normal operations
[Sat Mar 09 09:30:40.587991 2024] [mpm_winnt:notice] [pid 5596:tid 424] AH00456: Apache Lounge VS17 Server built: Oct 18 2023 13:03:18
[Sat Mar 09 09:30:40.587991 2024] [core:notice] [pid 5596:tid 424] AH00094: Command line: 's:\\xampp240306\\apache\\bin\\httpd.exe -d S:/xampp240306/apache'
[Sat Mar 09 09:30:40.594987 2024] [mpm_winnt:notice] [pid 5596:tid 424] AH00418: Parent: Created child process 2956
[Sat Mar 09 09:30:41.985921 2024] [ssl:warn] [pid 2956:tid 452] AH01909: http://www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat Mar 09 09:30:42.051613 2024] [ssl:warn] [pid 2956:tid 452] AH01909: http://www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat Mar 09 09:30:42.169546 2024] [mpm_winnt:notice] [pid 2956:tid 452] AH00354: Child: Starting 150 worker threads.
[Sat Mar 09 09:31:29.762082 2024] [authz_core:error] [pid 2956:tid 1852] [client 47.128.45.89:48806] AH01630: client denied by server configuration: S:/xampp221121/htdocs/via
[Sat Mar 09 09:32:04.076444 2024] [authz_core:error] [pid 2956:tid 1852] [client 47.128.119.223:58962] AH01630: client denied by server configuration: S:/xampp221121/htdocs/err
[Sat Mar 09 09:32:14.878264 2024] [authz_core:error] [pid 2956:tid 1852] [client 192.168.0.1:1791] AH01630: client denied by server configuration: S:/xampp221121/htdocs/myProject/
[Sat Mar 09 09:32:17.355847 2024] [authz_core:error] [pid 2956:tid 1852] [client 192.168.0.1:1791] AH01630: client denied by server configuration: S:/xampp221121/htdocs/myProject/
[Sat Mar 09 09:32:18.830013 2024] [authz_core:error] [pid 2956:tid 1852] [client 192.168.0.1:1791] AH01630: client denied by server configuration: S:/xampp221121/htdocs/myProject/
[Sat Mar 09 09:32:38.437782 2024] [authz_core:error] [pid 2956:tid 1804] [client 47.128.123.173:35386] AH01630: client denied by server configuration: S:/xampp221121/htdocs/


How can I make it open well not only http://127.0.0.1/phpmyadmin but also http://dot.kr/?
dotKer
 
Posts: 40
Joined: 09. November 2020 13:28
XAMPP version: 7.4.11
Operating System: windows

Re: I can't go into phpmyadmin after I set the password of i

Postby Nobbie » 09. March 2024 11:26

By correcting the wrong path in the Directory option:

<Directory "S:/xampp2201121/htdocs">


Thats a faulty path, remove the 0 between 22 and 1121. And please, be more carefull, i am not your remote debugger for dumb errors. There is also missing a VirtualHost for 127.0.0.1 and for localhost. If you want to use VirtualHosts, you have to define VirtualHosts for ALL servernames you want to use. You also might add an Alias for phpmyadmin in VirtualHost for dot.kr, the default Xampp installation uses an Alias for phpmyadmin (which is not installed under htdocs folder).

How long are you using Xampp? You are doing way too many beginner errors, dont you ever read documentation?
Nobbie
 
Posts: 13176
Joined: 09. March 2008 13:04


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 210 guests