no way to compare when less than two revisions

Differences

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


—faq:mysql02 [2011/04/30 17:37] (current) – created clemens
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]]