External Connection to Mysql

I got to grant privileges

 GRANT ALL PRIVILEGES ON *.* TO root@'%';  

in addition you can disable all security by editing /etc/my.cnf

 skip-grant-tables  

then you should restart mysql service

 ~ /etc/init.d/mysql restart  

or

 service mysql restart  

Read More

From Sqlite to Mysql

 sqlite3 owncloud.db .dump > dump.mycloud.sql  
 wget http://www.redmine.org/attachments/download/6239/sqlite3-to-mysql.py  
 chmod a+x sqlite3-to-mysql.py  
 cat dump.mycloud.sql | python sqlite3-to-mysql.py > owncloud.sql  

Read More