SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jun 2003
    0 Post(s)
    0 Thread(s)

    Configuring PHP & MySQL PLease help!!

    I know this is simple. That's why I don't know how to do it.

    I installed PHPDev from http:\\ on my Windows XP box at home. It is PHP version 4.2.3 and includes an Apache server and MySQL. PHP is working. PHPMyAdmin version 2.3.2
    says "The additional Features for working with linked Tables have been deactivated. To find out why click here. " Clicking "here" brings up the text below.

    I am instructed to run a query. I don't know, however, against what it should be run. There are no tables in the database, myphpadmin, that I am to create. The distribution includes a user table and a couple of test tables. I'll be glad to send or post the ini files, screenshots, or whatever. I've tried changing the values in the config file to what I think the program wants but I'm having no luck and getting a very bad headache.

    Thank you very, very much

    $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'] "

  2. #2
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    0 Post(s)
    0 Thread(s)
    You can just ignore that, unless you want to use the more advanced features of the program

    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts