PDA

View Full Version : phpmyadmin


mshirley001
9-22-05, 09:41 PM
well, i have uploaded a script, created my database/username with powweb ops and then created all the tables using the sqlinfo.sql file provided with my script.

when i run the script's control panel to login as admin or whatever for the first time it just reverts back to the login screen as if i hadnt entered anything, no errors or anything, juust resets the login fields to null.

never used mysql before. im thinking its something i didnt do with phpmyadmin. I just downloaded it and dont know anything about it. Seems to already be installed on the server here, do i need to install it on my local machine or what? help please.

Dabrowski
9-22-05, 09:59 PM
phpmyadmin is installed for our use at phpmyadmin.powweb.com. Log into that with the database server, username, and password to check that the database is installed properly.

What script did you download?

mshirley001
9-22-05, 10:27 PM
the script is a traffic exchange script, i have no idea what its called.

When i log into phpmyadmin, under database (the one i setup) it says "no permissions". I bet thats the problem but what do i do about it?

edit** it says "no privlidges"

mshirley001
9-22-05, 10:33 PM
I did something that pointed me to this....

Linked-tables infrastructure
For a whole set of new features (bookmarks, comments, SQL-history, PDF-generation, field contents transformation, etc.) you need to create a set of special tables. Those tables can be located in your own database, or in a central database for a multi-user installation (this database would then be accessed by the controluser, so no other user should have rights to it).

Please look at your scripts/ directory, where you should find a file called create_tables.sql. (If you are using a Windows server, pay special attention to FAQ 1.23).

If your MySQL server's version is 4.1.2 or later, please use create_tables_mysql_4_1_2+.sql instead, for a new installation.

If you already had this infrastructure and upgraded to MySQL 4.1.2 or later, please use upgrade_tables_mysql_4_1_2+.sql.

You can use your phpMyAdmin to create the tables for you. Please be aware that you may need special (administrator) privileges to create the database and tables, and that the script may need some tuning, depending on the database name.

After having imported the create_tables.sql file, you should specify the table names in your config.inc.php file. The directives used for that can be found in the Configuration section. You will also need to have a controluser with the proper rights to those tables (see section Using authentication modes below).