Guide: How to Install phpMyAdmin

vbgunz

Introduction
phpMyAdmin is a super fantastic front end php script to the popular
MySQL database server. It makes administrating your databases a whole
lot easier. You can find out more about phpMyAdmin at
http://www.phpmyadmin.net
Requirements
1. phpMyAdmin
2. Abyss Web Server
3. MySQL
4. phpedit
5. WinZIP
Please Note:
1. You do not need phpedit to edit anything... You can use your favorite
editor in replace of... But if all you have is notepad you'll thank me
for it and its free...
2. Make double sure MySQL is already running and has a green light and is
ready to serve and make sure Abyss is running without a hitch...
Installation Step One
Download any of the phpMyAdmin 2.4.0 packages...(php, not php3)
1. Create a new folder called scripts in your Abyss program root
directory...
2. Unpackage phpMyAdmin 2.4.0 and go one level deep...
3. Rename the last phpMyAdmin 2.4.0 folder to phpMyAdmin... Drag that
folder into the scripts folder located in the Abyss program root
directory...
================================
Installation Step Two
1. Right click Abyss in the system tray > Show Console > Server
Configuration > Advanced > Aliases > Add...
2. In Virtual Path enter: "/phpMyAdmin" without the quotes
3. In Real Path enter: "scripts/phpMyAdmin" without the quotes
================================
Note:
Now all that is left is to edit one file before you can access the
page live...
Installation Step Three
Navigate to your scripts/phpMyAdmin directory and open up
config.inc.php (This is the only file you need to edit)
1. line 39: $cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin';
Save the config.inc.php file but leave it open...
Please Note:
If you never password protected MySQL copy the URL you put into
line 39: and paste that into your browser > click go > Congratulations!
If you did at one point password protect the root user you might have
to edit lines 74 and 75 (user and password), save your file and now
you should be able to access phpMyAdmin...
Here is an example of how lines 74 and 75 might look after changing
the values...
74. $cfg['Servers'][$i]['user'] = 'root';
75. $cfg['Servers'][$i]['password'] = 'password';
For new users chances are on your first login you'll see the following
in red...
"Your configuration file contains settings (root with no password)
that correspond to the default MySQL privileged account. Your MySQL
server is running with this default, is open to intrusion, and you
really should fix this security hole."
Don't worry now you have the GUI to easily password protect your
MySQL... Go to Privileges and edit each user on the list and assign each
user a password...
Now if after assigning passwords to each user you happen to get locked
out of accessing phpMyAdmin don't worry... go back into config.inc.php
and edit lines 74 and 75 and enter the correct values...
We'll that's it I hope you got phpMyAdmin working 🙂
TIP 1: It is a wise idea to use Abyss to password protect the phpMyAdmin
directory...
TIP 2: you can use your global IP address and reach your phpMyAdmin
from any where in the world but if you do remember tip 1.

DLashley

Great tutorial! 😃
I followed your instructions, but I'm getting this error on the main page of "phpMyAdmin" when I go to it:

MySQL 3.23.55-max-debug running on localhost as root@localhost

I'm sure it shouldn't be in debug mode! How do I fix this?

vbgunz

Sorry, we encountered an error while displaying this content. If you're a user, please try again later. If you're an administrator, take a look in your Flarum log files for more information.

eyal067

What I should change on lines 72 and 73 ?
what written lines ?
it writes me


Access denied for user: 'root@127.0.0.1' (Using password: NO)

Why?

eyal067

how i do password for my phpmyadmin on web????

vbgunz

Starting from the 7th paragraph from the bottom should help to answer your question.
Use phpMyAdmin to password protect MySQL
Use Abyss to password protect the phpMyAdmin directory
Good luck 🙂

eyal067

Thank you very much very on the help you are a genius

WhiteDevil

well i wouldnt quite go that far 😛

vbgunz

Thanks 😉

Bluedog

Hey Victor:
"
Was This Guide Helpful?
Yes - It Was Helpful
No - But Helpful
No - I've got problems
Other
"
Was this guide helpful? No, but helpful....
🙂

