Never been to CodeSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

About this user

2 total

On This Page:

  1. 1 SSH tunnel for mySQL
  2. 2 mySQL

SSH tunnel for mySQL

to mysql ssh tunnel by kenzie on Mar 07, 2007
Connect to remote mysql server via ssh tunnel:

ssh -f -L 3306:127.0.0.1:3306 username@servername.com sleep 120


Should auto-disconnect when it’s no longer in use.

mySQL

to mysql by kenzie on Mar 07, 2007
Add database user:
grant select, update, create, insert, delete on database.* to username@localhost identified by ‘password‘;


Database export:
mysqldump -u root -p database > filename.sql


Database import:
mysql -u root -p database < filename.sql
2 total

On This Page:

  1. 1 SSH tunnel for mySQL
  2. 2 mySQL