| View previous topic :: View next topic |
| Author |
Message |
vbgunz
-
Joined: 02 Feb 2003
Posts: 615
Location: Florida
|
 Posted: Sun Feb 09, 2003 10:05 pm Post subject: Guide: How to Install phpMyAdmin |
 |
|
This guide has been moved to the tutorials forum. Here is a direct link to the guide: http://www.aprelium.com/forum/viewtopic.php?t=1071
Good luck :)
_________________
Victor B. Gonzalez
http://aeonserv.com
Last edited by vbgunz on Sun Apr 13, 2003 5:37 pm; edited 3 times in total |
|
| Back to top |
       |
 |
vbgunz
-
Joined: 02 Feb 2003
Posts: 615
Location: Florida
|
| Posted: Sun Feb 09, 2003 10:23 pm Post subject: Please report errors in a reply to this post... Thank You |
|
|
This guide was put together in minor haste... Though I triple checked it for errors I at times felt very overwhelmed with it considering I am extrememly busy at the moment with plenty of work on my hands... If you find errors please post them, if you have comments, questions and or problems please post them... I will appreciate anyone also telling of their experience in following these quick guides...
Thank you for your time :)
_________________
Victor B. Gonzalez
http://aeonserv.com |
|
| Back to top |
|
|
kinjoJake
-
Joined: 08 Feb 2003
Posts: 23
|
| Posted: Tue Feb 11, 2003 2:11 am Post subject: |
|
|
There is a new version out. Will it work with your instructions?
Was getting an error with this but will try again.
In Real Path enter: "scripts/phpMyAdmin" without the quotes
 |
