#14 No Create Database Button

closed
5
2002-02-05
2001-12-28
Steve Bassi
No

There is no create database button

I am running phpMyAdmin 2.2.2 on 2 different Cobalt
RAQ3 Servers, using apache 1.3.06 and PHP 4.0.6 and
apache 1.3.20 and PHP 4.1.0 respectively.

I have edited config.php to include the correct url
and advance auth as folows:

$cfgPmaAbsoluteUri
= 'http://www.mdomain/sql/phpmyadmin/';
$cfgServers[1]['host'] = 'localhost';
$cfgServers[1]['port'] = '';
$cfgServers[1]['socket'] = '';
$cfgServers[1]['connect_type'] = 'socket';
$cfgServers[1]['stduser'] = 'mysql';
$cfgServers[1]['stdpass'] = '';
$cfgServers[1]['adv_auth'] = 'TRUE';
$cfgServers[1]['user'] = 'root';
$cfgServers[1]['password'] = '';
$cfgServers[1]['only_db'] = '';
$cfgServers[1]['verbose'] = '';
$cfgServers[1]['bookmarkdb'] = '';
$cfgServers[1]['bookmarktable'] = '';

When I call up http://www.mdomain/sql/phpmyadmin and
login as root I get:
Welcome to phpMyAdmin 2.2.2
MySQL 3.23.44 running on localhost as root@localhost
MySQL
Show MySQL runtime information [Documentation]
Show MySQL system variables [Documentation]
Users [Documentation]
Databases statistics
Log out (*)

In the left frame I get:
Home
+ mysql (6)
+ test (1)

Priviledges for ROOT are as follows:
Select Insert Update Delete Create Drop Reload
Shutdown Process File Grant References Index Alter

If I try and run
Http://www.mdomain/sql/phpmyadmin/db_create.php?
lang=en&server=1
I get the following error:
Error
SQL-query :
CREATE DATABASE
MySQL said:
You have an error in your SQL syntax near '' at line 1

Please can you tell me what I am doing wrong ?
and why I can not get a create database button ?

I have seen several people ask this same question and
can find no replies or solutions.

Many thanks

Steve Bassi

Discussion

  • Loïc Chapeaux

    Loïc Chapeaux - 2001-12-29

    Logged In: YES
    user_id=144058

    Hi Steve!

    Please give a try to the last cvs version: we've fixed such
    kind of problems with the database creation box a few weeks
    ago.

    Loc

     
  • Loïc Chapeaux

    Loïc Chapeaux - 2001-12-29
    • assigned_to: nobody --> loic1
     
  • Wendy

    Wendy - 2002-01-14

    Logged In: YES
    user_id=426605

    Hello:

    I'm having the same problem and I don't understand what the
    followup reply says to do to fix it. Help please?

    -Wendy

     
  • Loïc Chapeaux

    Loïc Chapeaux - 2002-01-16

    Logged In: YES
    user_id=144058

    Hi !

    Do you face the problem with the last phpMyAdmin revision?

    Loc

     
  • Loïc Chapeaux

    Loïc Chapeaux - 2002-02-05
    • status: open --> closed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks