|
|
| Zeile 39: |
Zeile 39: |
|
| |
|
| == Werkzeuge == | | == Werkzeuge == |
| === phpMyAdmin ===
| |
|
| |
|
| Voraussetzung ist ein Apache-Webserver (siehe dazu [[Apache]])
| | [[phpMyAdmin (Ubuntu)|phpMyAdmin]] |
| | |
| ==== Installieren ====
| |
| | |
| ===== PPA =====
| |
| | |
| <pre>
| |
| sudo add-apt-repository ppa:nijel/phpmyadmin
| |
| sudo apt-get update
| |
| sudo apt-get install phpmyadmin
| |
| </pre>
| |
| | |
| ===== Tar-Ball =====
| |
| | |
| Aktuellen Downloadpfad unter [https://www.phpmyadmin.net/downloads/ https://www.phpmyadmin.net/downloads/] nachschauen.
| |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| wget https://files.phpmyadmin.net/phpMyAdmin/4.5.5.1/phpMyAdmin-4.5.5.1-all-languages.tar.gz
| |
| tar -xzvf phpMyAdmin-*.*.*.*.tar.gz
| |
| sudo mv phpMyAdmin-4.5.5.1-all-languages/ /var/www/phpmyadmin
| |
| sudo chown -R www-data:www-data /var/www/phpmyadmin/
| |
| </pre>
| |
| | |
| ==== Konfigurieren Apache ====
| |
| | |
| Konfigurationsdatei <code>/etc/apache2/conf-available/phpmyadmin.conf</code> anlegen:
| |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| sudo touch /etc/apache2/conf-available/phpmyadmin.conf
| |
| </pre>
| |
| | |
| Und folgenden Inhalt einfügen:
| |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| Alias /phpmyadmin "/var/www/phpmyadmin/"
| |
| <Directory "/var/www/phpmyadmin">
| |
| Options +FollowSymLinks
| |
| AllowOverride All
| |
| | |
| <IfModule mod_dav.c>
| |
| Dav off
| |
| </IfModule>
| |
| | |
| SetEnv HOME /var/www/phpmyadmin
| |
| SetEnv HTTP_HOME /var/www/phpmyadmin
| |
| </Directory>
| |
| </pre>
| |
| | |
| Konfiguration aktivieren:
| |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| cd /etc/apache2/conf-available/
| |
| sudo a2enconf phpmyadmin.conf
| |
| sudo service apache2 reload
| |
| </pre>
| |
| | |
| ==== Konfiguration phpMyAdmin ====
| |
| | |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| cd /var/www/phpmyadmin/
| |
| sudo cp config.sample.inc.php config.inc.php
| |
| sudo chown www-data:www-data config.inc.php
| |
| </pre>
| |
| | |
| In der Datei ''config.inc.php'' genügt es fürs Erste folgende Zeile anzupassen:
| |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| $cfg['blowfish_secret'] = 'a8b7c6d';
| |
| </pre>
| |
|
| |
|
|
| |
|
| Zurück zu [[Ubuntu]] | | Zurück zu [[Ubuntu]] |
Installation
sudo apt-get -y install mysql-server
Ubuntu-Server 16.04
sudo apt-get -y install php-mysql
Ubuntu-Server 14.04
sudo apt-get -y install php5-mysql
Netzwerkzugriff
Um auch von einem anderem Rechner auf die Datenbank zugreifen zu können, muss noch die IP-Adresse der Netzwerkschnittstelle eingestellt werden.
Dazu in der Konfigurationsdatei folgende Zeile anpassen:
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = <static IP address>
Ubuntu-Server 16.04
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
Ubuntu-Server 14.04
sudo vi /etc/mysql/my.cnf
Werkzeuge
phpMyAdmin
Zurück zu Ubuntu