navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

myphpadmin

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> myphpadmin
Page: [1]
 
pesty

 

Posts: 188
Joined: 7/2/2004
From: USA
Status: offline

 
myphpadmin - 7/14/2004 16:01:05   
Hi everyone,

I know myphpadmin isn't really a FP thing, but everyone here is so smart that I thought I would try here first:)

I'm trying to set up my database through ipowerweb. I'm getting this message:

quote:

Error
The additional Features for working with linked Tables have been deactivated. To find out why click here.


PMA Database ... not OK[ Documentation ]
General relation features Disabled
quote:




When I click the "click here" button: It take me to this section in phpmyadmin:


$cfg['Servers'][$i]['pmadb'] string
Starting with version 2.3.0 phpMyAdmin offers a lot of features to work with
master / foreign - tables. To use those as well as the bookmark feature you
need special tables with a predefined structure, which we explain below.
If you are the only user of this phpMyAdmin installation, you can use your
current database to store those special tables; in this case, just put your
current database name in $cfg['Servers'][$i]['pmadb'].

If you are setting up a multi-user phpMyAdmin installation, you will need to
create a new db and setup special privileges, so, as superuser:


create a new database for phpmyadmin:
CREATE DATABASE phpmyadmin;
Note that "controluser" must have SELECT, INSERT, UPDATE and DELETE privileges
on this database. Here is a query to set up those privileges (using "phpmyadmin" as
the database name, and "pma" as the controluser):
GRANT SELECT,INSERT,UPDATE,DELETE ON phpmyadmin.* to 'pma'@'localhost';
do not give any other user rights on this database.
enter the databasename in $cfg['Servers'][$i]['pmadb']



A couple of question here:

Do I need to install anything?

Does it mean I need to create a separate database? The database I have now is called pets with one table in it. I need to add more tables, but it won't accept them.

Do I need to create a database called admin?

And I want my database to allow multiple users. Does this mean I need another database for that too?

Arrrrggghhhh!

Pesty
pesty

 

Posts: 188
Joined: 7/2/2004
From: USA
Status: offline

 
RE: myphpadmin - 7/14/2004 23:08:59   
On:
quote:

[Error
The additional Features for working with linked Tables have been deactivated. To find out why click here.

/quote]



********************************************

---------------------------------------------------------------
Response (Neil P.) - 07/14/2004 05:19 PM
Dear Client

Thank you for contacting iPowerweb technical support.

Sorry for the inconvenience.
Please note that linked tables are considered to be too much of a resource drain
compared to simple queries, so we have disable linked tables features.

****************************************


Pesty

(in reply to pesty)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> myphpadmin
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts