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.<br>If this does not work you can use the setup script as described on the [http://www.phpmyadmin.net/documentation/#setup_script phpMyAdmin website].
#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'''. Windows users may wish to use [http://notepad-plus.sourceforge.net/uk/site.htm 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 [http://www.barebones.com/products/textwrangler TextWrangler].
||
|-<!----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]