vbgunz

hehe, you are the man ok... leave me alone 🙂

datwig

Anyone home? Err... I got a different version of phpMyAdmin and it says

Notice: Undefined index: user in C:\Program Files\Abyss Web Server\scripts\phpMyAdmin\libraries\common.lib.php on line 834

Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\Abyss Web Server\scripts\phpMyAdmin\libraries\common.lib.php:834) in C:\Program Files\Abyss Web Server\scripts\phpMyAdmin\index.php on line 43

Can you help me?

vbgunz

I'd love to you help you out datwig but I am not sure where the problem exist. You can feel free to send me the config.inc.php file... Just remove only the user and password, but try leaving everything else untouched...
You can reach me at any of my instant messengers and email me your copy of the config at webserver2003xp @ vbgunz.com
Unfortunately I am now wiz at phpMyAdmin and have only originally written it to jump start others into it... Though this guide is for 2.3.3 and 2.4.0 is out not much has changed at all... All the same rules apply. All that might be different which you should consider are the line numbers found within the config.inc.php file... They might be off by two lines...
Be good, send me the file, if you solve it let us know what the problem was. Good luck 🙂

vbgunz

This new layout is to be applied to the latest version of phpMyAdmin 2.4.0 though nothing changed much in regards to upgrading from version 2.3.3...
I just re-edited the layout of the guide. I hope its easier to understand and easier on the eyes. I do plan on changing the layouts for all my guides soon enough. Thanks for all the positive emails and PMs 🙂
Hows the layout for the new guide and should new guides follow this layout or does it really matter?

IamCuRe

This new layout to the guide is much better!

Bluedog

I second that 🙂

vbgunz

Thanks fellas 🙂
I am always sort of pressed for time and lately I just got custody of my daughter back and life as a single dad can only leave you with less time.
I'll get to editing the other guides as soon as I have the time and I do have a few other guides I'll hopefully release soon enough...
I've got a question for those of you who play with bbcode a lot. Is there a more visual way to create it? Something like a wysiwyg where you can actually see it as you create it rather than having to preview it first?
Its not much of a problem but I would surely like to be able to run through it. Also an HTML to bbcode converter is cool... I found a script but can't get it to work so I am still looking... Thanks for any input on this and thanks for the cool comments so far 🙂

DLashley

VB Gunz,
How come your site keeps going to the PHP.net home page? I wanted to peek at your site. 🙂

DLashley

I find BBCode really easy to use, because it's just like HTML (for the most part) only with brackets instead of parentheses.
Plus, if you hover your cursor over the buttons right under the SUBJECT line when you go to post a message, it gives you the BBCode for the tag you want. If you click on one of the buttons, it inserts the BBCode BEGINNING tag right into your message, then you type your text, then you click the button again to make it insert the END tag.
Also, to the right underneath the Emoticons, where it says OPTIONS, then BBCode is ON/OFF - If you click on the BBCode link, a page will popup with directions on how to use BBCode.
I hope this helps you. 🙂

vbgunz wrote
Thanks fellas 🙂
I am always sort of pressed for time and lately I just got custody of my daughter back and life as a single dad can only leave you with less time.
I'll get to editing the other guides as soon as I have the time and I do have a few other guides I'll hopefully release soon enough...
I've got a question for those of you who play with bbcode a lot. Is there a more visual way to create it? Something like a wysiwyg where you can actually see it as you create it rather than having to preview it first?
Its not much of a problem but I would surely like to be able to run through it. Also an HTML to bbcode converter is cool... I found a script but can't get it to work so I am still looking... Thanks for any input on this and thanks for the cool comments so far 🙂

vbgunz

Thank you DLashley 🙂
Its not really much of a problem to do the bbcode the way I see it now, its just I am always seeking a speedier way of doing things... Thank you very much though as your answer would pretty much cover everything here 🙂
Thanks for the input, I am very grateful 😃