Differences

This shows you the differences between two versions of the page.

Link to this comparison view

faq:mysql02 [2011/04/30 17:37] (current)
clemens created
Line 1: Line 1:
 +<​code>​
 +[02] HOW DO I CONNECT TO MY DATABASE?
  
 +     From any sdf machine, type:
 +
 +     $ mysql -h ol.freeshell.org -u $LOGNAME -p $LOGNAME ​
 +
 +                         - OR -
 + 
 +     $ mysql -h sdf-eu.org -u $LOGNAME -p $LOGNAME ​
 +
 +     A short cut called '​startsql'​ has been created for you so you 
 +     ​don'​t have to type the command above.
 +
 +     You will be prompted for a password, which by default is
 +     your user login. ​ (Please read the sentence and take its
 +     ​meaning literally!) ​ If you wish to change your password, you
 +     may do so like this:
 +
 +     $ mysqladmin -h ol.freeshell.org -u $LOGNAME -p password '​mynewpass'​
 +     
 +                                      - OR - 
 +
 +     $ mysqladmin -h sdf-eu.org -u $LOGNAME -p password '​newpw'​
 +
 +     ​(NOTE! its a bit confusing, but you will be prompted for your
 +     OLD password).
 +
 +     If that doesn'​t work for you, then try '​mypasswd'​
 +
 +     If you have forgotten your password, you can reset it back to your
 +     login id (not your login password) by typing '​reset-mysql'​
 +
 +     ​***SPECIAL INSTRUCTS FOR SDF CLASSROOMS***
 +
 +     If you have MYSQL access via an SDF class, then you must access a 
 +     ​different database server. ​ You must also use the bins in 
 +     /​sys/​classroom/​bin.
 +
 +     To access your database:
 +
 +     $ /​sys/​classroom/​bin/​mysql -h faeroes -u $LOGNAME -p $LOGNAME
 +   
 +     To change your password:
 +     
 +     $ /​sys/​classroom/​bin/​mysqladmin -h faeroes -u $LOGNAME -p password '​newpw'​
 +
 +     If you still have problems, please contact your instructor.
 +</​code>​
 +
 +[[mysql|back]]