mysql problem what does this error mean?

Discussion in 'Rebol' started by joev, Sep 22, 2011.

  1. joev

    joev New Member

    Hello,
    I am just looking at REBOL and trying to access mysql
    I got this error??
    ===================================
    connecting to: 127.0.0.1
    ** User Error: ERROR 1251 : Client does not support authentication pro
    tocol requested by server; consider upgrading MySQL client
    ** Near: db: open mysql://root:pass@127.0.0.1:3306/mysql
    ==============================================
    This the code I am using from rebol document
    Rebol[
    title: "Rebol Mini-Text Database with Visual GUI"
    author: "http://reboltutorial.com/blog/rebol-mini-text-database/"
    version: 1.0.0
    ]
    do %mysql-protocol.r
    probe first system/schemes
    db: open mysql://root:pass@127.0.0.1:3306/mysql
    insert db {
    DROP TABLE IF EXISTS products;
    CREATE TABLE products (
    name VARCHAR(100),
    version DECIMAL(2, 2),
    released DATE
    );
    INSERT INTO products VALUES ('cheyenne', '1.0', '2007-05-31');
    INSERT INTO products VALUES ('mysql', '1.1', '2007-05-01');
    }
    insert db read %setup.sql ;-- execute a big SQL file
  2. Graham

    Graham Developer Staff Member

    I was under the impression that the mysql protocol did not support multiple statements.

    I've asked doc to answer ...
  3. Graham

    Graham Developer Staff Member

    Are you using the latest version? What link did you use to download the mysql:// protocol?
  4. Graham

    Graham Developer Staff Member

  5. MaxV

    MaxV Member

    Did you downloaded the mysql driver from http://softinnov.org/rebol/mysql.shtml ? (It's the zip file on top of the page)
    Did you choose your root password for MySQL?
    For example open a console and:
    Code:
    mysql -u root
    SET PASSWORD FOR root@localhost = PASSWORD('mynewpass');
    
    Then you you should try this rebol script:
    Code:
    Rebol []
    do %mysql-protocol.r
    a: read  mysql://root:mynewpass@127.0.0.1/mysql/user
    print a
    

Share This Page