Editing How to manage the MySQL database using phpMyAdmin

__NOTOC__
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 [[How to Host a Website with the Synology Server|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==
#Download [http://www.phpmyadmin.net/ phpMyAdmin]
#Decompress the file to reveal the program folder
#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.
#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.
#<font color=red>Attention! In phpMyAdmin > 3.1.0 the root-access with no password, that is used by Synology, is permitted by default.</font> <br>To allow a root access without Password, you need to have the line "$cfg['Servers'][$i]['AllowNoPasswordRoot'] = TRUE;" in your config.inc.php.
#Point a web-browser to '''<nowiki>http://synologyserver/phpMyAdmin/</nowiki>'''
#The finished result
::[[Image:phpMyAdmin01.gif|150px|left]]
<br><br><br><br>

==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.

{| border="0" cellpadding="0" style="text-align:left"
|-
!width="1000"|
!|<!----Second column here---->
|-<!----Begin Row---->
|
===Step 1:===
Login to phpMyAdmin and click on Privileges
||[[Image:phpMyAdmin02.gif|150px|left]]

|-<!----Begin Row---->
|
===Step 2:===
Note the selected user, this password will need to be secured. Click on the edit key, denoted by the arrow.
||[[Image:phpMyAdmin03.gif|150px|left]]

|-<!----Begin Row---->
|
===Step 3:===
Locate the password field, update the password field. Once finished, click on the "Go" button the right hand side of the form.
||[[Image:phpMyAdmin04.gif|150px|left]]

|-<!----Begin Row---->
|
===Step 4:===
Password successfully changed for '''root@localhost'''
||[[Image:phpMyAdmin05.gif|150px|left]]

|-<!----Begin Row---->
|
===Step 5:===
Click on the ''Home'' key to refresh the phpMyAdmin Windows
||[[Image:phpMyAdmin06.gif|150px|left]]

|-<!----Begin Row---->
|
===Step 6:===
phpMyAdmin will display error 1045, this is normal and proceed to the next portion of this guide
||[[Image:phpMyAdmin07.gif|150px|left]]
|}


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

{| border="0" cellpadding="0" style="text-align:left"
|-
!width="1000"|
!|<!----Second column here---->
|-<!----Begin Row---->
|
===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.
||
|-<!----Begin Row---->
|
===Step 2:===
Create a backup copy of '''config.default.php''', name it '''config.default.php.bak''' for example
||
|-<!----Begin Row---->
|
===Step 3:===
Open '''config.default.php''' in [http://notepad-plus.sourceforge.net/uk/site.htm Notepad++] or Windows WordPad, or another ''advanced'' text editor.<br>It is not recommended to use Windows Notepad, as this program has the probability of corrupting the php file.
||
|-<!----Begin Row---->
|
===Step 4:===
Browse to line 144, where it contains
:<pre>$cfg['Servers'][$i]['auth_type'] = 'config';</pre>
*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.
||
|-<!----Begin Row---->
|
===Step 5:===
Change that line to reflect the following
:<pre>$cfg['Servers'][$i]['auth_type'] = 'http';</pre>
||
|-<!----Begin Row---->
|
===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''
||[[Image:phpMyAdmin08.gif|150px|left]]
|-<!----Begin Row---->
|
===Step 7:===
After logging in and viewing the privileges once again, it is recommended to change the password of '''root@SynologyServer'''
||[[Image:phpMyAdmin09.gif|150px|left]]
|}

==Notes==
phpMyAdmin also features a setup script, which can be used to perform initial setup, it can be accessed here: '''<nowiki>http://synologyserver/phpmyadmin/scripts/setup.php</nowiki>'''
<br>For more advanced information on using phpMyAdmin, please refer to the following links
*[http://www.phpmyadmin.net/home_page/docs.php phpMyAdmin Documentation]
*[http://wiki.cihar.com/pma/Welcome_to_phpMyAdmin_Wiki phpMyAdmin Wiki]