How to manage the MySQL database using phpMyAdmin: Difference between revisions
imported>Franklin m (How to manage the MySQL database using phpMyAdmin) |
imported>Franklin m (phpMyAdmin guide) |
||
Line 1: | Line 1: | ||
== | __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 zip 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\''' | |||
#*Note: Final folder structure is '''\\synologyserver\web\phpMyAdmin''' | |||
#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''' | |||
|| | |||
|-<!----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> | |||
|| | |||
|-<!----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 priledges once again, it is recommended to change the password of '''root@SynologyServer''' | |||
||[[Image:phpMyAdmin09.gif|150px|left]] | |||
|} | |||
==Further Reading== | |||
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] |
Revision as of 03:45, 9 December 2007
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
- Download phpMyAdmin
- Decompress the zip 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\
- Note: Final folder structure is \\synologyserver\web\phpMyAdmin
- Point a web-browser to http://synologyserver/phpmyadmin/
- The finished result
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 |
|
Step 2:Note the selected user, this password will need to be secured. Click on the edit key, denoted by the arrow. |
|
Step 3:Locate the password field, update the password field. Once finished, click on the "Go" button the right hand side of the form. |
|
Step 4:Password successfully changed for root@localhost |
|
Step 5:Click on the Home key to refresh the phpMyAdmin Windows |
|
Step 6:phpMyAdmin will display error 1045, this is normal and proceed to the next portion of this guide |
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 |
|
Step 2:Create a backup copy of config.default.php, name it config.default.php.bak for example |
|
Step 3:Open config.default.php in Notepad++ or Windows WordPad, or another advanced text editor. |
|
Step 4:Browse to line 144, where it contains
|
|
Step 5:Change that line to reflect the following
|
|
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 |
|
Step 7:After logging in and viewing the priledges once again, it is recommended to change the password of root@SynologyServer |
Further Reading
For more advanced information on using phpMyAdmin, please refer to the following links