How to setup phpmyadmin?
Clash Royale CLAN TAG#URR8PPP
My machine is running arch linux.
if I uncomment this line in my /etc/httpd/conf/httpd.conf :
Include conf/extra/phpmyadmin.conf
phpmyadmin takes over my document root and when I go to localhost
in my browser it just opens the phpmyadmin/index.php page and I no longer can access my projects in my DocumentRoot
but if I comment the above line in the server config, localhost
opens my DocumentRoot and I can see all the php files and directories/projects I have created.
so for now I enable phpmyadim only to do the mysql things I want to do then disable it.
My question is : how can I enable phpmyadmin without it taking over my server ?
this is the /etc/httpd/conf/extra/phpmyadmin.conf file :
<VirtualHost pma.localhost:80>
ServerAdmin phpmyadmin@apache.com
DocumentRoot "/usr/share/webapps/phpMyAdmin"
ServerName pma.localhost
ServerAlias pma.localhost
ErrorLog "/var/log/httpd/pma.localhost-error_log"
<Directory "/usr/share/webapps/phpMyAdmin">
DirectoryIndex index.html index.php
AllowOverride All
Options FollowSymlinks
Require all granted
</Directory>
</VirtualHost>
Alias /phpmyadmin "/usr/share/webapps/phpMyAdmin"
<Directory "/usr/share/webapps/phpMyAdmin">
DirectoryIndex index.php
AllowOverride All
Options FollowSymlinks
Require all granted
</Directory>
apache-httpd phpmyadmin
add a comment |
My machine is running arch linux.
if I uncomment this line in my /etc/httpd/conf/httpd.conf :
Include conf/extra/phpmyadmin.conf
phpmyadmin takes over my document root and when I go to localhost
in my browser it just opens the phpmyadmin/index.php page and I no longer can access my projects in my DocumentRoot
but if I comment the above line in the server config, localhost
opens my DocumentRoot and I can see all the php files and directories/projects I have created.
so for now I enable phpmyadim only to do the mysql things I want to do then disable it.
My question is : how can I enable phpmyadmin without it taking over my server ?
this is the /etc/httpd/conf/extra/phpmyadmin.conf file :
<VirtualHost pma.localhost:80>
ServerAdmin phpmyadmin@apache.com
DocumentRoot "/usr/share/webapps/phpMyAdmin"
ServerName pma.localhost
ServerAlias pma.localhost
ErrorLog "/var/log/httpd/pma.localhost-error_log"
<Directory "/usr/share/webapps/phpMyAdmin">
DirectoryIndex index.html index.php
AllowOverride All
Options FollowSymlinks
Require all granted
</Directory>
</VirtualHost>
Alias /phpmyadmin "/usr/share/webapps/phpMyAdmin"
<Directory "/usr/share/webapps/phpMyAdmin">
DirectoryIndex index.php
AllowOverride All
Options FollowSymlinks
Require all granted
</Directory>
apache-httpd phpmyadmin
add a comment |
My machine is running arch linux.
if I uncomment this line in my /etc/httpd/conf/httpd.conf :
Include conf/extra/phpmyadmin.conf
phpmyadmin takes over my document root and when I go to localhost
in my browser it just opens the phpmyadmin/index.php page and I no longer can access my projects in my DocumentRoot
but if I comment the above line in the server config, localhost
opens my DocumentRoot and I can see all the php files and directories/projects I have created.
so for now I enable phpmyadim only to do the mysql things I want to do then disable it.
My question is : how can I enable phpmyadmin without it taking over my server ?
this is the /etc/httpd/conf/extra/phpmyadmin.conf file :
<VirtualHost pma.localhost:80>
ServerAdmin phpmyadmin@apache.com
DocumentRoot "/usr/share/webapps/phpMyAdmin"
ServerName pma.localhost
ServerAlias pma.localhost
ErrorLog "/var/log/httpd/pma.localhost-error_log"
<Directory "/usr/share/webapps/phpMyAdmin">
DirectoryIndex index.html index.php
AllowOverride All
Options FollowSymlinks
Require all granted
</Directory>
</VirtualHost>
Alias /phpmyadmin "/usr/share/webapps/phpMyAdmin"
<Directory "/usr/share/webapps/phpMyAdmin">
DirectoryIndex index.php
AllowOverride All
Options FollowSymlinks
Require all granted
</Directory>
apache-httpd phpmyadmin
My machine is running arch linux.
if I uncomment this line in my /etc/httpd/conf/httpd.conf :
Include conf/extra/phpmyadmin.conf
phpmyadmin takes over my document root and when I go to localhost
in my browser it just opens the phpmyadmin/index.php page and I no longer can access my projects in my DocumentRoot
but if I comment the above line in the server config, localhost
opens my DocumentRoot and I can see all the php files and directories/projects I have created.
so for now I enable phpmyadim only to do the mysql things I want to do then disable it.
My question is : how can I enable phpmyadmin without it taking over my server ?
this is the /etc/httpd/conf/extra/phpmyadmin.conf file :
<VirtualHost pma.localhost:80>
ServerAdmin phpmyadmin@apache.com
DocumentRoot "/usr/share/webapps/phpMyAdmin"
ServerName pma.localhost
ServerAlias pma.localhost
ErrorLog "/var/log/httpd/pma.localhost-error_log"
<Directory "/usr/share/webapps/phpMyAdmin">
DirectoryIndex index.html index.php
AllowOverride All
Options FollowSymlinks
Require all granted
</Directory>
</VirtualHost>
Alias /phpmyadmin "/usr/share/webapps/phpMyAdmin"
<Directory "/usr/share/webapps/phpMyAdmin">
DirectoryIndex index.php
AllowOverride All
Options FollowSymlinks
Require all granted
</Directory>
apache-httpd phpmyadmin
apache-httpd phpmyadmin
edited Dec 20 '18 at 23:21
jasonwryan
49.2k14134184
49.2k14134184
asked Dec 20 '18 at 22:41
Neo Mosaid
3417
3417
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Your configuration looks strange to me but I've never worked with arch. I would suggest:
Method 1 (Reinstall):
Backup your MySQL Database!
pacman -Rns phpmyadmin
pacman -S phpmyadmin
Be sure to follow the installer steps on screen!
Method 2 (tinker with the configs):
- Setup a FQHN for this machine
- Make sure you actually setup VirtualHosts (your other projects) via
sites-available/siteXY.conf
anda2ensite siteXY.conf
- Test the configuration made in 2.) to verify you can access at least
two different sites in your browser (www.projectXY-1.intranet / www.project-XY-2.intranet) - Remove (comment or make backup before!) the
VirtualHost-Section
in
yourphpmyadmin.conf
2.) and 3.) are to make sure you the cause doesn't lie in a misconfigured apache2.
On the Arch Wiki you can also find examples how the phpmyadmin.conf
should look like and other information.
I used the configuration provided in arch wiki and its working fine . I don't know how I missed it the first time. thanks
– Neo Mosaid
Dec 21 '18 at 12:39
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f490226%2fhow-to-setup-phpmyadmin%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Your configuration looks strange to me but I've never worked with arch. I would suggest:
Method 1 (Reinstall):
Backup your MySQL Database!
pacman -Rns phpmyadmin
pacman -S phpmyadmin
Be sure to follow the installer steps on screen!
Method 2 (tinker with the configs):
- Setup a FQHN for this machine
- Make sure you actually setup VirtualHosts (your other projects) via
sites-available/siteXY.conf
anda2ensite siteXY.conf
- Test the configuration made in 2.) to verify you can access at least
two different sites in your browser (www.projectXY-1.intranet / www.project-XY-2.intranet) - Remove (comment or make backup before!) the
VirtualHost-Section
in
yourphpmyadmin.conf
2.) and 3.) are to make sure you the cause doesn't lie in a misconfigured apache2.
On the Arch Wiki you can also find examples how the phpmyadmin.conf
should look like and other information.
I used the configuration provided in arch wiki and its working fine . I don't know how I missed it the first time. thanks
– Neo Mosaid
Dec 21 '18 at 12:39
add a comment |
Your configuration looks strange to me but I've never worked with arch. I would suggest:
Method 1 (Reinstall):
Backup your MySQL Database!
pacman -Rns phpmyadmin
pacman -S phpmyadmin
Be sure to follow the installer steps on screen!
Method 2 (tinker with the configs):
- Setup a FQHN for this machine
- Make sure you actually setup VirtualHosts (your other projects) via
sites-available/siteXY.conf
anda2ensite siteXY.conf
- Test the configuration made in 2.) to verify you can access at least
two different sites in your browser (www.projectXY-1.intranet / www.project-XY-2.intranet) - Remove (comment or make backup before!) the
VirtualHost-Section
in
yourphpmyadmin.conf
2.) and 3.) are to make sure you the cause doesn't lie in a misconfigured apache2.
On the Arch Wiki you can also find examples how the phpmyadmin.conf
should look like and other information.
I used the configuration provided in arch wiki and its working fine . I don't know how I missed it the first time. thanks
– Neo Mosaid
Dec 21 '18 at 12:39
add a comment |
Your configuration looks strange to me but I've never worked with arch. I would suggest:
Method 1 (Reinstall):
Backup your MySQL Database!
pacman -Rns phpmyadmin
pacman -S phpmyadmin
Be sure to follow the installer steps on screen!
Method 2 (tinker with the configs):
- Setup a FQHN for this machine
- Make sure you actually setup VirtualHosts (your other projects) via
sites-available/siteXY.conf
anda2ensite siteXY.conf
- Test the configuration made in 2.) to verify you can access at least
two different sites in your browser (www.projectXY-1.intranet / www.project-XY-2.intranet) - Remove (comment or make backup before!) the
VirtualHost-Section
in
yourphpmyadmin.conf
2.) and 3.) are to make sure you the cause doesn't lie in a misconfigured apache2.
On the Arch Wiki you can also find examples how the phpmyadmin.conf
should look like and other information.
Your configuration looks strange to me but I've never worked with arch. I would suggest:
Method 1 (Reinstall):
Backup your MySQL Database!
pacman -Rns phpmyadmin
pacman -S phpmyadmin
Be sure to follow the installer steps on screen!
Method 2 (tinker with the configs):
- Setup a FQHN for this machine
- Make sure you actually setup VirtualHosts (your other projects) via
sites-available/siteXY.conf
anda2ensite siteXY.conf
- Test the configuration made in 2.) to verify you can access at least
two different sites in your browser (www.projectXY-1.intranet / www.project-XY-2.intranet) - Remove (comment or make backup before!) the
VirtualHost-Section
in
yourphpmyadmin.conf
2.) and 3.) are to make sure you the cause doesn't lie in a misconfigured apache2.
On the Arch Wiki you can also find examples how the phpmyadmin.conf
should look like and other information.
edited Dec 21 '18 at 0:16
kemotep
2,0313620
2,0313620
answered Dec 20 '18 at 23:20
bortran
1261
1261
I used the configuration provided in arch wiki and its working fine . I don't know how I missed it the first time. thanks
– Neo Mosaid
Dec 21 '18 at 12:39
add a comment |
I used the configuration provided in arch wiki and its working fine . I don't know how I missed it the first time. thanks
– Neo Mosaid
Dec 21 '18 at 12:39
I used the configuration provided in arch wiki and its working fine . I don't know how I missed it the first time. thanks
– Neo Mosaid
Dec 21 '18 at 12:39
I used the configuration provided in arch wiki and its working fine . I don't know how I missed it the first time. thanks
– Neo Mosaid
Dec 21 '18 at 12:39
add a comment |
Thanks for contributing an answer to Unix & Linux Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f490226%2fhow-to-setup-phpmyadmin%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown