can't access phpmyadmin mysql window after changing password for root in xampp (linux).

If you have ‌installed xampp/lampp on your linux system and changed the password for your root you will be no longer going to access your mysql window in phpmyadmin. It happens because phpmyadmin has a config file (config.inc.php) which do not update automatically after changing password for root like windows's xampp. so it will show you the following error.

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.

to fix this error you need to go to the phpmyadmin directory under the lampp/xampp

and edit the config.inc.php

$cfg['Servers'][$i]['password'] = 'yourpassword';

and its done.

posted by honeyonsys

Access htdocs root folder from another drive than installation drive in lampp/xampp in linux

To change the document root folder in lampp you need to edit /opt/lampp/etc/httpd.conf

do as follow code

# old line: DocumentRoot "/opt/lampp/htdocs"
DocumentRoot "/home/me/Dropbox/public_html"

#...etc...

# old line:

#
# Possible values for the Options directive are "None", "All",
# or any combination of:
#   Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews
# etc...


and restart your lampp/xampp

incase if it will not work then you can do one more thing

Open /opt/lampp/etc/httpd.conf change nobody and nogroup



#
# 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 nobody
Group nogroup

to your username and your group

posted by honeyonsys