Apache Friends Support Forum

Hallo,

ich hab seit Jahren wieder mal Xampp neu heruntergeladen..

Beim Start vom Controlpanel kam die Fehlermeldung vowegen Port 3306 ist belegt.
Hab den Port dann auf 3307 umgestellt und Mysql ist gestartet.
Dann Apache gestartet und Localhost aufgerufen, alles kein Problem.

Erst beim anklicken von phpmyadmin kamen die Fehlermeldungen..

- MySQL meldet: Dokumentation
Die Verbindung konnte aufgrund von ungültigen Einstellungen nicht hergestellt werden.

- mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)

- Verbindung für den controluser, wie er in Ihrer Konfiguration angegeben ist, ist fehlgeschlagen.

- phpMyAdmin hat versucht eine Verbindung zum MySQL-Server aufzubauen und die Verbindung wurde zurückgewiesen. Sie sollten Ihre Einstellungen für Host, Benutzername und Passwort in Ihrer config.inc.php überprüfen und sich vergewissern, dass diese den Informationen, die Sie vom Administrator erhalten haben, entsprechen.
-mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)

So, nun steh ich an und weis nicht weiter, zumal von Server, Mysql etc. wenig bis gar keine Ahnung habe.
Ich weis nur früher war es einfacher, zumindest hatte ich diese Fehler nicht und ich musste auch nichts ein oder umstellen...

lg
PaleMoon

I have installed xampp-windows-x64-8.2.12-0-VS16 today because my old one which is xampp-windows-x64-8.1.10-0-VS16 has some problems.

Today I installed XAMPP seveal times today because Something wrong, I think, in my changing password.

http://127.0.0.1/phpmyadmin/ is well open before I change the password of mySQL through phpMyAdmin.
As I have changed the password using Change password button in phpMyAdmin. it says like the following(blue color font is translation from my mother language to English).

오류 error
MySQL 메시지message : 문서documents

연결할 수 없습니다Can't connect: 잘못된 설정wrong configuration.

mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)

phpMyAdmin이 MySQL 서버에 접속하려 했으나 실패했습니다phpMyAdmin tried to connect MySQL server, but failed.
서버가 연결을 거부했습니다Server rejected the connection. 당신의 설정의 호스트, ID, 패스워드가 맞게 입력됐는지, 또는 MySQL 서버의 관리자가 제공해 준 정보를 맞게 입력했는지 확인하세요Confirm the host, ID, password are all correct with your config or server manager given.

when I open http://127.0.0.1/phpmyadmin/, I like to see the login page instead of the error message in the quote above.

How can I see the login page?

I can install XAMPP again, then how can I change mySQL Password correctly?

Hi,
I installed XAMPP on macOS Sonoma 14.2.1. At this stage I can access on the web /localhost/myphpadmin showing the root user has blank password. Using command line, I created a database, piwigo. Then I used /localhost/myphpadmin to change the password to the database. Then, I loaded mysql database from my backup. I placed the piwigo server on htdocs (server and database has the same name). After some write permission corrections, my piwigo server (with all my photo albums) is working. Now I want to go in /localhost/myphpadmin but it gives me error

Code: Select all

Error
MySQL said: Documentation

Cannot connect: invalid settings.
 mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
 Connection for controluser as defined in your configuration failed.
 mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)
 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

Since the macOS manager-osx does not have features of the windows control panel, I do not know how to correct this.

Your help is much appreciated.

Edit, If I can change the password back to blank, maybe I can access /localhost/myphpadmin. But I searched and the methods used is on the control panel which manager-osx does not have. I cannot find any command line to change XAMMP mysql password.

edit2. I found the command and use this to alter the root password

Code: Select all

/Applications/XAMPP/bin/mysql --user=root --password -e "Alter User 'root'@'localhost' IDENTIFIED BY '""'"

Now I cannot access my database, since I have changed the password to "". What can I do in phpmyadmin to change the password back but also allow me to access /localhost/phpmyadmin?

Nobbie wrote:Ok, there is LISTEN 4434.

Look into xampp-control.ini and see if you also changed "ApacheSSL" to 4434. If its still set to 443, change it to 4434 and restart Xampp Control Dialog. Then try again.

But last not least, i think you have multiple Apaches on your Server and starting the "wrong" one.

Sorry for the late reply.

So i did the following.
STOP THE APACHE EN MYSQL services
current xampp folder in E:\xampp i have renamed the name Apache and php to -old both.
Then i extract the version i want to use, and copied the Apache and php in to the e:\xampp folder
then in php folder php.ini file i have changed the \xampp all of them to e:\xampp\xx\xx
then ApacheSSL en the xampp apache.control.ini file changed it to 4434

Code: Select all

[Common]
Edition=
Editor=C:\Program Files\Notepad++\notepad++.exe
Browser=C:\Program Files\Google\Chrome\Application\chrome.exe
Debug=0
Debuglevel=0
TomcatVisible=0
Language=en
Minimized=0

[EnableModules]
Apache=1
MySQL=1
FileZilla=0
Mercury=0
Tomcat=1

[LogSettings]
Font=Arial
FontSize=10

[WindowSettings]
Left=138
Top=31
Width=1146
Height=495

[Autostart]
Apache=0
MySQL=0
FileZilla=0
Mercury=0
Tomcat=0

[Checks]
CheckRuntimes=1
CheckDefaultPorts=1

[ModuleNames]
Apache=Apache
MySQL=MySQL
FileZilla=FileZilla
Mercury=Mercury
Tomcat=Tomcat

[EnableServices]
Apache=1
MySQL=1
FileZilla=1
Tomcat=1

[BinaryNames]
Apache=httpd.exe
MySQL=mysqld.exe
FileZilla=filezillaserver.exe
FileZillaAdmin=filezilla server interface.exe
Mercury=mercury.exe
Tomcat=tomcat8.exe

[ServiceNames]
Apache=Apache2.4
MySQL=mysql
FileZilla=FileZillaServer
Tomcat=Tomcat

[ServicePorts]
Apache=80
ApacheSSL=4434
MySQL=3306
FileZilla=21
FileZillaAdmin=14147
Mercury1=25
Mercury2=79
Mercury3=105
Mercury4=106
Mercury5=110
Mercury6=143
Mercury7=2224
TomcatHTTP=8080
TomcatAJP=8009
Tomcat=8005

[UserConfigs]
Apache=
MySQL=
FileZilla=
Mercury=
Tomcat=

[UserLogs]
Apache=
MySQL=
FileZilla=
Mercury=
Tomcat=



httpd

Code: Select all

#
# This is the main Apache HTTP server configuration file.  It contains the
# configuration directives that give the server its instructions.
# See <URL:http://httpd.apache.org/docs/2.4/> for detailed information.
# In particular, see
# <URL:http://httpd.apache.org/docs/2.4/mod/directives.html>
# for a discussion of each configuration directive.
#
# Do NOT simply read the instructions in here without understanding
# what they do.  They're here only as hints or reminders.  If you are unsure
# consult the online docs. You have been warned. 
#
# Configuration and logfile names: If the filenames you specify for many
# of the server's control files begin with "/" (or "drive:/" for Win32), the
# server will use that explicit path.  If the filenames do *not* begin
# with "/", the value of ServerRoot is prepended -- so "logs/access_log"
# with ServerRoot set to "/usr/local/apache2" will be interpreted by the
# server as "/usr/local/apache2/logs/access_log", whereas "/logs/access_log"
# will be interpreted as '/logs/access_log'.
#
# NOTE: Where filenames are specified, you must use forward slashes
# instead of backslashes (e.g., "c:/apache" instead of "c:\apache").
# If a drive letter is omitted, the drive on which httpd.exe is located
# will be used by default.  It is recommended that you always supply
# an explicit drive letter in absolute paths to avoid confusion.

