SunQuest
 
           Database Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community Forums > Databases > Database Development
Reload this Page

Relations with tables desactivated

Discuss Relations with tables desactivated in the Database Development forum on Dev Articles.
Relations with tables desactivated Database Development forum to discuss the topics of designing, maintaining, and normalizing databases. If you have to store and retrieve data of any kind, this forum is for you.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old August 16th, 2004, 05:33 AM
Coriolan Coriolan is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Aug 2004
Location: Portugal
Posts: 5 Coriolan User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Angry Relations with tables desactivated
Hello,

1- I have running a db with sigle table which works fine from MyAdim 2.3.2 and Dreamweaver bindings.

2- I need to add another table to complement information but seems that additional characteristics to work relations between tables were desactivated.

Quote:

$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 will need to create a new db.
To use this functionality as superuser create a new database:
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']
3- Can I handdle with this without creating a new db?

Thanks
Reply With Quote
  #2  
Old August 16th, 2004, 06:59 AM
dhouston's Avatar
dhouston dhouston is offline
Contributing User
Dev Articles Beginner (1000 - 1499 posts)
  
Join Date: May 2003
Location: Tennessee
Posts: 1,355 dhouston User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Send a message via ICQ to dhouston
Did you try reading the phpMyAdmin documentation?
__________________
Please don't PM me asking for solutions outside the scope of a thread.
Keeping all responses in a thread stands to help others who come along later,
which is after all what this forum's all about.
Reply With Quote
  #3  
Old August 16th, 2004, 08:39 AM
Coriolan Coriolan is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Aug 2004
Location: Portugal
Posts: 5 Coriolan User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unhappy
Ok, read already.

1- Maybe config autenitication mode?
Quote:

'config' authentication mode:
  • This mode is the less secure one because it requires you to fill the $cfg['Servers'][$i]['user'] and $cfg['Servers'][$i]['password'] fields.
    But you don't need to setup a "controluser" here: using the $cfg['Servers'][$i]['only_db'] might be enough.
  • In the ISP FAQ section, there is an entry explaining how to protect your configuration file.
  • For additional security in this mode, you may wish to consider the Host authentication $cfg['Servers'][$i]['AllowDeny']['order'] and $cfg['Servers'][$i]['AllowDeny']['rules'] configuration directives.
2- The problem is i dont have a clue how to find MyAdim directory in my server. Can you help me? I have the following main folders:

bin; dev, etc; home; lib, sbin; tmp; usr; var. Some are empty.

3- Otherwise, what can I do to fix that authentication thing? (All aspects of MyAdmin are normaly working once I can create, edit, delete, phping the db information)...
Reply With Quote
  #4  
Old August 16th, 2004, 12:17 PM
dhouston's Avatar
dhouston dhouston is offline
Contributing User
Dev Articles Beginner (1000 - 1499 posts)
  
Join Date: May 2003
Location: Tennessee
Posts: 1,355 dhouston User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Send a message via ICQ to dhouston
When you're browsing phpMyAdmin in your Web browser, look at the URL. Scan over to the end of the domain name. Everything from this point to the end of the line is the path to phpMyAdmin, relative to your Web root. So if your phpMyAdmin is at http://www.domain.com/misc/db/phpMyAdmin/index.php, then the path to phpMyAdmin, relative to the Web root, is /misc/db/phpMyAdmin. Your Web root is the top level directory you upload html files to. So if that's /var/www (a distinct possiblity), then you'd find your configuration for phpMyAdmin at /var/www/misc/db/phpMyAdmin. Try /var/www and /var/www/html. If you can't find anything in there, try /usr/local/apache/htdocs.
Reply With Quote
  #5  
Old August 17th, 2004, 03:34 PM
Coriolan Coriolan is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Aug 2004
Location: Portugal
Posts: 5 Coriolan User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Still have no clue...

https://

ss32.shared.server-system.net:XXXXXX/webhost/services/virtualhosting/siteadmin/

and

http://
XXXXXXXXXX/MyAdmin/main.php?lang=pt-iso-XXXX-1&convcharset=&server=1&reload=1

Couldnt find any folder named "MyAdmin", or "webhost", "services", "siteadmin".

Besides,

var\www\ FAILED
var\www\html FAILED

I have the follow directories into usr\local

\bin \doc \etc \games \include \lib \libexec \sbin \share \src
Reply With Quote
  #6  
Old August 17th, 2004, 04:59 PM
Coriolan Coriolan is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Aug 2004
Location: Portugal
Posts: 5 Coriolan User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Alternatively I can ask to my web hoster the exact location of the file.

Please just tell me which file exactly we are looking for...

Many thanks, Cori
Reply With Quote
  #7  
Old August 18th, 2004, 07:07 AM
dhouston's Avatar
dhouston dhouston is offline
Contributing User
Dev Articles Beginner (1000 - 1499 posts)
  
Join Date: May 2003
Location: Tennessee
Posts: 1,355 dhouston User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Send a message via ICQ to dhouston
If this is a shared version of phpMyAdmin, you're probably not going to be able to change anything. I'd go ahead and talk to your provider about it, though. Just explain your issue and see what they can do to help out.
Reply With Quote
  #8  
Old August 21st, 2004, 06:07 AM
Coriolan Coriolan is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Aug 2004
Location: Portugal
Posts: 5 Coriolan User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
I just received a letter from the Web server staff
Quote:
I'm not sure that I completely understand your question here. We are unable to give you access to the configuration file for the phpMyAdmin copy that's bundled with your control panel. However, you are free to install your own copy of phpMyAdmin into any directory you want on your shared site and it will work just fine there as well. But I don't understand what you mean about establishing relationships between the tables. If installing your own phpMyAdmin doesn't give you what you need please let us know.

1- Where I can find a copy of My Admin? It is free?

2- What directory you recoment to place it?

Thanks.
Reply With Quote
  #9  
Old January 28th, 2005, 06:32 PM
ricco_heather ricco_heather is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Jan 2005
Location: California
Posts: 1 ricco_heather User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 49 m 54 sec
Reputation Power: 0
Quote:
Originally Posted by Coriolan
I just received a letter from the Web server staff

1- Where I can find a copy of My Admin? It is free?

2- What directory you recoment to place it?

Thanks.

As far as I know My Admin is free, and you can download a copy of it as well as see documentation for it here:
http://www.phpmyadmin.net/home_page/index.php
Reply With Quote
Reply

Viewing: Dev Articles Community Forums > Databases > Database Development > Relations with tables desactivated

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway.