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://rootass@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://rootass@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
I was under the impression that the mysql protocol did not support multiple statements. I've asked doc to answer ...
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