Guide: How to Install phpMyAdmin

mobrien · - Joined: 05 Oct 2004 Posts: 18

Also, on top of copying php_mysql.dll, I also had to copy libmysql.dll to the php directory, out of the php.zip. Hope this helps someone else in the future.

Thanks. you guys are great.

Umies · - Joined: 07 Oct 2004 Posts: 4

When I try and open the index.php file from my server is gives me this error

The host name is empty!
Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\Abyss Web Server\scripts\phpMyAdmin\libraries\common.lib.php:1255) in C:\Program Files\Abyss Web Server\scripts\phpMyAdmin\libraries\select_theme.lib.php on line 92

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

Fatal error: Call to undefined function: pma_dbi_get_dblist() in C:\Program Files\Abyss Web Server\scripts\phpMyAdmin\libraries\common.lib.php on line 1325

Any Help would be appreciated.

tttommeke · - Joined: 18 Apr 2004 Posts: 1

#1045 - Access denied for user 'root'@'localhost' (using password: NO)
Help how can i go back into my phpmyadmin stuff

jdwfly · - Joined: 14 Nov 2004 Posts: 1

MySQL said:

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

I'm not quite sure what this means, I have the current version of MySQL. I also have the correct password. Does anyone here know what this means?

oannes · - Joined: 19 Nov 2004 Posts: 2

Thanks to all who have contributed to this thread, but AAAARRGGGHHH

Everything installed perfectly - I thought, but all I get from script is

"No input file specified."

To make matters worse, an earlier poster had the same problem - then solved it himself WITHOUT SAYING HOW!

Can anyone help with this one? I seem to have run out of things to try!

oannes · - Joined: 19 Nov 2004 Posts: 2

taking a hint from my mysterious friend, I seem to have solved this for myself, so for anyone else with this problem,

comment out the line in php.ini which reads:

doc_root ="whatever"

in my file this is line #437

Hope this helps :)

player1 · - Joined: 29 Nov 2004 Posts: 6 Location: London

MySQL said:

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

I followed the tutorial but used phpMyAdmin 2.6.0-pl3 and everything was fine until I went to secure Mysql 4.1 via phpMyAdmin.

I set permissions: password: for Mysql and was booted out of phpMyAdmin as expected, I then changed the config to include the password.

MySQL said:

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

And it keeps saying the same thing.

I set the authentication to http to see if it liked it, it did'nt and I kept getting error 401

phpMyAdmin documentation said mysqli was the reccomended extention so, I changed config to reflect this and it still gets the hump:

cannot load mysqli extension,
please check PHP Configuration
Documentation

and I tried again by changing the host to 127.0.0.1

no joy

what have I missed?

If I am being dumb and/or there is a post out there I've missed please let me know.

Thanks - total novice who is amazed at how far I've got.
_________________
need free content feeds plz - not that i'm not looking...

leawildcat · - Joined: 04 Dec 2004 Posts: 9 Location: Texas

http://dev.mysql.com/doc/mysql/en/Old_client.html

fluff · - Joined: 10 Dec 2004 Posts: 5

Hi

I did everything said in the guide but when I try to browse to phpmyadmin I get the following message:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

I did change the root password for mysql and I also set it to localhost access only.

