Difference between revisions of "Web app PhpMyAdmin"

(Created page with "Category:Linux PhpLdapAdmin allows to manage a MySQL database through a web-user interface. There are different ways to setup PhpMyAdmin. The easiest one is to use the ...")
 
 
Line 25: Line 25:
 
Reply to the following questions:
 
Reply to the following questions:
 
* Use dbconfig-common? '''YES'''
 
* Use dbconfig-common? '''YES'''
* Database type? '''mysql'''
 
 
* Database's administrative user's password? '''root password'''
 
* Database's administrative user's password? '''root password'''
 
* Application's password? '''new password'''
 
* Application's password? '''new password'''
 
* Setup web server? '''YES'''
 
* Setup web server? '''YES'''
 
* What is your web server? '''Apache2'''
 
* What is your web server? '''Apache2'''
 +
 +
 +
 +
=Alias and access restriction=
 +
 +
It's always good to restrict the access of such a tool. You can configure the alias over here:
 +
 +
<syntaxhighlight lang="bash">
 +
vim /etc/phpmyadmin/apache.conf
 +
</syntaxhighlight>
 +
 +
  
 
=Use it=
 
=Use it=
  
 
go to https://myserver/phpmyadmin
 
go to https://myserver/phpmyadmin

Latest revision as of 11:07, 12 August 2014


PhpLdapAdmin allows to manage a MySQL database through a web-user interface.


There are different ways to setup PhpMyAdmin. The easiest one is to use the package inside your repository.


Requirements

You need both a Web server and a MySQL server


Installation

apt-get install phpmyadmin

Reply to the following questions:

  • Use dbconfig-common? YES
  • Database's administrative user's password? root password
  • Application's password? new password
  • Setup web server? YES
  • What is your web server? Apache2


Alias and access restriction

It's always good to restrict the access of such a tool. You can configure the alias over here:

vim /etc/phpmyadmin/apache.conf


Use it

go to https://myserver/phpmyadmin