#
# ServerRoot: The top of the directory tree under which the server's
# configuration, error, and log files are kept.
#
# Do not add a slash at the end of the directory path.  If you point
# ServerRoot at a non-local disk, be sure to specify a local disk on the
# Mutex directive, if file-based mutexes are used.  If you wish to share the
# same ServerRoot for multiple httpd daemons, you will need to change at
# least PidFile.
#
Define SRVROOT "/xampp/apache"

ServerRoot "/xampp/apache"

#
# Mutex: Allows you to set the mutex mechanism and mutex file directory
# for individual mutexes, or change the global defaults
#
# Uncomment and change the directory if mutexes are file-based and the default
# mutex file directory is not on a local disk or is not appropriate for some
# other reason.
#
# Mutex default:logs

#
# Listen: Allows you to bind Apache to specific IP addresses and/or
# ports, instead of the default. See also the <VirtualHost>
# directive.
#
# Change this to Listen on specific IP addresses as shown below to
# prevent Apache from glomming onto all bound IP addresses.
#
#Listen 12.34.56.78:80
Listen 80

#
# Dynamic Shared Object (DSO) Support
#
# To be able to use the functionality of a module which was built as a DSO you
# have to place corresponding `LoadModule' lines at this location so the
# directives contained in it are actually available _before_ they are used.
# Statically compiled modules (those listed by `httpd -l') do not need
# to be loaded here.
#
# Example:
# LoadModule foo_module modules/mod_foo.so
#
LoadModule access_compat_module modules/mod_access_compat.so
LoadModule actions_module modules/mod_actions.so
LoadModule alias_module modules/mod_alias.so
LoadModule allowmethods_module modules/mod_allowmethods.so
LoadModule asis_module modules/mod_asis.so
LoadModule auth_basic_module modules/mod_auth_basic.so
#LoadModule auth_digest_module modules/mod_auth_digest.so
#LoadModule auth_form_module modules/mod_auth_form.so
#LoadModule authn_anon_module modules/mod_authn_anon.so
LoadModule authn_core_module modules/mod_authn_core.so
#LoadModule authn_dbd_module modules/mod_authn_dbd.so
#LoadModule authn_dbm_module modules/mod_authn_dbm.so
LoadModule authn_file_module modules/mod_authn_file.so
#LoadModule authn_socache_module modules/mod_authn_socache.so
#LoadModule authnz_fcgi_module modules/mod_authnz_fcgi.so
#LoadModule authnz_ldap_module modules/mod_authnz_ldap.so
LoadModule authz_core_module modules/mod_authz_core.so
#LoadModule authz_dbd_module modules/mod_authz_dbd.so
#LoadModule authz_dbm_module modules/mod_authz_dbm.so
LoadModule authz_groupfile_module modules/mod_authz_groupfile.so
LoadModule authz_host_module modules/mod_authz_host.so
#LoadModule authz_owner_module modules/mod_authz_owner.so
LoadModule authz_user_module modules/mod_authz_user.so
LoadModule autoindex_module modules/mod_autoindex.so
#LoadModule brotli_module modules/mod_brotli.so
#LoadModule buffer_module modules/mod_buffer.so
#LoadModule cache_module modules/mod_cache.so
#LoadModule cache_disk_module modules/mod_cache_disk.so
#LoadModule cache_socache_module modules/mod_cache_socache.so
#LoadModule cern_meta_module modules/mod_cern_meta.so
LoadModule cgi_module modules/mod_cgi.so
#LoadModule charset_lite_module modules/mod_charset_lite.so
#LoadModule data_module modules/mod_data.so
#LoadModule dav_module modules/mod_dav.so
#LoadModule dav_fs_module modules/mod_dav_fs.so
LoadModule dav_lock_module modules/mod_dav_lock.so
#LoadModule dbd_module modules/mod_dbd.so
#LoadModule deflate_module modules/mod_deflate.so
LoadModule dir_module modules/mod_dir.so
#LoadModule dumpio_module modules/mod_dumpio.so
LoadModule env_module modules/mod_env.so
#LoadModule expires_module modules/mod_expires.so
#LoadModule ext_filter_module modules/mod_ext_filter.so
#LoadModule file_cache_module modules/mod_file_cache.so
#LoadModule filter_module modules/mod_filter.so
#LoadModule http2_module modules/mod_http2.so
LoadModule headers_module modules/mod_headers.so
#LoadModule heartbeat_module modules/mod_heartbeat.so
#LoadModule heartmonitor_module modules/mod_heartmonitor.so
#LoadModule ident_module modules/mod_ident.so
#LoadModule imagemap_module modules/mod_imagemap.so
LoadModule include_module modules/mod_include.so
LoadModule info_module modules/mod_info.so
LoadModule isapi_module modules/mod_isapi.so
#LoadModule lbmethod_bybusyness_module modules/mod_lbmethod_bybusyness.so
#LoadModule lbmethod_byrequests_module modules/mod_lbmethod_byrequests.so
#LoadModule lbmethod_bytraffic_module modules/mod_lbmethod_bytraffic.so
#LoadModule lbmethod_heartbeat_module modules/mod_lbmethod_heartbeat.so
#LoadModule ldap_module modules/mod_ldap.so
#LoadModule logio_module modules/mod_logio.so
LoadModule log_config_module modules/mod_log_config.so
#LoadModule log_debug_module modules/mod_log_debug.so
#LoadModule log_forensic_module modules/mod_log_forensic.so
#LoadModule lua_module modules/mod_lua.so
LoadModule cache_disk_module modules/mod_cache_disk.so
#LoadModule macro_module modules/mod_macro.so
#LoadModule md_module modules/mod_md.so
LoadModule mime_module modules/mod_mime.so
#LoadModule mime_magic_module modules/mod_mime_magic.so
LoadModule negotiation_module modules/mod_negotiation.so
LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_ajp_module modules/mod_proxy_ajp.so
#LoadModule proxy_balancer_module modules/mod_proxy_balancer.so
#LoadModule proxy_connect_module modules/mod_proxy_connect.so
#LoadModule proxy_express_module modules/mod_proxy_express.so
#LoadModule proxy_fcgi_module modules/mod_proxy_fcgi.so
#LoadModule proxy_ftp_module modules/mod_proxy_ftp.so
#LoadModule proxy_hcheck_module modules/mod_proxy_hcheck.so
#LoadModule proxy_html_module modules/mod_proxy_html.so
#LoadModule proxy_http_module modules/mod_proxy_http.so
#LoadModule proxy_http2_module modules/mod_proxy_http2.so
#LoadModule proxy_scgi_module modules/mod_proxy_scgi.so
#LoadModule proxy_uwsgi_module modules/mod_proxy_uwsgi.so
#LoadModule proxy_wstunnel_module modules/mod_proxy_wstunnel.so
#LoadModule ratelimit_module modules/mod_ratelimit.so
#LoadModule reflector_module modules/mod_reflector.so
#LoadModule remoteip_module modules/mod_remoteip.so
#LoadModule request_module modules/mod_request.so
#LoadModule reqtimeout_module modules/mod_reqtimeout.so
LoadModule rewrite_module modules/mod_rewrite.so
#LoadModule sed_module modules/mod_sed.so
#LoadModule session_module modules/mod_session.so
#LoadModule session_cookie_module modules/mod_session_cookie.so
#LoadModule session_crypto_module modules/mod_session_crypto.so
#LoadModule session_dbd_module modules/mod_session_dbd.so
LoadModule setenvif_module modules/mod_setenvif.so
#LoadModule slotmem_plain_module modules/mod_slotmem_plain.so
#LoadModule slotmem_shm_module modules/mod_slotmem_shm.so
#LoadModule socache_dbm_module modules/mod_socache_dbm.so
#LoadModule socache_memcache_module modules/mod_socache_memcache.so
#LoadModule socache_redis_module modules/mod_socache_redis.so
LoadModule socache_shmcb_module modules/mod_socache_shmcb.so
#LoadModule speling_module modules/mod_speling.so
LoadModule ssl_module modules/mod_ssl.so
LoadModule status_module modules/mod_status.so
#LoadModule substitute_module modules/mod_substitute.so
#LoadModule unique_id_module modules/mod_unique_id.so
#LoadModule userdir_module modules/mod_userdir.so
#LoadModule usertrack_module modules/mod_usertrack.so
#LoadModule version_module modules/mod_version.so
#LoadModule vhost_alias_module modules/mod_vhost_alias.so
#LoadModule watchdog_module modules/mod_watchdog.so
#LoadModule xml2enc_module modules/mod_xml2enc.so