When browsing to localhost/phpmyadmin I get the same message :(

Thanks

thephoenix · - Joined: 12 Dec 2004 Posts: 1

At one part in the guide it says input http://localhost/phpMyAdmin i did that and it said error file not found or summit, what i do to fix this, coz i done everything else :S

tecnoboy · - Joined: 02 Jan 2005 Posts: 9

Hi, Im having a problem, when I try to access: http://localhost/phpMyAdmin
it gives me the following error: "cannot load MySQL extension, please check PHP Configuration"

I know that I need a thing called "MySQL Extension for PHP", or "mysqli", I think they are the same, were can I download this, and how should I install it ?

Please help me, thanks.

NoName · - Joined: 05 Jan 2005 Posts: 88 Location: Lawton America

I just wanted to post and say that this tutorial was great. I followed it step by step and everything worked perfect. I also followed the mySQL tutorial along with this and both worked fine for me...
_________________
-NoName
www.nonameproductions.us

Powered by Abyss Web Server

mrkill47 · - Joined: 12 Jan 2005 Posts: 17 Location: 127.0.0.1

I am about to go thru the tutorial (just done your MySQL one - excellent). I was wondering why not use the latest version of phpMyAdmin?

I am running PHP 5.0.3....

I guess I could attempt to install the latest version..How different will the installation process be, compared to your tutorial?

Thanks.
_________________
http://fnar.sytes.net <<--- Powered by Abyss :D

Portuga · - Joined: 16 Jan 2005 Posts: 16

i´ve got some problems, when i install mysql dont have the winmsql***.exe file to execute...what version i must download??could you give the direct link??

thx in advance...

P.S. Forgot this...now i can do it but when i try to enter in phpMyAdmin appears this :

what is this???
and sorry for the image size...

Moxxnixx · - Joined: 21 Jun 2003 Posts: 1226 Location: Florida

MySQL 4.1.8 is the last one to include winmysqladmin.exe. Get it here...
http://downloads.mysql.com/archives.php?p=mysql-4.1&v=4.1.8

Your screenshot has nothing to do with the above mentioned. You need to
configure PHP to load php_mysql.dll, which is only included in the zip package
of PHP. In your php.ini file, uncomment the line that says this...

Portuga · - Joined: 16 Jan 2005 Posts: 16

and where i configure that??
I have instaled that to my pc (C:\PHP) but its the same thing...i have that line in the file!!
appears the same error... i dont know what do...
please help me!!!

Moxxnixx · - Joined: 21 Jun 2003 Posts: 1226 Location: Florida

Do you have php_mysql.dll in your ext folder?
If you do, the easy way is to copy & paste it into the main folder of php.
See if that works.

Portuga · - Joined: 16 Jan 2005 Posts: 16

I do not have that folder :S

see this screenshots plz and say something...my version is 5

P.S. in IE, the /phpmyadmin folder opens like a txt folder and in the firefox doesnt open... i dont know what to do...

Moxxnixx · - Joined: 21 Jun 2003 Posts: 1226 Location: Florida

You downloaded the PHP installer.
You need to download the PHP zip package.
Then, take php_mysql.dll out of the ext folder and put it into the PHP folder.

Portuga · - Joined: 16 Jan 2005 Posts: 16

I´ve did it but its doesnt work...i dont know what to do im :S...
do you want to go to my account to see if is all ok??
I have follow the mysql, phpmyadmin and php support tutorials but this doesnt work :@

Moxxnixx · - Joined: 21 Jun 2003 Posts: 1226 Location: Florida

If you have php_mysql.dll, then it seems your php.ini file is not setup correctly.
If you want, you can email it to me so I can look at it.
Or PM me the acount to look at.

Portuga · - Joined: 16 Jan 2005 Posts: 16

PM sent...now...i beleive in you, that you can resolve my errors...and if you need to change something but dont have some things that you need...say me...

Thx...

Moxxnixx · - Joined: 21 Jun 2003 Posts: 1226 Location: Florida

Check your PM.

Portuga · - Joined: 16 Jan 2005 Posts: 16

It doesnt work :'(...in the firefox doesnt open...in the ie the php file opens like an txt file...

Moxxnixx · - Joined: 21 Jun 2003 Posts: 1226 Location: Florida

Ok, check your gmail.

Or are you talking about phpmyadmin don't work?

Portuga · - Joined: 16 Jan 2005 Posts: 16

I dont have nothing on my gmail but i will wait...

and im talk that i cannot open the php files :S ...but i will try again!

Moxxnixx · - Joined: 21 Jun 2003 Posts: 1226 Location: Florida

In your php.ini file, change...

Portuga · - Joined: 16 Jan 2005 Posts: 16

I did it!!!Yupiiiiiiiiiiiiiiiiiiiiii...
thx Moxxnixx...your help was great...thx xD

How you know i´m Portuguese?

Moxxnixx · - Joined: 21 Jun 2003 Posts: 1226 Location: Florida

The language on your site looked like Spanish, but different.
I'm happy you got it to work.:D

vhsorless · - Joined: 25 Jan 2005 Posts: 45

Hi,

I installed Abyss Web Server X1 (latest release), ActivePerl, PHP, MySQL and phpMyAdmin. I didn't have any problem until I tried to access phpMyAdmin at

http://localhost/phpMyAdmin

I got this error message:

Welcome to phpMyAdmin 2.6.1

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error

MySQL said: Documentation

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

When I setup MySQL for the first time, I entered that same password into the config file for phpMyAdmin. Auth type is set to "config".

I have my absolute URI set as: http://localhost/phpMyAdmin

I don't know why I'm getting this error. Any suggestions?

leawildcat · - Joined: 04 Dec 2004 Posts: 9 Location: Texas

http://dev.mysql.com/doc/mysql/en/Old_client.html

vhsorless · - Joined: 25 Jan 2005 Posts: 45

leawildcat · - Joined: 04 Dec 2004 Posts: 9 Location: Texas

I'm not exactly sure what they mean by upgrading the client program unless they mean upgrading your windows. Which Windows version were you installing on? The reason I think that is because I just recently set up a dual boot system. My very first attempt at installing exactly what you did yielded a multitude of problems because I was installing on Win98SE which does not really like any server program. Took me 4 days to get the bugs worked out and everything working properly and I didn't tinker beyond that point. I created the dual boot system with WinXP and installed perl, php, abyss, phpmyadmin and didn't encounter that error this time. So other than that I'm not really sure. Sorry, wish I had a better answer.

vhsorless · - Joined: 25 Jan 2005 Posts: 45

Skin Ticket · - Joined: 29 Jan 2005 Posts: 1

I got this error

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\Program Files\Abyss Web Server\htdocs\db\msaccess.php on line 55
phpBB : Critical Error

Could not connect to the database

DEBUG MODE

SQL Error : Error

I tried ever other database name also and got a message saying my server doesnt support the database selected....
This is trying to install phpBB

darksnape · - Joined: 05 Mar 2005 Posts: 1

I got this error :

Error 200
OK

--------------------------------------------------------------------------------
Abyss Web Server X1
© Aprelium Technologies - 2001-2004

vbgunz · - Joined: 02 Feb 2003 Posts: 615 Location: Florida

If you get the following error

mobileplaza · - Joined: 04 Apr 2005 Posts: 35

cheers for the guide ist worked... well 99% there

i just have trouble when accessing

http://localhost/phpMyAdmin/

i get the following error

cannot load mysql extension;
please check PHP configuration
Documentation

any ideas??

mobileplaza · - Joined: 04 Apr 2005 Posts: 35

Problem solved just had to wipe Php 5 and install php 4.3.. works a charm....

no to design me site and get a forum up.... yay!!!!

macmee · - Joined: 27 Mar 2005 Posts: 15

MySQL said: Documentation
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

That came up after I installed phpmyadmin and mysql

Please help me!

aprelium · - Joined: 22 Mar 2002 Posts: 6800

macmee,

Install our preconfigured PHP 5 package from http://www.aprelium.com/abyssws/php5win.html .
_________________
Support Team
Aprelium - http://www.aprelium.com

erix920 · - Joined: 30 Apr 2005 Posts: 8

I get this error

$cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin';
Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\Abyss Web Server\scripts\phpMyAdmin\config.inc.php:846) in C:\Program Files\Abyss Web Server\scripts\phpMyAdmin\libraries\header_http.inc.php on line 14

Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\Abyss Web Server\scripts\phpMyAdmin\config.inc.php:846) in C:\Program Files\Abyss Web Server\scripts\phpMyAdmin\libraries\header_http.inc.php on line 15

Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\Abyss Web Server\scripts\phpMyAdmin\config.inc.php:846) in C:\Program Files\Abyss Web Server\scripts\phpMyAdmin\libraries\header_http.inc.php on line 16

Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\Abyss Web Server\scripts\phpMyAdmin\config.inc.php:846) in C:\Program Files\Abyss Web Server\scripts\phpMyAdmin\libraries\header_http.inc.php on line 17

Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\Abyss Web Server\scripts\phpMyAdmin\config.inc.php:846) in C:\Program Files\Abyss Web Server\scripts\phpMyAdmin\libraries\header_http.inc.php on line 20
cannot load mysql extension;
please check PHP configuration
Documentation

