Rebol Tutorial

How to connect to your remote Wordpress Database from the comfort of your Desktop

rebol_mysql Have you ever dreamed to access your MySQL Database from your Desktop without having to connect to your webhosting control panel, launch your PHPMyadmin, etc. ? Now your dream comes true. But as pre-requisite, you’ll need to activate remote access for MySQL. Usually your webhosting control panel has an icon allowing you to do so. You will be asked to enter your IP Address so go here) for example and write it down.

Remote MySQL

Next download MySQL Driver for Rebol and unzip it in your rebol directory.

Now launch Rebol Console and type this command to be able to use Mysql:


do %mysql-protocol.r
;if you're too lazy to download and unzip it you can also type
;do http://reboltutorial.com/source/mysql-protocol.r

You can then try these commands :


;list your databases
read mysql://johndoe:123@72.64.23.123


;list your wordpress tables
read mysql://johndoe:123@72.64.23.123/wordpress_db


;list your wp_1_posts fields
read mysql://johndoe:123@72.64.23.123/wordpress_db/wp_1_posts


;list your published posts and copy them into the clipboard
write clipboard:// mold read/custom mysql://johndoe:123@72.64.23.123/wordpress_db ["SELECT DISTINCT post_title from wp_1_posts WHERE p
ost_status='publish'"]