+ Reply to Thread
Results 1 to 2 of 2

Thread: phpMyAdmin problem
      
   

  1. #1
    aconstas1's Avatar
    aconstas1 is offline Lieutenant Colonel
    Join Date
    Mar 2007
    Posts
    584

    Default phpMyAdmin problem

    Im installing a web calendar that is php based and requires MySQL database.

    During the installation instructions it says to create the database through phpMyAdmin. Here is the instruction:

    "On the initial phpMyAdmin page, under the "MySQL" heading, the first option should be "Create new database." Enter the name you have chosen for the database and press the "Create" button. (The default database name used by WebCalendar is "intranet".) After pressing the "Create" button, it should say: "Database <your database name here> has been created.""

    When I go into phpMyAdmin there is no create button. I see the following: Create new database:
    No Privileges

    but this is not a link or button.
    I created the database through the MySQL Account maintenance instead and added a user there.

    The next step is creating tables for the calendar database in phpMyAdmin here are the instructions:
    1. Click on the "Databases" tab at the top of the page.
    2. From the list of databases on the page, click on the name of the database that you created.
    3. Click on the "SQL" tab at the top of the page.
    4. At the bottom of the page, there is an area to upload a SQL file. Click on the "Browse" button and select the tables-mysql.sql file in the WebCalendar toplevel directory. Then, press the "Go" button.
    5. The top of the page should say "Your SQL-query has been executed successfully."
    6. You have now finished creating the WebCalendar database tables.
    After I create the database and add the user, phpMyAdmin does list the database. I select it and click the SQL tab at the top however, the page it takes me to has a Run SQL query/queries on database box with a text box and a go button. There is no Browse so that i can upload the table files.

    There is another tab that allows me to Create new table on database. It asks me for name and number of fields, but I don't know these.

    Can someone guide me to how i can upload the sql file on my pc to create the correct database tables?

    Any help is much appreciated.

  2. #2
    racefan20's Avatar
    racefan20 is offline Major General
    Join Date
    Jul 2005
    Location
    Concord, NC
    Posts
    2,339

    Default Re: phpMyAdmin problem

    Click the import tab rather than the sql tab.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49