<IfModule unixd_module>
#
# If you wish httpd to run as a different user or group, you must run
# httpd as root initially and it will switch. 
#
# User/Group: The name (or #number) of the user/group to run httpd as.
# It is usually good practice to create a dedicated user and group for
# running httpd, as with most system services.
#
User daemon
Group daemon

</IfModule>

# 'Main' server configuration
#
# The directives in this section set up the values used by the 'main'
# server, which responds to any requests that aren't handled by a
# <VirtualHost> definition.  These values also provide defaults for
# any <VirtualHost> containers you may define later in the file.
#
# All of these directives may appear inside <VirtualHost> containers,
# in which case these default settings will be overridden for the
# virtual host being defined.
#

#
# ServerAdmin: Your address, where problems with the server should be
# e-mailed.  This address appears on some server-generated pages, such
# as error documents.  e.g. admin@your-domain.com
#
ServerAdmin postmaster@localhost

#
# ServerName gives the name and port that the server uses to identify itself.
# This can often be determined automatically, but we recommend you specify
# it explicitly to prevent problems during startup.
#
# If your host doesn't have a registered DNS name, enter its IP address here.
#
ServerName localhost:80

#
# Deny access to the entirety of your server's filesystem. You must
# explicitly permit access to web content directories in other
# <Directory> blocks below.
#
<Directory />
    AllowOverride none
    Require all denied
</Directory>

#
# Note that from this point forward you must specifically allow
# particular features to be enabled - so if something's not working as
# you might expect, make sure that you have specifically enabled it
# below.
#

#
# DocumentRoot: The directory out of which you will serve your
# documents. By default, all requests are taken from this directory, but
# symbolic links and aliases may be used to point to other locations.
#
DocumentRoot "/xampp/htdocs"
<Directory "/xampp/htdocs">
    #
    # Possible values for the Options directive are "None", "All",
    # or any combination of:
    #   Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews
    #
    # Note that "MultiViews" must be named *explicitly* --- "Options All"
    # doesn't give it to you.
    #
    # The Options directive is both complicated and important.  Please see
    # http://httpd.apache.org/docs/2.4/mod/core.html#options
    # for more information.
    #
    Options Indexes FollowSymLinks Includes ExecCGI

    #
    # AllowOverride controls what directives may be placed in .htaccess files.
    # It can be "All", "None", or any combination of the keywords:
    #   AllowOverride FileInfo AuthConfig Limit
    #
    AllowOverride All

    #
    # Controls who can get stuff from this server.
    #
    Require all granted
</Directory>

#
# DirectoryIndex: sets the file that Apache will serve if a directory
# is requested.
#
<IfModule dir_module>
    DirectoryIndex index.php index.pl index.cgi index.asp index.shtml index.html index.htm \
                   default.php default.pl default.cgi default.asp default.shtml default.html default.htm \
                   home.php home.pl home.cgi home.asp home.shtml home.html home.htm
</IfModule>

#
# The following lines prevent .htaccess and .htpasswd files from being
# viewed by Web clients.
#
<Files ".ht*">
    Require all denied
</Files>

#
# ErrorLog: The location of the error log file.
# If you do not specify an ErrorLog directive within a <VirtualHost>
# container, error messages relating to that virtual host will be
# logged here.  If you *do* define an error logfile for a <VirtualHost>
# container, that host's errors will be logged there and not here.
#
ErrorLog "logs/error.log"

#
# LogLevel: Control the number of messages logged to the error_log.
# Possible values include: debug, info, notice, warn, error, crit,
# alert, emerg.
#
LogLevel warn

<IfModule log_config_module>
    #
    # The following directives define some format nicknames for use with
    # a CustomLog directive (see below).
    #
    LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
    LogFormat "%h %l %u %t \"%r\" %>s %b" common

    <IfModule logio_module>
      # You need to enable mod_logio.c to use %I and %O
      LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio
    </IfModule>

    #
    # The location and format of the access logfile (Common Logfile Format).
    # If you do not define any access logfiles within a <VirtualHost>
    # container, they will be logged here.  Contrariwise, if you *do*
    # define per-<VirtualHost> access logfiles, transactions will be
    # logged therein and *not* in this file.
    #
    #CustomLog "logs/access.log" common

    #
    # If you prefer a logfile with access, agent, and referer information
    # (Combined Logfile Format) you can use the following directive.
    #
    CustomLog "logs/access.log" combined
</IfModule>

<IfModule alias_module>
    #
    # Redirect: Allows you to tell clients about documents that used to
    # exist in your server's namespace, but do not anymore. The client
    # will make a new request for the document at its new location.
    # Example:
    # Redirect permanent /foo http://www.example.com/bar

    #
    # Alias: Maps web paths into filesystem paths and is used to
    # access content that does not live under the DocumentRoot.
    # Example:
    # Alias /webpath /full/filesystem/path
    #
    # If you include a trailing / on /webpath then the server will
    # require it to be present in the URL.  You will also likely
    # need to provide a <Directory> section to allow access to
    # the filesystem path.

    #
    # ScriptAlias: This controls which directories contain server scripts.
    # ScriptAliases are essentially the same as Aliases, except that
    # documents in the target directory are treated as applications and
    # run by the server when requested rather than as documents sent to the
    # client.  The same rules about trailing "/" apply to ScriptAlias
    # directives as to Alias.
    #
    ScriptAlias /cgi-bin/ "/xampp/cgi-bin/"

</IfModule>

<IfModule cgid_module>
    #
    # ScriptSock: On threaded servers, designate the path to the UNIX
    # socket used to communicate with the CGI daemon of mod_cgid.
    #
    #Scriptsock cgisock
</IfModule>

#
# "/xampp/cgi-bin" should be changed to whatever your ScriptAliased
# CGI directory exists, if you have that configured.
#
<Directory "/xampp/cgi-bin">
    AllowOverride All
    Options None
    Require all granted
</Directory>

<IfModule headers_module>
    #
    # Avoid passing HTTP_PROXY environment to CGI's on this or any proxied
    # backend servers which have lingering "httpoxy" defects.
    # 'Proxy' request header is undefined by the IETF, not listed by IANA
    #
    RequestHeader unset Proxy early
</IfModule>

