Can't Create Tables on phpmyadmin

[Paul Herrmann]

Having finally got phpmyadmin to operate, the first thing I did was to create a database. No problem there. Next I tried to add a table to said database.

This generated an Error but Mysql said : nothing.

I then tried using the sql window to "drop database secondtest" (also tried it with a semicolon and got referred to FAQ 2.8 which didn't help at all.

Finally tried the drop database button and got :

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

I have also tried to import and export databases and got similar errors, so it seems that there is a setting wrong somewhere.

Any suggestions??

[vssp]

using "myadmin" "EMS SQL" its very usefull for u

[devsusen]

Hi,

please check if ur phpmyadmin is installed correctly. If it is then u may need to refresh the page. If the page download is not completed properly this sort of error occurs with phpmyadmin.

susen

[Paul Herrmann]

using "myadmin" "EMS SQL" its very usefull for u

Hi VSS, Thanks for your response, but I'm not sure what you mean!

[Paul Herrmann]

Hi,

please check if ur phpmyadmin is installed correctly. If it is then u may need to refresh the page. If the page download is not completed properly this sort of error occurs with phpmyadmin.

susen

Thanks for your response. PHPmyadmin comes up OK and is able to create a database, so I must assume that it is correctly installed.

Refreshing the page takes me back to the localhost page

[ak1dnar]

Did you go through the wizard or Did you use the Script. if you used script POST it here.

[Paul Herrmann]

Did you go through the wizard or Did you use the Script. if you used script POST it here.

I used the script given to me by one of your associates, however I had some problems with using the cookie, so I changed to http.

here is the script

[php]
<?php

/* $Id: config.sample.i nc.php 9689 2006-11-10 20:05:49Z nijel $ */
// vim: expandtab sw=4 ts=4 sts=4:

/**
* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use scripts/setup.php
*
* All directives are explained in Documentation.h tml and on phpMyAdmin
* wiki <http://wiki.cihar.com> .
*/

/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secre t'] = '0a2bc3f68d'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/*
* Servers configuration
*/
$i = 0;

/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'http';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
/* User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'root;
// $cfg['Servers'][$i]['controlpass'] = 'herrm6';
/* Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
// $cfg['Servers'][$i]['relation'] = 'pma_relation';
// $cfg['Servers'][$i]['table_info'] = 'pma_table_info ';
// $cfg['Servers'][$i]['table_coords'] = 'pma_table_coor ds';
// $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages' ;
// $cfg['Servers'][$i]['column_info'] = 'pma_column_inf o';
// $cfg['Servers'][$i]['history'] = 'pma_history';
// $cfg['Servers'][$i]['designer_coord s'] = 'pma_designer_c oords';

/*
* End of servers configuration
*/

/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>
[/php]

[ak1dnar]

I asked for the SQL script that you used for creating Tables. I cant understand what you have posted here.

[Paul Herrmann]

I asked for the SQL script that you used for creating Tables. I cant understand what you have posted here.

Sorry about that. I first used the phpmadmin wizard, then used the script using the phpmyadmin window:

create table cars(id int,make text,model text)

I tried this both with and without the ";"

[ak1dnar]

I have tested your script in my PhpMyAdmin and its working fine.

try this if not go for a re installation of PhpMyAdmin.

CREATE TABLE `cars` (
  `id` int(11) default NULL,
  `make` text,
  `model` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

If you have already used this is the best combination of PHP,MySQL,PhpMy ADmin.Download it from this Link .

[Paul Herrmann]

Thanks for your help. I'll give it a try

[mikepaniagua]

I had the same problem using Konqueror.. I Installed Firefox and problem solved,