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