<IfModule mime_module>
    #
    # TypesConfig points to the file containing the list of mappings from
    # filename extension to MIME-type.
    #
    TypesConfig conf/mime.types

    #
    # AddType allows you to add to or override the MIME configuration
    # file specified in TypesConfig for specific file types.
    #
    #AddType application/x-gzip .tgz
    #
    # AddEncoding allows you to have certain browsers uncompress
    # information on the fly. Note: Not all browsers support this.
    #
    #AddEncoding x-compress .Z
    #AddEncoding x-gzip .gz .tgz
    #
    # If the AddEncoding directives above are commented-out, then you
    # probably should define those extensions to indicate media types:
    #
    AddType application/x-compress .Z
    AddType application/x-gzip .gz .tgz

    #
    # AddHandler allows you to map certain file extensions to "handlers":
    # actions unrelated to filetype. These can be either built into the server
    # or added with the Action directive (see below)
    #
    # To use CGI scripts outside of ScriptAliased directories:
    # (You will also need to add "ExecCGI" to the "Options" directive.)
    #
    AddHandler cgi-script .cgi .pl .asp

    # For type maps (negotiated resources):
    #AddHandler type-map var

    #
    # Filters allow you to process content before it is sent to the client.
    #
    # To parse .shtml files for server-side includes (SSI):
    # (You will also need to add "Includes" to the "Options" directive.)
    #
    AddType text/html .shtml
    AddOutputFilter INCLUDES .shtml
</IfModule>

#
# The mod_mime_magic module allows the server to use various hints from the
# contents of the file itself to determine its type.  The MIMEMagicFile
# directive tells the module where the hint definitions are located.
#
<IfModule mime_magic_module>
    #
    # The mod_mime_magic module allows the server to use various hints from the
    # contents of the file itself to determine its type.  The MIMEMagicFile
    # directive tells the module where the hint definitions are located.
    #
    MIMEMagicFile "conf/magic"
</IfModule>


#
# Customizable error responses come in three flavors:
# 1) plain text 2) local redirects 3) external redirects
#
# Some examples:
#ErrorDocument 500 "The server made a boo boo."
#ErrorDocument 404 /missing.html
#ErrorDocument 404 "/cgi-bin/missing_handler.pl"
#ErrorDocument 402 http://www.example.com/subscription_info.html
#

#
# MaxRanges: Maximum number of Ranges in a request before
# returning the entire resource, or one of the special
# values 'default', 'none' or 'unlimited'.
# Default setting is to accept 200 Ranges.
#MaxRanges unlimited

#
# EnableMMAP and EnableSendfile: On systems that support it,
# memory-mapping or the sendfile syscall may be used to deliver
# files.  This usually improves server performance, but must
# be turned off when serving from networked-mounted
# filesystems or if support for these functions is otherwise
# broken on your system.
# Defaults: EnableMMAP On, EnableSendfile Off
#
#EnableMMAP off
#EnableSendfile off

# Supplemental configuration
#
# The configuration files in the conf/extra/ directory can be
# included to add extra features or to modify the default configuration of
# the server, or you may simply copy their contents here and change as
# necessary.

# Server-pool management (MPM specific)
Include conf/extra/httpd-mpm.conf

# Multi-language error messages
#Include conf/extra/httpd-multilang-errordoc.conf

# Fancy directory listings
Include conf/extra/httpd-autoindex.conf

# Language settings
Include conf/extra/httpd-languages.conf

# User home directories
Include conf/extra/httpd-userdir.conf

# Real-time info on requests and configuration
Include conf/extra/httpd-info.conf

# Virtual hosts
Include conf/extra/httpd-vhosts.conf

# Local access to the Apache HTTP Server Manual
#Include conf/extra/httpd-manual.conf

# Distributed authoring and versioning (WebDAV)
#Attention! WEB_DAV is a security risk without a new userspecific configuration for a secure authentifcation
#Include conf/extra/httpd-dav.conf

# Various default settings
#Include conf/extra/httpd-default.conf
# Implements a proxy/gateway for Apache.
Include "conf/extra/httpd-proxy.conf"
# Various default settings
Include "conf/extra/httpd-default.conf"
# XAMPP settings
Include "conf/extra/httpd-xampp.conf"

# Configure mod_proxy_html to understand HTML4/XHTML1
<IfModule proxy_html_module>
Include conf/extra/proxy-html.conf
</IfModule>

# Secure (SSL/TLS) connections
Include conf/extra/httpd-ssl.conf
#
# Note: The following must must be present to support
#       starting without SSL on platforms with no /dev/random equivalent
#       but a statically compiled-in mod_ssl.
#
<IfModule ssl_module>
SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
</IfModule>

# XAMPP: We disable operating system specific optimizations for a listening
# socket by the http protocol here. IE 64 bit make problems without this.

AcceptFilter http none
AcceptFilter https none
# AJP13 Proxy
<IfModule mod_proxy.c>
<IfModule mod_proxy_ajp.c>
Include "conf/extra/httpd-ajp.conf"
</IfModule>
</IfModule>


https-ssl

Code: Select all

#
# This is the Apache server configuration file providing SSL support.
# It contains the configuration directives to instruct the server how to
# serve pages over an https connection. For detailed information about these
# directives see <URL:http://httpd.apache.org/docs/2.4/mod/mod_ssl.html>
#
# Do NOT simply read the instructions in here without understanding
# what they do.  They're here only as hints or reminders.  If you are unsure
# consult the online docs. You have been warned. 
#
# Required modules: mod_log_config, mod_setenvif, mod_ssl,
#          socache_shmcb_module (for default value of SSLSessionCache)

#
# Pseudo Random Number Generator (PRNG):
# Configure one or more sources to seed the PRNG of the SSL library.
# The seed data should be of good random quality.
# WARNING! On some platforms /dev/random blocks if not enough entropy
# is available. This means you then cannot use the /dev/random device
# because it would lead to very long connection times (as long as
# it requires to make more entropy available). But usually those
# platforms additionally provide a /dev/urandom device which doesn't
# block. So, if available, use this one instead. Read the mod_ssl User
# Manual for more details.
#
#SSLRandomSeed startup file:/dev/random  512
#SSLRandomSeed startup file:/dev/urandom 512
#SSLRandomSeed connect file:/dev/random  512
#SSLRandomSeed connect file:/dev/urandom 512


#
# When we also provide SSL we have to listen to the
# standard HTTP port (see above) and to the HTTPS port
#
Listen 4434

##
##  SSL Global Context
##
##  All SSL configuration in this context applies both to
##  the main server and all SSL-enabled virtual hosts.
##

#   SSL Cipher Suite:
#   List the ciphers that the client is permitted to negotiate,
#   and that httpd will negotiate as the client of a proxied server.
#   See the OpenSSL documentation for a complete list of ciphers, and
#   ensure these follow appropriate best practices for this deployment.
#   httpd 2.2.30, 2.4.13 and later force-disable aNULL, eNULL and EXP ciphers,
#   while OpenSSL disabled these by default in 0.9.8zf/1.0.0r/1.0.1m/1.0.2a.
SSLCipherSuite HIGH:MEDIUM:!MD5:!RC4:!3DES
SSLProxyCipherSuite HIGH:MEDIUM:!MD5:!RC4:!3DES

#  By the end of 2016, only TLSv1.2 ciphers should remain in use.
#  Older ciphers should be disallowed as soon as possible, while the
#  kRSA ciphers do not offer forward secrecy.  These changes inhibit
#  older clients (such as IE6 SP2 or IE8 on Windows XP, or other legacy
#  non-browser tooling) from successfully connecting. 
#
#  To restrict mod_ssl to use only TLSv1.2 ciphers, and disable
#  those protocols which do not support forward secrecy, replace
#  the SSLCipherSuite and SSLProxyCipherSuite directives above with
#  the following two directives, as soon as practical.
# SSLCipherSuite HIGH:MEDIUM:!SSLv3:!kRSA
# SSLProxyCipherSuite HIGH:MEDIUM:!SSLv3:!kRSA

