Apache Friends Support Forum

I am using windows 10 and xamp v3.2.2. I set a password in config.inc.php and I get the following error message:
"cannot log in to mysql server mysqli_real_connect():)HY000/1045):Access denied for user 'root@localhost' (using password: yes).

if I remove the password, I can log in to phpmyadmin with no errors. I would like to set a password. Where do I set or reset the password in mysql. Is there an easy way to correct this issue.

Also how do I insert an image or images

Hi,

habe gerade die neuste XAMPP Version installiert und über das Control Panel die Shell aufgerufen, damit ich das Root Passwort für Mysql setzen kann.

# mysqladmin -u root password secret
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'HBXXXX01.hXXXX.com' (using password: NO
)'

Wie kann ich das richtig machen?

Ciao, toddehb?

while i was in phpmyadmin i set up a password. after i saved the password, phpmyadmin kicked me out and is now giving me these errors.

MySQL said:
cannot connect: invalid settings.

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.

Xampp 5.6.24 on both comps. Original comp is Windows 2012 Server, the other is Windows 7.

Using cli on both.

These 2 commands work on the Windows 2012 Server
Dump command: mysqldump -u root -pPassword --opt --result-file=c:\path\to\folder\joomla_db.sql db_name
Import command: mysql -u root -pPassword -D db_name < c:\path\to\folder\joomla_db.sql

On the Windows 7 comp. the import command results in:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Or in a similar fashion.
On the Windows 2012 Server,
I dumped the db per the above command.
I uninstalled xampp 5.6.24.
I installed xampp 7.2.11.
Started apache and mysql.
Did the import command from above and got the same result:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Can anyone tell me why? Or offer suggestions?

Thanks

Hallo zusaammen,

habe eben mal nur in meiner XAMPP-Installation 7.2.11 (Windows 10) mit phpMyAdmin das Passwort für root@localhost geändert.
Bekomme beim nächsten Start von phpMyAdmin die Fehlermeldung:
"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)
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."

Dazu zwei Fragen:
1. Wo finde ich in den Untiefen des XAMPP-Ordners die config.inc.php?
2. Muss ich auch an anderen Stellen mit diesem gewöhnungsbedürftigen Verhalten von XAMPP rechnen? Ich würde doch normalerweise von einem Programm, innerhalb dessen ich ein PW ändere, erwarten, dass ich entweder bei der nächsten Anmeldung nach dem PW gefragt werde oder beim Ändern des PW auf solche merkwürdigen Side-Effects hingewiesen werde...

Dank und Gruß
Andreas

*** update to my post ***

Still getting this access denied error trying to connect to mysql from the command line:

C:\xampp\mysql\bin>mysql --user=root --password
Enter password: ********
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

The Control Panel shows port 3308 being used for MySQL.
However, starting MySQL, gives the following "Problem detected" message.
But then it shows mysql running, despite the supposed port conflict.

Note that I set the port in C:\xampp\mysql\bin\my.ini to 3308:
port = 3308
I also set the port to 3308 in C:\Program Files\MariaDB 10.2\data\my.ini

However, I still get the following "Port 3306 in use" message, even though I changed the port to 3308 to fix the supposed port conflict.

2:52:36 PM [mysql] Attempting to stop MySQL app...
2:52:37 PM [mysql] Status change detected: stopped
2:52:40 PM [mysql] Problem detected!
2:52:40 PM [mysql] Port 3306 in use by ""C:\Program Files\MariaDB 10.2\bin\mysqld.exe" "--defaults-file=C:\Program Files\MariaDB 10.2\data\my.ini" "MariaDB""!
2:52:40 PM [mysql] MySQL WILL NOT start without the configured ports free!
2:52:40 PM [mysql] You need to uninstall/disable/reconfigure the blocking application
2:52:40 PM [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
2:52:40 PM [mysql] Attempting to start MySQL app...
2:52:41 PM [mysql] Status change detected: running

I have run out of ideas of things to change to resolve this. Still can't connect to MySQL.

Hi,

Either there is a foreign MySQL/MariaDB Server running or you setted a password for user root.

best wishes,
Altrea

Attention XAMPP & MySQL Gurus!
Help! Getting No traction on a DB connection error!
still cannot get the planets to line up!
*^&%$#!! totally frustrated!

I know that I am not the first to post on this subject, but am having no luck with anything I have googled so far.

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost'
(using password: YES) in C:\xampp\htdocs\dbconnect.php on line 8 (the mysqli_connect call)

Environment:
Win 7 Pro
Installed XAMPP V3.2.2, running Apache & MySQL

Get this error trying to connect from php script to MySQL DB:

From the browser (Chrome), running this:
http://localhost:81/dbconnect.php

<?php
# db connect parms
$dbhost = 'localhost';
$dbuser = 'root';
$dbpwd = 's3kr1t';
$dbname = 'gmap1';

$dbcon = mysqli_connect($dbhost, $dbuser, $dbpwd, $dbname);
?>

Returns this error:

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost'
(using password: YES) in C:\xampp\htdocs\dbconnect.php on line 8 (the mysqli_connect call)

So far I have done this:

* added a root password for root (default was no password)
* logged on to phpMyAdmin as root
* created a db (gmap1), table, and loaded data to it
* in phpMyAdmin selected the table data and successfully exported it
* confirmed that MySQL user root has all db access privileges:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'passroot';
So, root should be able to connect to the db!

I have worn google out researching this problem tried everything suggested to no avail

Any help much appreciated! I will even give you the rest of the day off!

Good afternoon team, I have a problem where I have created a database, and a user with passwd, the only problem is when I try to connect to it
it fails, :-
Warning: mysqli_connect(): (HY000/1045): Access denied for user 'finder'@'localhost' (using password: YES) in D:\xampp\htdocs\finder\install\index.php on line 48
Error: Unable to connect to mysql server.

I have mad sure all is upper case, have selected all priv's

If I put the script on a cpanel server everything works, but not on xampp, now I am fully aware most of you uses root and no password
but I dont want to...

Any pointers would be grateful, seems a shame to scrap xampp and stay with a real server... it must be something silly I am doing

All the best from Alan

Making a social media site using PHP/MySQL.

Have made the register/login system, the frontend design of the site (including header included on every page) and a newsfeed where posts can be written.

Have now started the comment section option. Trying to post a link of a username ([firstname]_[lastname]) which was set when the user registers. It links to a profile page for that user.

Onclick, nothing happens. Right click-> open in new tab -> and this error appears:

Access forbidden!
You don't have permission to access the requested object. It is either read-protected or not readable by the server.

If you think this is a server error, please contact the webmaster.

Error 403
localhost
Apache/2.4.33 (Win32) OpenSSL/1.1.0h PHP/7.2.5

Tried editing the Xampp httpd.conf file, changing the "Require all granted" to Require none" and back. No change.

Here's my httpd.conf file:

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.
#
ServerRoot "I:/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 md_module modules/mod_md.so
#LoadModule macro_module modules/mod_macro.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_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 "I:/xampp/htdocs"
<Directory "I:/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/ "I:/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>

#
# "I:/xampp/cgi-bin" should be changed to whatever your ScriptAliased
# CGI directory exists, if you have that configured.
#
<Directory "I:/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>


I have xammp installed, apache and mysql on my server, installed as a windows service. I have loaded some data into the database, and wrote a new index page to serve up the data, depending on user input to the page. Kind of a search page for data on a part number input, I work for a manufacturer, you enter a part number on the page, the page loads the part's description, drawing number, etc. The page also builds a link to the pdf drawing file of the part number. This pdf sits outside the htdocs folder, it is on the same letter drive, but not in the same install directory of xampp. When I try the link, I get the 403 access error. How do I get xampp to serve the pdf drawing file?

Things I have tried: editing config files changing some allow overrides and require all. I did restart xammp after this but not the entire server. I am still getting the access denied 403 error.

First, is it possible to do what I need (serve up a pdf from outside the root). If it is possible.....how? Am I on the right track or not?

I was going to include a picture of the directory structure, but it appears you can't upload a picture directly to the forums? You have to upload it to your own website and link it here......bummer.

Thanks for your help.

Hello,

mysql Ver 15.1 Distrib 10.1.30-MariaDB

I set a password for mysql directly through PHPMyAdmin. And then PHPMyAdmin, saying:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

Hello fellow people.

I'm an MySQL noob in general, and I wanted to protect my database using a password. So, I generated a password and saved it, and right after I reloaded (after I clicked Save Password in MyPhPAdmin) myPhPAdmin said: Access denied for user 'root@localhost' (USING PASSWORD: NO).

Generally, I freaked out. I was going to MySQL's config in XAMPP and setting up the client password to be the same as the database's password, but it did not work. I'm getting this error message while trying to access my MySQL database through: localhost/phpmyadmin. How can I enter my password, exactly?

Hello,

I set a password for mysql directly through PHPMyAdmin. This caused me to no longer be able to access PHPMyAdmin, saying:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

I then searched on google and found that to allows access, I need to change the config.inc.php file. However, I do not have permission to do so. I then searched how to gain permission. To do this, the web says to use console commands to first reach the root path. For example, this path:

/Applications/XAMPP/xamppfiles/xampp

I get the error that this path does not exist.


It seems this path simply does not exist on my mac. I can follow to Applications/XAMPP.app, but it ends there. My question is, how can I change my password again or change config.inc.php so I can access PHPMyadmin.


I have been searching for four hours already for solutions, and am totally stuck.
Thanks for your help,

Good evening,
my PC's Xampp phpMyAdmin fails to access MySQL.

This is the message that appears on the browser when loading localhost / phpMyAdmin:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

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

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

Do I have to reconfigure the configuration file?

Please ask your help on how to solve this problem
thanks for your attention
regards