Professional Web Applications Themes

Create database fail, any trap ? - MySQL

Hello, I was able to create one database named "test" but I am not able to create one named "toto" (or with any other name), any idea of what is the trap I just felt into ? [roothelen etc]# mysql -u telemak -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 199 to server version: 4.1.12 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database test; Query OK, 1 row affected (0.00 sec) mysql> create database toto; ERROR 1044 (42000): Access denied for user ...

  1. #1

    Default Create database fail, any trap ?

    Hello,

    I was able to create one database named "test" but I am not able to
    create one named "toto" (or with any other name), any idea of what is
    the trap I just felt into ?


    [roothelen etc]# mysql -u telemak -p
    Enter password:
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 199 to server version: 4.1.12

    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

    mysql> create database test;
    Query OK, 1 row affected (0.00 sec)

    mysql> create database toto;
    ERROR 1044 (42000): Access denied for user 'telemak''localhost' to
    database 'toto'
    mysql> create database test;
    ERROR 1007 (HY000): Can't create database 'test'; database exists
    mysql> drop database test;
    Query OK, 1 row affected (0.01 sec)
    mysql> create database test;
    Query OK, 1 row affected (0.00 sec)
    mysql> create database toto;
    ERROR 1044 (42000): Access denied for user 'telemak''localhost' to
    database 'toto'

    As a conclusion, I was able to create a new database nammed test and
    drop it, but can not create database with any other name :(

    Rather a "small limitation" of my config ;-)
    Ok, what did I miss in the RTFM procedure ?

    Regards,
    TM
    TestMan Guest

  2. #2

    Default Re: Create database fail, any trap ?

    Dear all,
    I am answering to myself.

    I was not able to find a reason for this so I just restarted in skip
    grant tables mode the mysql and update the passowrd of my root

    [url]http://www.alt-php-faq.org/local/70/[/url]

    This has at least unable me to create a new database :)

    Rgs,
    TM


    TestMan a écrit :
    > Hello,
    >
    > I was able to create one database named "test" but I am not able to
    > create one named "toto" (or with any other name), any idea of what is
    > the trap I just felt into ?
    >
    >
    > [roothelen etc]# mysql -u telemak -p
    > Enter password:
    > Welcome to the MySQL monitor. Commands end with ; or \g.
    > Your MySQL connection id is 199 to server version: 4.1.12
    >
    > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    >
    > mysql> create database test;
    > Query OK, 1 row affected (0.00 sec)
    >
    > mysql> create database toto;
    > ERROR 1044 (42000): Access denied for user 'telemak''localhost' to
    > database 'toto'
    > mysql> create database test;
    > ERROR 1007 (HY000): Can't create database 'test'; database exists
    > mysql> drop database test;
    > Query OK, 1 row affected (0.01 sec)
    > mysql> create database test;
    > Query OK, 1 row affected (0.00 sec)
    > mysql> create database toto;
    > ERROR 1044 (42000): Access denied for user 'telemak''localhost' to
    > database 'toto'
    >
    > As a conclusion, I was able to create a new database nammed test and
    > drop it, but can not create database with any other name :(
    >
    > Rather a "small limitation" of my config ;-)
    > Ok, what did I miss in the RTFM procedure ?
    >
    > Regards,
    > TM
    TestMan Guest

Similar Threads

  1. Question create database dynamically
    By saidujjama in forum Brainstorming Area
    Replies: 0
    Last Post: May 11th, 10:26 AM
  2. Create Database
    By lh83 in forum Coldfusion Database Access
    Replies: 0
    Last Post: February 8th, 08:15 AM
  3. Create a TIMER for a database
    By Jonathan in forum FileMaker
    Replies: 3
    Last Post: October 28th, 07:10 PM
  4. Create a Report from a Database
    By cavagnaro in forum Macromedia Dreamweaver
    Replies: 1
    Last Post: July 10th, 12:12 AM
  5. Create 9.2.0 database manually
    By santosh in forum Oracle Server
    Replies: 4
    Last Post: January 6th, 03:20 PM

Bookmarks

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 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139