How to manage the MySQL database using phpMyAdmin

From SynologyWiki
Jump to: navigation, search

This guide will cover how to manage the MySQL database of the Synology Server using phpMyAdmin, a free tool which can be downloaded from the Internet.

This guide assumes the following

  • That the Web Station and MySQL service are enabled on the Synology Server
  • That you are familiar with the Synology Management menu, and have experience with manipulating the security permissions of the Synology Server
  • That you are familiar with file management tasks, such as copying data from one folder to another.


Initial Setup of phpMyAdmin

  1. Download phpMyAdmin
  2. Decompress the file to reveal the program folder
  3. Rename the program folder from phpMyAdmin-2.11.2.2-all-languages-utf-8-only to phpMyAdmin
    • Note: phpMyAdmin-2.11.2.2-all-languages-utf-8-only is an example.
  4. Move phpMyAdmin to the Synology Server's Web folder, such as \\synologyserver\web\ (/Volumes/web/ on OS X)
    • Note: Final folder structure is \\synologyserver\web\phpMyAdmin on Windows, /Volumes/web/phpMyAdmin on OS X.
  5. Attention! In phpMyAdmin > 3.1.0 the root-access with no password, that is used by Synology, is permitted by default.
    To allow a root access without Password, you need to have the line "$cfg['Servers'][$i]['AllowNoPasswordRoot'] = TRUE;" in your config.inc.php.
  6. Point a web-browser to http://synologyserver/phpMyAdmin/
  7. The finished result
PhpMyAdmin01.gif





Securing the phpMyAdmin Installation

By default, phpMyAdmin does not feature a password to protect the MySQL database, this guide will aim to resolve that error.

Step 1:

Login to phpMyAdmin and click on Privileges

PhpMyAdmin02.gif

Step 2:

Note the selected user, this password will need to be secured. Click on the edit key, denoted by the arrow.

PhpMyAdmin03.gif

Step 3:

Locate the password field, update the password field. Once finished, click on the "Go" button the right hand side of the form.

PhpMyAdmin04.gif

Step 4:

Password successfully changed for root@localhost

PhpMyAdmin05.gif

Step 5:

Click on the Home key to refresh the phpMyAdmin Windows

PhpMyAdmin06.gif

Step 6:

phpMyAdmin will display error 1045, this is normal and proceed to the next portion of this guide

PhpMyAdmin07.gif


Correcting phpMyAdmin error 1045

This guide will cover updating the security permissions of phpMyAdmin to resolve error 1045

Step 1:

Browse to \\synologyserver\web\phpMyAdmin\libraries

  • Note: In version 3.3.3 it is strongly advised to edit ./phpMyAdmin/config.inc.php and not the .default. file. The line number for auth_type is 19 in this file.

Step 2:

Create a backup copy of config.default.php, name it config.default.php.bak for example

Step 3:

Open config.default.php. Windows users may wish to use Notepad++ or Windows WordPad, or another advanced text editor. It is not recommended to use Windows Notepad, as this program has the probability of corrupting the php file. Mac users can use the supplied TextEdit, the shell, or another text editor such as TextWrangler.

Step 4:

Browse to line 144, where it contains

$cfg['Servers'][$i]['auth_type'] = 'config';
  • Note, for version 2.11.9, browse to line 159. If the above string is not present, please search for it using the Editor's Search function.

Step 5:

Change that line to reflect the following

$cfg['Servers'][$i]['auth_type'] = 'http';

Step 6:

Save the config.default.php and exit the text editor. Refresh the web browser and it should present a login window. Enter the user root and the password for root

PhpMyAdmin08.gif

Step 7:

After logging in and viewing the privileges once again, it is recommended to change the password of root@SynologyServer

PhpMyAdmin09.gif

Notes

phpMyAdmin also features a setup script, which can be used to perform initial setup, it can be accessed here: http://synologyserver/phpmyadmin/scripts/setup.php
For more advanced information on using phpMyAdmin, please refer to the following links

Personal tools
Community Resources