Guide: How to Install phpMyAdmin

vbgunz · 2003-02-10T16:45:17+00:00

Introduction phpMyAdmin is a super fantastic front end php script to the popular MySQL database server. It makes administrating your databases a whole lot ea...

Xanathos

Hello, I am a novice to this and I just got this consistent problem. Everytime I try to get to phpMyAdmin, everything seems fine, but it keep giving me this error:
Security Alert! The PHP CGI cannot be accessed directly.
This PHP CGI binary was compiled with force-cgi-redirect enabled. This means that a page will only be served up if the REDIRECT_STATUS CGI variable is set, e.g. via an Apache Action directive.
could someone help!!!

funkpirate

Hey, im running Linux. I did everything so far, except when i get to the http://localhost/phpMyAdmin....... its just a directory listing. I tried opening "main.php" and it gave me an "Error 500, Internal Server Error". Any ideas?

k1ll3rdr4g0n

Is it in a folder called scripts outside your htdocs?

funkpirate

Yes, it is. I can view html files from the directory but not a php file...

k1ll3rdr4g0n

Do you have PHP installed?

funkpirate

Yap. "which php" yields "usr/bin/php". Interperter set to "usr/bin/php", associated extension = "php", auto update = "yes". CGI enviroment = "REDIRECT_STATUS", value = 200. And then I set up the alias....

k1ll3rdr4g0n

A. Why are you using usr/bin/php and B. You need to tell the abyss the excat file name so itll be like c:\PHP\cgi-php.exe

funkpirate

I am running linux mate....... not windows.

k1ll3rdr4g0n

Im sorry shouldve read....my mind is mush ever since school has started.

funkpirate

Hey, im using windows now. Got phpmyadmin to work, but everytime i click a link in phpadmin, it takes me to some microsoft page. Anyone know what could cause this?

k1ll3rdr4g0n

Yeah, i had gotten that to (rereads) ok your using windows XD this means that you do not have phpMyAdmin setup correctly are you accessing via localhost or remotely?

funkpirate

I believe I am accesing it remotley I believe.... I am not using the amind console thing from abyssws if thats what you mean.

k1ll3rdr4g0n

are you going http://localhost/phpmyadmin or http://yourip/phpmyadmin gawd i wish someone else would come on because im starting to get sleepy.....

funkpirate

http://myip/phpMyAdmin.

k1ll3rdr4g0n

I had a feeling that was it.....
open config_inc.php and look for:
$cfg['PmaAbsoluteUri'] = 'http://yourip/phpMyAdmin';
$cfg['Servers'][$i]['host'] = 'ipofmyslqserver' ;
change them accordinally and save it,

idiosyncrasy

Okay, I did a really silly thing - I accidentally deleted all the users in the privileges section. Now everything is messed up because I used phpMyAdmin to install phpbb. Here's what I have now:

I can't create any new privileges or databases. I've tried deleting the phpMyAdmin folder and unzipping it into the scripts folder again but I'm still having the same problem.
Note: Everything was working fine before ... until I deleted all the users by accident.

mobrien

Whenever I try to run phpMyAdmin I get this error. I installed php5.0.2, does this not come with the mySQL extensions? or am I missing something?
error:
"
cannot load mysql extension,
please check PHP Configuration
Documentation
"
thanks in advance

Foxified

Mobrien,
PHPMYADMIN is a control panel for MYSQL, and php is just a scripting Type which the control panel works on, YOU NEED MYSQL installed
http://www.mysql.net
I suggest you visit this Site
http://www.trustabyss.com
go to the tutorials, and follow the Installation steps with pictures, it should be pretty basic, skip what you have done, double check, if you need any more help after you exhausted this site, please feel free to post here again, as im sortve busy at the moment doing specific stuff, take a look, also welcome to the forum..
idiosyncrasy,
go to the config inside the MYSQL Bin, delete the login/password set there, or set up your own manually.

mobrien

Right, I understand all that. I have scripted in perl, php, java, and written many c and c++ programs. I, however, have never used mySQL, or any database for that matter. I also am not familiar with any required libraries to implement MySQL in PHP.
I have an installed version of mySQL, it's the extensions it's claiming are not installed. That's supposed to be a part of PHP as far as I know. Also I noticed that it says "please check PHP configuration", not that this isn't a problem with the MySQL library, but I suspect it has something to do with the configuration of PHP, or the fact that i'm using PHP5.
Anybody?

mobrien

Wow, i feel stupid, the answer was already in the thread (didn't realize there was more than one page). Sorry for wasting everybody's time. I'm sure it'll work from here on out. By the way, the tutorials are great and you guys are definately on the ball with this admin script. I'm sure it'll be great for an SQL newbie like me.
Cheers.

« Previous Page Next Page »