[MKDoc-users] MySql prob

ruus at freenet.de ruus at freenet.de
Wed Apr 7 11:26:51 BST 2004


Hi,

i tried to insert your commands in my MySQL but they won´t work.
-------------------------------------

    INSERT INTO user (Host, User, Password) VALUES ('localhost',

    'mkdoc1', password ('mkdoc1'));

gives me error 1046. No database selected.
---------------------------------------------------------

    INSERT INTO db (Host, Db, User, Select_priv, Insert_priv,

    Update_priv, Delete_priv, Create_priv,Drop_priv, Grant_priv,

    References_priv, Index_priv, Alter_priv) VALUES ('localhost', 'mkdoc1',

    'mkdoc1', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');

gives me:


  Datenbank /mkdoc1/ auf /localhost/

*Fehler*

SQL-Befehl : 

INSERT INTO db (Host, Db, User, Select_priv, Insert_priv,
    Update_priv, Delete_priv, Create_priv,Drop_priv, Grant_priv,
    References_priv, Index_priv, Alter_priv) VALUES ('localhost', 'mkdoc1',
    'mkdoc1', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y')

MySQL meldet:

Table 'mkdoc1.db' doesn't exist

------------------------------------------
I am using Debian with MySQL 4.0.18 and testing mkcoc 1.6.23. You have tested with 3.23, but i guess that doesn´t matter.

Any ideas what is wrong?

Best regards
Gerd







More information about the MKDoc-users mailing list