[Opret bruger] Hvad er der nu galt?

Ups nej det var denne fejl...
You have an error in your SQL syntax near \'\'aske-maske\'.* TO aske-maske @ \'%\' IDENTIFIED BY \'6061\'\' at line 1

Det er ikke lovligt at bruge - og _ når man opretter brugere til en mysqldatabase.

Jo fordi når jeg opretter en bruger i mysql via phpmyadmin, eller mysql(lin) så virker den fint når der er \"-\" i navnet

mysql_query( \"GRANT USAGE ON $newuser\" . \".* TO $newuser\" .@% IDENTIFIED BY \'$newpass\'\") or die(mysql_error());

Giver jo bare en Parse error

My bad:

mysql_query( \"GRANT USAGE ON $newuser\" . \".* TO $newuser\" . \"@% IDENTIFIED BY \'$newpass\'\") or die(mysql_error());

Stadig fejl..
You have an error in your SQL syntax near \'-maske.* TO aske-maske@% IDENTIFIED BY \'6061\'\' at line 1

Ok det forstår jeg ikke, prøv:

mysql_query( \"GRANT USAGE ON \'$newuser\" . \".*\' TO \'$newuser\" . \"@%\' IDENTIFIED BY \'$newpass\'\") or die(mysql_error());

You have an error in your SQL syntax near \'\'aske-maske.*\' TO \'aske-maske@%\' IDENTIFIED BY \'6061\'\' at line 1

/* ----------------------- Set of misc functions ----------------------- */

    /**
    * Adds backquotes on both sides of a database, table or field name.
    * Since MySQL 3.23.6 this allows to use non-alphanumeric characters in
    * these names.
    *
    * @param  string  the database, table or field name to \"backquote\"
    * @param  boolean  a flag to bypass this function (used by dump functions)
    *
    * @return  string  the \"backquoted\" database, table or field name if the
    *                  current MySQL release is >= 3.23.6, the original one
    *                  else
    */
    function backquote($a_name, $do_it = TRUE)
    {
        if ($do_it
            && MYSQL_INT_VERSION >= 32306
            && !empty($a_name) && $a_name != \'*\') {
            return \'`\' . $a_name . \'`\';
        } else {
            return $a_name;
        }
    } // end of the \'backquote()\' function


Har selv fået det til at virke... :o)

heheh kewl