#   User agents such as web browsers are not configured for the user's
#   own preference of either security or performance, therefore this
#   must be the prerogative of the web server administrator who manages
#   cpu load versus confidentiality, so enforce the server's cipher order.
SSLHonorCipherOrder on

#   SSL Protocol support:
#   List the protocol versions which clients are allowed to connect with.
#   Disable SSLv3 by default (cf. RFC 7525 3.1.1).  TLSv1 (1.0) should be
#   disabled as quickly as practical.  By the end of 2016, only the TLSv1.2
#   protocol or later should remain in use.
SSLProtocol all -SSLv3
SSLProxyProtocol all -SSLv3

#   Pass Phrase Dialog:
#   Configure the pass phrase gathering process.
#   The filtering dialog program (`builtin' is an internal
#   terminal dialog) has to provide the pass phrase on stdout.
SSLPassPhraseDialog  builtin

#   Inter-Process Session Cache:
#   Configure the SSL Session Cache: First the mechanism
#   to use and second the expiring timeout (in seconds).
#SSLSessionCache "shmcb:/xampp/apache/logs/ssl_scache(512000)"
SSLSessionCache "shmcb:/xampp/apache/logs/ssl_scache(512000)"
SSLSessionCacheTimeout  300

#   OCSP Stapling (requires OpenSSL 0.9.8h or later)
#
#   This feature is disabled by default and requires at least
#   the two directives SSLUseStapling and SSLStaplingCache.
#   Refer to the documentation on OCSP Stapling in the SSL/TLS
#   How-To for more information.
#
#   Enable stapling for all SSL-enabled servers:
#SSLUseStapling On

#   Define a relatively small cache for OCSP Stapling using
#   the same mechanism that is used for the SSL session cache
#   above.  If stapling is used with more than a few certificates,
#   the size may need to be increased.  (AH01929 will be logged.)
#SSLStaplingCache "shmcb:${SRVROOT}/logs/ssl_stapling(32768)"

#   Seconds before valid OCSP responses are expired from the cache
#SSLStaplingStandardCacheTimeout 3600

#   Seconds before invalid OCSP responses are expired from the cache
#SSLStaplingErrorCacheTimeout 600

##
## SSL Virtual Host Context
##

<VirtualHost _default_:443>

#   General setup for the virtual host
DocumentRoot "/xampp/htdocs"
ServerName www.example.com:443
ServerAdmin admin@example.com
ErrorLog "/xampp/apache/logs/error.log"
TransferLog "/xampp/apache/logs/access.log"

#   SSL Engine Switch:
#   Enable/Disable SSL for this virtual host.
SSLEngine on

#   Server Certificate:
#   Point SSLCertificateFile "conf/ssl.crt/server.crt"
#   the certificate is encrypted, then you will be prompted for a
#   pass phrase.  Note that a kill -HUP will prompt again.  Keep
#   in mind that if you have both an RSA and a DSA certificate you
#   can configure both in parallel (to also allow the use of DSA
#   ciphers, etc.)
#   Some ECC cipher suites (http://www.ietf.org/rfc/rfc4492.txt)
#   require an ECC certificate which can also be configured in
#   parallel.
SSLCertificateFile "conf/ssl.crt/server.crt"
#SSLCertificateFile "conf/ssl.crt/server.crt"
#SSLCertificateFile "conf/ssl.crt/server.crt"

#   Server Private Key:
#   If the key is not combined with the certificate, use this
#   directive to point at the key file.  Keep in mind that if
#   you've both a RSA and a DSA private key you can configure
#   both in parallel (to also allow the use of DSA ciphers, etc.)
#   ECC keys, when in use, can also be configured in parallel
SSLCertificateKeyFile "conf/ssl.key/server.key"
#SSLCertificateKeyFile "conf/ssl.key/server.key"
#SSLCertificateKeyFile "conf/ssl.key/server.key"

#   Server Certificate Chain:
#   Point SSLCertificateChainFile at a file containing the
#   concatenation of PEM encoded CA certificates which form the
#   certificate chain for the server certificate. Alternatively
#   the referenced file can be the same as SSLCertificateFile "conf/ssl.crt/server.crt"
#   certificate for convenience.
#SSLCertificateChainFile "${SRVROOT}/conf/server-ca.crt"

#   Certificate Authority (CA):
#   Set the CA certificate verification path where to find CA
#   certificates for client authentication or alternatively one
#   huge file containing all of them (file must be PEM encoded)
#   Note: Inside SSLCACertificatePath you need hash symlinks
#         to point to the certificate files. Use the provided
#         Makefile to update the hash symlinks after changes.
#SSLCACertificatePath "${SRVROOT}/conf/ssl.crt"
#SSLCACertificateFile "${SRVROOT}/conf/ssl.crt/ca-bundle.crt"

#   Certificate Revocation Lists (CRL):
#   Set the CA revocation path where to find CA CRLs for client
#   authentication or alternatively one huge file containing all
#   of them (file must be PEM encoded).
#   The CRL checking mode needs to be configured explicitly
#   through SSLCARevocationCheck (defaults to "none" otherwise).
#   Note: Inside SSLCARevocationPath you need hash symlinks
#         to point to the certificate files. Use the provided
#         Makefile to update the hash symlinks after changes.
#SSLCARevocationPath "${SRVROOT}/conf/ssl.crl"
#SSLCARevocationFile "${SRVROOT}/conf/ssl.crl/ca-bundle.crl"
#SSLCARevocationCheck chain

#   Client Authentication (Type):
#   Client certificate verification type and depth.  Types are
#   none, optional, require and optional_no_ca.  Depth is a
#   number which specifies how deeply to verify the certificate
#   issuer chain before deciding the certificate is not valid.
#SSLVerifyClient require
#SSLVerifyDepth  10

#   TLS-SRP mutual authentication:
#   Enable TLS-SRP and set the path to the OpenSSL SRP verifier
#   file (containing login information for SRP user accounts).
#   Requires OpenSSL 1.0.1 or newer. See the mod_ssl FAQ for
#   detailed instructions on creating this file. Example:
#   "openssl srp -srpvfile ${SRVROOT}/conf/passwd.srpv -add username"
#SSLSRPVerifierFile "${SRVROOT}/conf/passwd.srpv"

#   Access Control:
#   With SSLRequire you can do per-directory access control based
#   on arbitrary complex boolean expressions containing server
#   variable checks and other lookup directives.  The syntax is a
#   mixture between C and Perl.  See the mod_ssl documentation
#   for more details.
#<Location />
#SSLRequire (    %{SSL_CIPHER} !~ m/^(EXP|NULL)/ \
#            and %{SSL_CLIENT_S_DN_O} eq "Snake Oil, Ltd." \
#            and %{SSL_CLIENT_S_DN_OU} in {"Staff", "CA", "Dev"} \
#            and %{TIME_WDAY} >= 1 and %{TIME_WDAY} <= 5 \
#            and %{TIME_HOUR} >= 8 and %{TIME_HOUR} <= 20       ) \
#           or %{REMOTE_ADDR} =~ m/^192\.76\.162\.[0-9]+$/
#</Location>

#   SSL Engine Options:
#   Set various options for the SSL engine.
#   o FakeBasicAuth:
#     Translate the client X.509 into a Basic Authorisation.  This means that
#     the standard Auth/DBMAuth methods can be used for access control.  The
#     user name is the `one line' version of the client's X.509 certificate.
#     Note that no password is obtained from the user. Every entry in the user
#     file needs this password: `xxj31ZMTZzkVA'.
#   o ExportCertData:
#     This exports two additional environment variables: SSL_CLIENT_CERT and
#     SSL_SERVER_CERT. These contain the PEM-encoded certificates of the
#     server (always existing) and the client (only existing when client
#     authentication is used). This can be used to import the certificates
#     into CGI scripts.
#   o StdEnvVars:
#     This exports the standard SSL/TLS related `SSL_*' environment variables.
#     Per default this exportation is switched off for performance reasons,
#     because the extraction step is an expensive operation and is usually
#     useless for serving static content. So one usually enables the
#     exportation for CGI and SSI requests only.
#   o StrictRequire:
#     This denies access when "SSLRequireSSL" or "SSLRequire" applied even
#     under a "Satisfy any" situation, i.e. when it applies access is denied
#     and no other module can change it.
#   o OptRenegotiate:
#     This enables optimized SSL connection renegotiation handling when SSL
#     directives are used in per-directory context.
#SSLOptions +FakeBasicAuth +ExportCertData +StrictRequire
<FilesMatch "\.(cgi|shtml|phtml|php)$">
    SSLOptions +StdEnvVars
</FilesMatch>
<Directory "/xampp/apache/cgi-bin">
    SSLOptions +StdEnvVars
</Directory>

#   SSL Protocol Adjustments:
#   The safe and default but still SSL/TLS standard compliant shutdown
#   approach is that mod_ssl sends the close notify alert but doesn't wait for
#   the close notify alert from client. When you need a different shutdown
#   approach you can use one of the following variables:
#   o ssl-unclean-shutdown:
#     This forces an unclean shutdown when the connection is closed, i.e. no
#     SSL close notify alert is sent or allowed to be received.  This violates
#     the SSL/TLS standard but is needed for some brain-dead browsers. Use
#     this when you receive I/O errors because of the standard approach where
#     mod_ssl sends the close notify alert.
#   o ssl-accurate-shutdown:
#     This forces an accurate shutdown when the connection is closed, i.e. a
#     SSL close notify alert is send and mod_ssl waits for the close notify
#     alert of the client. This is 100% SSL/TLS standard compliant, but in
#     practice often causes hanging connections with brain-dead browsers. Use
#     this only for browsers where you know that their SSL implementation
#     works correctly.
#   Notice: Most problems of broken clients are also related to the HTTP
#   keep-alive facility, so you usually additionally want to disable
#   keep-alive for those clients, too. Use variable "nokeepalive" for this.
#   Similarly, one has to force some clients to use HTTP/1.0 to workaround
#   their broken HTTP/1.1 implementation. Use variables "downgrade-1.0" and
#   "force-response-1.0" for this.
BrowserMatch "MSIE [2-5]" \
         nokeepalive ssl-unclean-shutdown \
         downgrade-1.0 force-response-1.0

#   Per-Server Logging:
#   The home of a custom SSL log file. Use this when you want a
#   compact non-error SSL logfile on a virtual host basis.
CustomLog "/xampp/apache/logs/ssl_request.log" \
          "%t %h %{SSL_PROTOCOL}x %{SSL_CIPHER}x \"%r\" %b"

</VirtualHost>                                 


but now all sites going directly to the xampp dashboard, or some of them does not work at all anymore.
i have also copied the complete -old apache-httpd-ssl conf in to the new one.

Hello
in phpmyadmin I wanted to change the password BD and I got an error and now impossible to connect to phpMyAdmin
I use XAMPP 3.3.0

error
MySQL replied: Documentation
Unable to connect: incorrect settings.
mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)
phpMyAdmin attempted to connect to the MySQL server, and the server rejected the connection. Please check the values of host, username and password in the configuration and ensure that they match the information provided by the MySQL server administrator.

thank you for help

I have a reply in the post "Access forbidden - 403 error - VirtualHost" but realized that I should have started a new post. I have not been able to find a solution from available posts and I don't think I should be encountering this issue with a relatively straightforward install. I am not a web development pro but I have previously posted a Joomla 3 site which is currently down for migration to Joomla 4.

I am currently working on another site "ccorch.net" which I have installed locally using xampp with the following installation details.
computer: Mac Studio (apple silicon) running Mac OS Ventura 13.5.2, XAMPP 8.1.17, Joomla 4.3.4

I installed XAMPP, and created my database "ccorch" in phpMyAdmin. I chose not to allow external network connections as I only intend to run on my Mac Studio. I also attended to FTP and MySQL passwords.
I then unzipped the Joomla_4.3.4-Stable-Full_Package file, copied the folder to /xampfiles/htdocs and renamed it "ccorch" (/applications/XAMPP/xampfiles/htdocs/ccorch)

After doing all this, opening the XAMPP dashboard produces the expected Welcome page but an attempt to open localhost/ccorch produces the "Access forbidden!, Error 403"

I am reluctant to tinker around int the htaccess.txt. I do notice that the error log below refers to the hidden file .htaccess. I duplicated htaccess.txt and renamed to .htaccess with no effect

It seems to me that my credentials as super user should override any access issues. Any help will be much appreciated. I have used the command console in the past but at age 86 I was hoping not to have to resort to much of that just to get the Joomla setup process going.

The Apache error log:
[Tue Sep 12 10:50:43.228886 2023] [core:crit] [pid 4887] (13)Permission denied: [client 127.0.0.1:54429] AH00529: /Applications/XAMPP/xamppfiles/htdocs/ccorch/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/Applications/XAMPP/xamppfiles/htdocs/ccorch/' is executable
[Tue Sep 12 11:33:48.670872 2023] [core:crit] [pid 1491] (13)Permission denied: [client 127.0.0.1:54977] AH00529: /Applications/XAMPP/xamppfiles/htdocs/ccorch/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/Applications/XAMPP/xamppfiles/htdocs/ccorch/' is executable
dick@Duke ~ %

XAMPP security check:
XAMPP: Quick security check...
XAMPP: MySQL is not accessable via network. Good.
XAMPP: MySQL has a root passwort set. Fine!
XAMPP: ProFTPD has a new FTP password. Great!
XAMPP: Do you want to change the password anyway? [no]
XAMPP: Done.

I have a reply in the post "Access forbidden - 403 error - VirtualHost" but realized that I should have started a new post. I have not been able to find a solution from available posts and I don't think I should be encountering this issue with a relatively straightforward install. I am not a web development pro but I have previously posted a Joomla 3 site which is currently down for migration to Joomla 4.

I am currently working on another site "ccorch.net" which I have installed locally using xampp with the following installation details.
computer: Mac Studio (apple silicon) running Mac OS Ventura 13.5.2, XAMPP 8.1.17, Joomla 4.3.4

I installed XAMPP, and created my database "ccorch" in phpMyAdmin. I chose not to allow external network connections as I only intend to run on my Mac Studio. I also attended to FTP and MySQL passwords.
I then unzipped the Joomla_4.3.4-Stable-Full_Package file, copied the folder to /xampfiles/htdocs and renamed it "ccorch" (/applications/XAMPP/xampfiles/htdocs/ccorch)

After doing all this, opening the XAMPP dashboard produces the expected Welcome page but an attempt to open localhost/ccorch produces the "Access forbidden!, Error 403"