Does anyone know why??

aprelium · - Joined: 22 Mar 2002 Posts: 6800

erix920,

The error is self-explicit:

erix920 · - Joined: 30 Apr 2005 Posts: 8

well nothing works anymore lol, mySQL is showing a red light somthing about ODBC not being installed when i installed it three times..... I dont get how people get this to work, or i just didnt pay attension to the directions, if anyone can simplify this, please send me an email at erix920@yahoo.com

Thankz - Eric

aprelium · - Joined: 22 Mar 2002 Posts: 6800

erix920,

The fact the MySQL red light is shown has nothing to do with PHP. It seems that you should reinstall MySQL or fix the problem that causes it to not being running correctly.
_________________
Support Team
Aprelium - http://www.aprelium.com

Tiffer · - Joined: 22 Jun 2005 Posts: 1

ok i have installed PHP, MySQL, Abyss Web Server

its all in the correct Place but when i click mysqladmin in Abyss Web Server\database\mysql\bin it opens what i think is CMD box then closes again can u please tell me why this is happening.

aprelium · - Joined: 22 Mar 2002 Posts: 6800

Tiffer,

MySQLAdmin isn't required to have MySQL run. When installing MySQL, it is better to configure it as a service. That way it will be started on boot time and remain available in the background as a service.
_________________
Support Team
Aprelium - http://www.aprelium.com

TB2 · - Joined: 18 Nov 2004 Posts: 20

Hi,

I need to run the abyss server on port 13375 instead of 80, so the url of phpMyAdmin is http://localhost:13375/phpMyAdmin/ in my case. Sry, if this problem was already solved somewhere on these pages, but on the index of phpMyAdmin none of the links work, and no images are being displayed because they are all linked to http://localhost/phpMyAdmin/.

The "Show MySQL runtime information" link e.g. points to:

http://localhost/phpMyAdmin/server_status.php?lang=en-iso-8859-1&server=1

but should point to:

http://localhost:13375/phpMyAdmin/server_status.php?lang=en-iso-8859-1&server=1

or even better to:

http://www.mydomain.com:13375/phpMyAdmin/server_status.php?lang=en-iso-8859-1&server=1

What do I have to do, to make phpMyAdmin always connect to port 13375?

Thx for your help,
TB2

/edit:
And btw it always points to the localhost, but I need it to point to mydomain.com:13375 so that I can acces phpMyAdmin also from outside and not only from the local machine...

Moxxnixx · - Joined: 21 Jun 2003 Posts: 1226 Location: Florida

TB2, you need to specify the port in your config.inc.php file.

TB2 · - Joined: 18 Nov 2004 Posts: 20

Yeah it works, thx a lot!!!
Maybe that should be mentioned in the tutorial, too, for dumb people like me...