Wednesday, January 6, 2016

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...

Tuesday, January 5, 2016

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...
Powered by Blogger.

Recent

Comment