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!
==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]] |}
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