I couldnt find the PHPMyAdmin Designer

Problems with the Windows version of XAMPP, questions, comments, and anything related.

I couldnt find the PHPMyAdmin Designer

Postby chunket » 23. September 2007 04:33

I refer to this website http://daryl.learnhouston.com/2007/05/17/phpmyadmin-and-designer-mode . It said PHPMyAdmin has a DHTML page to view the database relation but i could not find it in XAMPP. Please give some hints. thanks.
chunket
 
Posts: 5
Joined: 23. April 2007 01:53

Postby lyntuan » 23. September 2007 12:56

Start XAMPP.
Type http://localhost/phpmyadmin in browser's address bar
Last edited by lyntuan on 26. December 2008 13:52, edited 1 time in total.
AMPstart :: Launch a Portable Web Server
http://ampstart.com
----------------------------------------------------------
Please read Disclaimer section carefully before downloading
lyntuan
 
Posts: 104
Joined: 08. November 2006 00:21

Postby chunket » 23. September 2007 14:15

thanks for reply.

i have started the service but i could not see the tab or menu to display the design.

The version i downloaded is xampp-win32-1.6.3a zip archive. Is it the same with installer?

Or is there any setting in the config file?

Strange. i just couldnt find the 'Designer' tab. Please help. Thanks.
chunket
 
Posts: 5
Joined: 23. April 2007 01:53

Postby delftdamage » 23. September 2007 15:54

Go to c:/xampp/phpmyadmin/config.inc

Change these settings:

$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'password';

(don't forget to give user pma a password!)

/////////////////////////////////////////////////////////////////////////////////

Now change the names of the databases.

It is already SET to PMA_tblnames

CHANGE this to: pma_tblnames (see DEFAULT:)
(beneath are my settings:)

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; // Database used for Relation, Bookmark and PDF Features
// (see scripts/create_tables.sql)
// - leave blank for no support
// DEFAULT: 'phpmyadmin'
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; // Bookmark table
// - leave blank for no bookmark support
// DEFAULT: 'pma_bookmark'
$cfg['Servers'][$i]['relation'] = 'pma_relation'; // table to describe the relation between links (see doc)
// - leave blank for no relation-links support
// DEFAULT: 'pma_relation'
$cfg['Servers'][$i]['table_info'] = 'pma_table_info'; // table to describe the display fields
// - leave blank for no display fields support
// DEFAULT: 'pma_table_info'
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; // table to describe the tables position for the PDF schema
// - leave blank for no PDF schema support
// DEFAULT: 'pma_table_coords'
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; // table to describe pages of relationpdf
// - leave blank if you don't want to use this
// DEFAULT: 'pma_pdf_pages'
$cfg['Servers'][$i]['column_info'] = 'pma_column_info'; // table to store column information
// - leave blank for no column comments/mime types
// DEFAULT: 'pma_column_info'
$cfg['Servers'][$i]['history'] = 'pma_history'; // table to store SQL history
// - leave blank for no SQL query history
// DEFAULT: 'pma_history'
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords'; // table to store the coordinates for Designer
// - leave blank for no Designer feature
// DEFAULT: 'pma_designer_coords'

/////////////////////////////////////////////////////////////////////////

As final you must run a SQL script that you can find in:

C:/xampp/phpmyadmin/scripts/create_tables_mysql_4_1_2+.sql
simply execute this sql with the phpmyadmin import function.

NOW THE DESIGNER WILL BE AVAILABLE!!!
delftdamage
 
Posts: 30
Joined: 15. June 2007 23:56

Postby chunket » 24. September 2007 01:54

thanks. it works now.

i believe it is cause by the case sensitive of the table name.
Rename it to 'pma_blablabla' and it works. :)
chunket
 
Posts: 5
Joined: 23. April 2007 01:53

Postby delftdamage » 24. September 2007 22:42

Yes but it's better to also set a password for the pma user.
Now hackers can easily see your table design info I think.
delftdamage
 
Posts: 30
Joined: 15. June 2007 23:56


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 147 guests