Editing
How to manage the MySQL database using phpMyAdmin
(section)
Jump to navigation
Jump to search
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
==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]] |}
Summary:
Please note that all contributions to wiki may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see
Wiki:Copyrights
for details).
Do not submit copyrighted work without permission!
Cancel
Editing help
(opens in new window)
Navigation menu
Personal tools
Not logged in
Talk
Contributions
Log in
Namespaces
Page
Discussion
British English
Views
Read
Edit
View history
More
Search
Navigation
Main page
Recent changes
Random page
Help about MediaWiki
Tools
What links here
Related changes
Special pages
Page information