I am reluctant to tinker around int the htaccess.txt. I do notice that the error log below refers to the hidden file .htaccess. I duplicated htaccess.txt and renamed to .htaccess with no effect

It seems to me that my credentials as super user should override any access issues. Any help will be much appreciated. I have used the command console in the past but at age 86 I was hoping not to have to resort to much of that just to get the Joomla setup process going.

The Apache error log:
[Tue Sep 12 10:50:43.228886 2023] [core:crit] [pid 4887] (13)Permission denied: [client 127.0.0.1:54429] AH00529: /Applications/XAMPP/xamppfiles/htdocs/ccorch/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/Applications/XAMPP/xamppfiles/htdocs/ccorch/' is executable
[Tue Sep 12 11:33:48.670872 2023] [core:crit] [pid 1491] (13)Permission denied: [client 127.0.0.1:54977] AH00529: /Applications/XAMPP/xamppfiles/htdocs/ccorch/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/Applications/XAMPP/xamppfiles/htdocs/ccorch/' is executable
dick@Duke ~ %

XAMPP security check:
XAMPP: Quick security check...
XAMPP: MySQL is not accessable via network. Good.
XAMPP: MySQL has a root passwort set. Fine!
XAMPP: ProFTPD has a new FTP password. Great!
XAMPP: Do you want to change the password anyway? [no]
XAMPP: Done.

Hi all,
I'm on MariaDB 10.1.8, Windows OS 2019 Datacenter, PHP 8.1.16, WAMP 3.3.1. I have been trying to figure out how to get back into root now (off and on) for about 6 months, and today managed to get the queries to work but still not able to log in (which really sucks because I'm the DBA, a Team of 1, and I built the server LOL). Anyway, the code I ran was:

Use Powershell Admin (win-X) navigate to cd "c:\Program Files\Mariadb 10.1\bin"
.mysql --version
net stop <db name>
.\mysqld --skip-grant-tables --skip-networking --shared-memory

Open regular powershell window
update mysql.user set password=password('<new_pw>') where user='root';
update mysql.user set plugin='mysql_native_password' where user='root';

Which, as I mentioned, all ran successfully, but when I try and log in through either HeidiSQL or PHPMyAdmin, I'm getting the Access denied for user 'root'@'localhost' (using password: YES) error.

I desperately need to get into root to do some upgrade prep and am completely lost. FWIW, my other accounts are all able to login (backupuser, admin1, and genuser) so it's something specific with root that's the problem.
Any ideas would be appreciated.
Chris

mboudreau wrote:I am installing XAMPP 8.2.0 on an iMac running macOS 13.2.1 Ventura. After installation, I ran 'xampp security', which behaved as described in the FAQ. When I start or restart all the XAMPP servers, Apache and ProFTPD run, but MySQL shuts down. The MySQL error log shows this:

Code: Select all

2023-03-08 20:54:02 18545 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/Michaels-iMac.local.pid ended
2023-03-08 20:54:30 18 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2023-03-08 20:54:30 18976 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
2023-03-08 20:54:30 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2023-03-08 20:54:30 0 [Note] /Applications/XAMPP/xamppfiles/sbin/mysqld (mysqld 10.4.27-MariaDB) starting as process 19129 ...
2023-03-08 20:54:30 0 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
2023-03-08 20:54:30 0 [ERROR] mysqld: Can't lock aria control file '/Applications/XAMPP/xamppfiles/var/mysql/aria_log_control' for exclusive use, error: 35. Will retry for 30 seconds
2023-03-08 20:55:01 0 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/Applications/XAMPP/xamppfiles/var/mysql/aria_log_control'
2023-03-08 20:55:01 0 [ERROR] Plugin 'Aria' init function returned error.
2023-03-08 20:55:01 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2023-03-08 20:55:01 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-08 20:55:01 0 [Note] InnoDB: Uses event mutexes
2023-03-08 20:55:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-03-08 20:55:01 0 [Note] InnoDB: Number of pools: 1
2023-03-08 20:55:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-03-08 20:55:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-03-08 20:55:01 0 [Note] InnoDB: Completed initialization of buffer pool
2023-03-08 20:55:01 0 [ERROR] InnoDB: Unable to lock /Applications/XAMPP/xamppfiles/var/mysql/ibdata1 error: 35
2023-03-08 20:55:01 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2023-03-08 20:55:01 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2023-03-08 20:55:01 0 [Note] InnoDB: Starting shutdown...
2023-03-08 20:55:01 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-03-08 20:55:01 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-03-08 20:55:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-03-08 20:55:01 0 [ERROR] Failed to initialize plugins.
2023-03-08 20:55:01 0 [ERROR] Aborting
2023-03-08 20:55:01 18976 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/Michaels-iMac.local.pid ended


Hi,
I want to suggest a solution. Hope that it works.
1. Stop the MySQL server.

2. Make a backup copy of the entire MySQL data directory.

3. Restart the MySQL server with the --innodb_force_recovery option set to a value of 1 or higher. This option disables certain InnoDB features to allow for recovery to proceed.

4. Dump all InnoDB tables to a backup file using mysqldump.

5. Stop the MySQL server again.

6. Remove all files in the MySQL data directory except for the following: ibdata1, ib_logfile0, and ib_logfile1.

7. Restart the MySQL server normally.

8. Reload the InnoDB tables from the backup file created in step 4 using the mysql command.

Note that there is a risk of data loss during this process, so it is important to make sure you have a backup of your data before proceeding.

I am installing XAMPP 8.2.0 on an iMac running macOS 13.2.1 Ventura. After installation, I ran 'xampp security', which behaved as described in the FAQ. When I start or restart all the XAMPP servers, Apache and ProFTPD run, but MySQL shuts down. The MySQL error log shows this:

Code: Select all

2023-03-08 20:54:02 18545 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/Michaels-iMac.local.pid ended
2023-03-08 20:54:30 18 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2023-03-08 20:54:30 18976 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
2023-03-08 20:54:30 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2023-03-08 20:54:30 0 [Note] /Applications/XAMPP/xamppfiles/sbin/mysqld (mysqld 10.4.27-MariaDB) starting as process 19129 ...
2023-03-08 20:54:30 0 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
2023-03-08 20:54:30 0 [ERROR] mysqld: Can't lock aria control file '/Applications/XAMPP/xamppfiles/var/mysql/aria_log_control' for exclusive use, error: 35. Will retry for 30 seconds
2023-03-08 20:55:01 0 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/Applications/XAMPP/xamppfiles/var/mysql/aria_log_control'
2023-03-08 20:55:01 0 [ERROR] Plugin 'Aria' init function returned error.
2023-03-08 20:55:01 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2023-03-08 20:55:01 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-08 20:55:01 0 [Note] InnoDB: Uses event mutexes
2023-03-08 20:55:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-03-08 20:55:01 0 [Note] InnoDB: Number of pools: 1
2023-03-08 20:55:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-03-08 20:55:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-03-08 20:55:01 0 [Note] InnoDB: Completed initialization of buffer pool
2023-03-08 20:55:01 0 [ERROR] InnoDB: Unable to lock /Applications/XAMPP/xamppfiles/var/mysql/ibdata1 error: 35
2023-03-08 20:55:01 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2023-03-08 20:55:01 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2023-03-08 20:55:01 0 [Note] InnoDB: Starting shutdown...
2023-03-08 20:55:01 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-03-08 20:55:01 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-03-08 20:55:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-03-08 20:55:01 0 [ERROR] Failed to initialize plugins.
2023-03-08 20:55:01 0 [ERROR] Aborting
2023-03-08 20:55:01 18976 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/Michaels-iMac.local.pid ended