|
| Back to top |
|
|
vbgunz
-
Joined: 02 Feb 2003
Posts: 615
Location: Florida
|
| Posted: Tue Feb 11, 2003 2:13 am Post subject: I havent upgraded yet... |
|
|
I havent upgraded phpMyAdmin yet so chances are I'll simply make the upgrade... I am betting not much has changed as long as you go with the version for "php" files...
Thanks for letting me know about the update... I am off to get it :)
_________________
Victor B. Gonzalez
http://aeonserv.com |
|
| Back to top |
|
|
vbgunz
-
Joined: 02 Feb 2003
Posts: 615
Location: Florida
|
| Posted: Tue Feb 11, 2003 2:29 am Post subject: Thanks again! |
|
|
Thank you again KinjoJake... I just installed the latest version as according to my instructions and had not a problem with it :)
I hope you enjoy the guide and if you happen to find anything wrong with it be sure to let me know... BTW, users is no longer called users in the new version... It is now called priviledges...
Good luck Kinjo and thank you for your valuable input, it is appreciated :)
PS. Please be sure to not only password protect your databases but to also use Abyss to password protect the /phpMyAdmin directory :)
_________________
Victor B. Gonzalez
http://aeonserv.com |
|
| Back to top |
|
|
kinjoJake
-
Joined: 08 Feb 2003
Posts: 23
|
| Posted: Tue Feb 11, 2003 3:02 am Post subject: |
|
|
Is this what gets put exactly into IE.
http://localhost/phpMyAdmin
OR
http://localhost:port/phpMyAdmin
Because i'm getting a page cannot be displayed.
Just needed the port. My cable co. blocks port 80 so i have to use another one.
I'm am now getting an [Index of /phpMyAdmin/] at that address? I think something is wrong here.
When you installed the new version did you install over or was it a clean install?
Thanks!
Last edited by kinjoJake on Tue Feb 11, 2003 3:34 am; edited 1 time in total |
|
| Back to top |
|
|
vbgunz
-
Joined: 02 Feb 2003
Posts: 615
Location: Florida
|
| Posted: Tue Feb 11, 2003 3:32 am Post subject: |
|
|
I thought it would be obvious but I should have thrown that in. Yes if you use another port other than 80 the address would be http://localhost:port/phpMyAdmin
| Quote: | | Just needed the port. My cable co. blocks port 80 so i have to use another one. |
Even if your cable complany blocks access to port 80 unless you change it in the Abyss console you should still be able to access phpMyAdmin using http://localhost/phpMyAdmin
| Quote: | | I'm am now getting an [Index of /phpMyAdmin/] at that address? |
If when you unzipped phpMyAdmin you went into it one level deep and renamed phpMyAdmin-2.4.0-rc1-php to phpMyAdmin and dragged it into your scripts folder directly inside your Abyss program root directory (not htdocs) theirs only one matter left... Doube check your aliases...
| Quote: | | Do I go to the access control panel to password protect database and scripts? |
First you have to make sure you're not accessing some directory while trying to access phpMyAdmin... When you go to http://localhost:port/phpMyAdmin the phpMyAdmin control panel is supposed to come up not a directory...
phpMyAdmin - password protect your databases - scripts Iam not sure but do not think so...
Abyss - password protect your phpMyAdmin directory...
| Quote: | | When you installed the new version did you install over or was it a clean install? |
Clean install... I usually do not like to upgrade unless its long and tedious and even then I fight myself to just go clean install...
I was thinking about adding the port number to the tutorial but thought I wouldn't need to... I guess I'll add that too... Thanks KinjoJake ;)
_________________
Victor B. Gonzalez
http://aeonserv.com |
|
| Back to top |
|
|
kinjoJake
-
Joined: 08 Feb 2003
Posts: 23
|
| Posted: Tue Feb 11, 2003 3:47 am Post subject: |
|
|
Sometimes i'm at the computer way to long.
Quote:
Just needed the port. My cable co. blocks port 80 so i have to use another one.
Even if your cable complany blocks access to port 80 unless you change it in the Abyss console you should still be able to access phpMyAdmin using http://localhost/phpMyAdmin
I cannot.
Quote:
I'm am now getting an [Index of /phpMyAdmin/] at that address?
If when you unzipped phpMyAdmin you went into it one level deep and renamed phpMyAdmin-2.4.0-rc1-php to phpMyAdmin and dragged it into your scripts folder directly inside your Abyss program root directory (not htdocs)
I use rar to unzip, so actually i extracted to scripts and then renamed it. I believe its working, just not right yet.
Maybe something will click when i upgrade.
|
|
| Back to top |
|
|
vbgunz
-
Joined: 02 Feb 2003
Posts: 615
Location: Florida
|
| Posted: Tue Feb 11, 2003 3:53 am Post subject: |
|
|
Ok your problem should be solved... If you unzipped directly into scripts you have to go one level deep and bring that folder one level up...
It shouldnt look like this
scripts/phpMyAdmin/phpmyAdmin
It should look like this
scripts/phpMyAdmin/cvs
scripts/phpMyAdmin/images
scripts/phpMyAdmin/lang
scripts/phpMyAdmin/...
As for the port 80 I said if you do not change it in Abyss and your cable company blocks port 80 you can still connect to it... Obviously you changed it in Abyss... :)
then yes you connect to it like you said http://localhost:port/phpmyadmin
_________________
Victor B. Gonzalez
http://aeonserv.com |
|
| Back to top |
|
|
kinjoJake
-
Joined: 08 Feb 2003
Posts: 23
|
| Posted: Tue Feb 11, 2003 4:08 am Post subject: |
|
|
I am going to continue to work on this but i'm going to stop posting as i am getting to tired to make sense anymore.
Thank you for your time and patience. |
|
| Back to top |
|
|
vbgunz
-
Joined: 02 Feb 2003
Posts: 615
Location: Florida
|
| Posted: Tue Feb 11, 2003 4:11 am Post subject: |
|
|
Cool... It isn't that hard if you follow it exactly as I detailed it... Being all the fonts in green and in courier its most likely easy to miss a detail...
Good luck :)
_________________
Victor B. Gonzalez
http://aeonserv.com |
|
| Back to top |
|
|
kinjoJake
-
Joined: 08 Feb 2003
Posts: 23
|
| Posted: Tue Feb 11, 2003 6:26 pm Post subject: |
|
|
Hi again, been working on a solution to no GUI. I'm getting a 403 [Forbidden] error, it takes my password so that must be right.
In an earlier post i mentioned a driver not found. I found this:
1.3 What is MyODBC
MyODBC 2.50 is a 32-bit ODBC Driver from MySQL AB, which is based on ODBC 2.50 specification Level 0 (with level 1 and 2 features). This is one of the most popular ODBC Driver in the open source market, used by many users to access the MySQL functionality.
1.4 What is MyODBC 3.51
. MyODBC 3.51 is a 32-bit ODBC Driver, also known as MySQL ODBC 3.51 Driver. This is a enhanced version to the existing MyODBC 2.50, with ODBC 3.5x specification level 1(complete core API + level 2 features) in order to
continue to provide all functionality of ODBC to access MySQL.
http://www.mysql.com/products/myodbc/manual.html#What_is_MyODBC_3.51
Does this look like something i am missing? or need?
|
|
| Back to top |
|
|
kinjoJake
-
Joined: 08 Feb 2003
Posts: 23
|
|
| Back to top |
|
|
vbgunz
-
Joined: 02 Feb 2003
Posts: 615
Location: Florida
|
| Posted: Tue Feb 11, 2003 7:10 pm Post subject: |
|
|
I used to use MySQLCC but don't like it very much as its hard to password protect, grant permissions, etc... The MySQL GUI is discontinued and in my opinion extremely limited and out of date...
phpMyAdmin is awesome and most scripts you come across will ask if you have it installed and if so will provide instructions on what to do with it...
I am not sure why you're getting the odbc errors... I don't seem to rely on it and wouldn't know how to fix an error I never got... Perhaps something on install could be interfering with your setup... I am not sure but hope someone could help you on that one...
If you would like a 32.exe program that I believe works with administrating MySQL as a front end its called SQLYOG and you can get it http://www.webyog.com/
I just downloaded it a day ago and played with it a bit... It looks very good and looks like you can grant permissions, change passwords, administrate users, databases but I am not to sure...
If you download it I'd sure like to know if it can really do all of that... Can you please provide feedback on it? Thanks Kinjo :)
_________________
Victor B. Gonzalez
http://aeonserv.com |
|
| Back to top |
|
|
kinjoJake
-
Joined: 08 Feb 2003
Posts: 23
|
| Posted: Tue Feb 11, 2003 7:31 pm Post subject: |
|
|
The more i learn the more confussed i get.
Any idea why i'm getting a 403[forbidden] error?
Is SQLyog the same type of program as phpMyAdmin?
|
|
| Back to top |
|
|
vbgunz
-
Joined: 02 Feb 2003
Posts: 615
Location: Florida
|
| Posted: Tue Feb 11, 2003 8:44 pm Post subject: |
|
|
SQLYOG is a 32.exe program which doesn't need any configuration to it other than installation... phpMyAdmin runs in your browser and requires configuration...
I at the moment prefer phpMyAdmin to administrate MySQL but SQLYOG looked pretty good for the few minutes I played with it...
SQLYOG is like MySQLCC or MySQLGUI but in my opinion better and up to date... Check it out and if it suits you tell me more about it, I am interested in it...
Until then though I am using and do at the moment prefer phpMyAdmin...
403 errors I am not sure of... I cannot explain to you why you're getting it as I do not even know what error 403 forbidden means... It probably means something somewhere along the lines is not configured correctly...
Just make sure you edited the correct phpMyAdmin document "config.inc.php" line 39
Make sure you input into it the correct address along with the port... Also make sure your alias is correct and not misspelled or anything...
Make sure your phpMyAdmin folder inside the scripts folder is correct...
it shouldn't read phpmyadmin/phpmyadmin
it shouldn't read phpMyAdmin-2.4.0-rc1-php/phpmyadmin
it shouldn't read phpMyAdmin/phpmyadmin-2.4.0-rc1-php
It should read Abyss Web Server/scripts/phpmyadmin/index.php
_________________
Victor B. Gonzalez
http://aeonserv.com |
|
| Back to top |
|
|
grahammm
-
Joined: 13 Apr 2003
Posts: 5
|
| Posted: Sun Apr 13, 2003 11:58 am Post subject: you are not authorised to view this page |
|
|
when i type in http://localhost/phpMyAdmin I get you are not authorieed to view this page why?
Graham |
|
| Back to top |
 |
|
vbgunz
-
Joined: 02 Feb 2003
Posts: 615
Location: Florida
|
| Posted: Sun Apr 13, 2003 5:35 pm Post subject: |
|
|
Anyone reading this, Grahammm's problem is solved. I helped him over XP remote assistance. As far as what the problem was we believe it was a corrupt php installation...
_________________
Victor B. Gonzalez
http://aeonserv.com |
|
| Back to top |
|
|
|
