How to manage the MySQL database using phpMyAdmin

From wiki
Revision as of 14:02, 31 August 2012 by imported>Upinson (→‎Notes)
Jump to navigation Jump to 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





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

  • 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

Step 7:

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

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

Jasa SEO Murah Jasa SEO Jasa Google Adwords Jasa Adwords Google Adwords Sepatu Safety Sepatu Futsal Cheapes Hostgator Coupon Link Booking Televisori offerte Notebook Offerte Govr Edo Ziedo Portatile Apple RDAnet Lorks Karikatur Bisnis Modal Kecil Bisnis UKM Berita Terbaru Iklan Baris Jasa SEO Murah SEO Indonesia Konsultan SEO SEO Belajar SEO Penumbuh Rambut Kursus SEO Jam Tangan Casio Grosir Baju Bisnis Online Kerupuk Kulit Social Bookmark Kumpulan Puisi WBC Wonogiri Penumbuh Rambut Jam Tangan Murah Jam Tangan Murah Jam Tangan Casio Penumbuh Rambut Kerupuk Kulit Alat Kantor Laku.com Belanja Online Grosir Eceran Murah dan Aman Jasa SEO Model Jilbab Fine Tableware Permanent Hair Removal island investment development professional makeup artist bali private villa Rental Mobil di Jakarta Contact Lens Technology

Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta Jual Rumah Jakarta

Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman Laku.com Belanja Online Grosir Eceran Murah dan Aman