abc1000000 wrote:I changed line 16 to

Code: Select all

       $conn = mysqli_connect("localhost", "root", "thecorrectpassword", "staff", 3307);

and went back to getting something similar to the previous error. (also tried it with 3307 in quote marks)

Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\GeeksforGeeks\insert.php:16 Stack trace: #0 C:\xampp\htdocs\GeeksforGeeks\insert.php(16): mysqli_connect('localhost', 'root', Object(SensitiveParameterValue), 'staff', 3307) #1 {main} thrown in C:\xampp\htdocs\GeeksforGeeks\insert.php on line 16

removing the port gives

Fatal error: Uncaught mysqli_sql_exception: Unknown database 'staff' in C:\xampp\htdocs\GeeksforGeeks\insert.php:16 Stack trace: #0 C:\xampp\htdocs\GeeksforGeeks\insert.php(16): mysqli_connect('localhost', 'root', Object(SensitiveParameterValue), 'staff') #1 {main} thrown in C:\xampp\htdocs\GeeksforGeeks\insert.php on line 16

So frustrating. Thanks for all your patience.

You need to realize one thing:
You are running currently two MariaDB or mysql database installations, one is listening on default port 3306 and one is listening on custom port 3307.
One does have a staff database, one does not
One does have the root password you tried in your script, one does not.

Just your two installations are confusing you. I can see that this can be frustrating, but XAMPP does not tell you to have another MariaDB / MySQL installed or change the port to custom 3307.

I changed line 16 to

Code: Select all

       $conn = mysqli_connect("localhost", "root", "thecorrectpassword", "staff", 3307);

and went back to getting something similar to the previous error. (also tried it with 3307 in quote marks)

Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\GeeksforGeeks\insert.php:16 Stack trace: #0 C:\xampp\htdocs\GeeksforGeeks\insert.php(16): mysqli_connect('localhost', 'root', Object(SensitiveParameterValue), 'staff', 3307) #1 {main} thrown in C:\xampp\htdocs\GeeksforGeeks\insert.php on line 16

removing the port gives

Fatal error: Uncaught mysqli_sql_exception: Unknown database 'staff' in C:\xampp\htdocs\GeeksforGeeks\insert.php:16 Stack trace: #0 C:\xampp\htdocs\GeeksforGeeks\insert.php(16): mysqli_connect('localhost', 'root', Object(SensitiveParameterValue), 'staff') #1 {main} thrown in C:\xampp\htdocs\GeeksforGeeks\insert.php on line 16

So frustrating. Thanks for all your patience.

Hi. I'm looking to set up some simple code that sent data submitted on a forms to a database on a website and it's not so simple! I thought I'd start with doing it on a local server then move that to online but I keep running in to an error.

I' tried to set up a simple html->php->MySQL page using the code here:

https://www.raghwendra.com/blog/how-to-connect-html-to-database-with-mysql-using-php-example/

unfortunately when submitting form data to test I get the following error message

"Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'root'@'localhost' (using password: NO) in C:\xampp\htdocs\contact\contact.php:5 Stack trace: #0 C:\xampp\htdocs\contact\contact.php(5): mysqli_connect('localhost', 'root', Object(SensitiveParameterValue), 'db_contact') #1 {main} thrown in C:\xampp\htdocs\contact\contact.php on line 5"

I also tried setting up a simple html->php->MySQL page using the code on

https://www.webcodzing.com/connect-html-form-to-mysql-database-using-php/

which is much the same but with the database being password protected. That time I got the following error code:

Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'formdb_user'@'localhost' (using password: YES) in C:\xampp\htdocs\testsite\form.php:22 Stack trace: #0 C:\xampp\htdocs\testsite\form.php(22): mysqli_connect('localhost', 'formdb_user', Object(SensitiveParameterValue), 'form_entriesdb') #1 {main} thrown in C:\xampp\htdocs\testsite\form.php on line 22

How do I resolve this? I'm finding this all very frustrating and just want to know how to fix it. Thank you!!

I have been using XAMPP for a few months but today it would not start mysql. It said to post log to forum.
Status change detected: stopped
10:24:15 [mysql] Error: MySQL shutdown unexpectedly.
10:24:15 [mysql] This may be due to a blocked port, missing dependencies,
10:24:15 [mysql] improper privileges, a crash, or a shutdown by another method.
10:24:15 [mysql] Press the Logs button to view error logs and check
10:24:15 [mysql] the Windows Event Viewer for more clues
10:24:15 [mysql] If you need more help, copy and post this
10:24:15 [mysql] entire log window on the forums

I try to post log but this thread says max 6000 characters.
2022-08-30 19:12:17 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-08-30 19:12:17 0 [Note] InnoDB: Uses event mutexes
2022-08-30 19:12:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-08-30 19:12:17 0 [Note] InnoDB: Number of pools: 1
2022-08-30 19:12:17 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-08-30 19:12:17 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-08-30 19:12:17 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-30 19:12:17 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2022-08-30 19:12:17 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-08-30 19:12:17 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-08-30 19:12:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-08-30 19:12:17 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-08-30 19:12:17 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-08-30 19:12:17 0 [Note] InnoDB: 10.4.24 started; log sequence number 300297; transaction id 170
2022-08-30 19:12:17 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-08-30 19:12:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-30 19:12:17 0 [Note] Server socket created on IP: '::'.
2022-08-30 19:12:17 0 [Note] InnoDB: Buffer pool(s) load completed at 220830 19:12:17
2022-08-30 19:12:17 0 [Note] Reading of all Master_info entries succeeded
2022-08-30 19:12:17 0 [Note] Added new Master_info '' to hash table
2022-08-30 19:12:17 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.4.24-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2022-08-30 19:25:54 50 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2022-08-30 19:26:16 55 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2022-09-01 16:24:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-01 16:24:07 0 [Note] InnoDB: Uses event mutexes
2022-09-01 16:24:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-01 16:24:07 0 [Note] InnoDB: Number of pools: 1
2022-09-01 16:24:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-01 16:24:07 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-09-01 16:24:07 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-01 16:24:07 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=14667403
2022-09-01 16:24:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-01 16:24:08 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-09-01 16:24:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-01 16:24:08 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-01 16:24:08 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-01 16:24:08 0 [Note] InnoDB: 10.4.24 started; log sequence number 14667412; transaction id 12573
2022-09-01 16:24:08 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-01 16:24:08 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-01 16:24:08 0 [Note] Server socket created on IP: '::'.
2022-09-02 14:03:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-02 14:03:07 0 [Note] InnoDB: Uses event mutexes
2022-09-02 14:03:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-02 14:03:07 0 [Note] InnoDB: Number of pools: 1
2022-09-02 14:03:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-02 14:03:07 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-09-02 14:03:07 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-02 14:03:07 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=33213267
2022-09-02 14:03:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-02 14:03:07 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-09-02 14:03:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables


any help greatly received, thanks.

Hi. I tried to logon to phpmyadmin and got this error

mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)

I have it setup as user='root' and no password.
Upon checking my config.inc.php file this is whats there

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

and at the start of my.ini is

[client]
#password = my-password
port = 3306
socket = "C:/xampp/mysql/mysql.sock"

I am assuming that both are correct. (from what I have read)
I also read the you can put cookie in

$cfg['Servers'][$i]['auth_type'] = 'cookie';

and myphpadmin will ignore the values of "user" and" password". So I changed my config.inc.php file to

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'thepassword';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Lang'] = '';

and got error code

mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)

I have now changed it back to the settings as it was.

What else can I try. thanks