Create a mySQL Connection

Use the Databases Panel to Create a mySQL Connection

1. Create a new PHP page. File > New > Blank page. Page type: PHP. Doc type: XHTML-transitional.
   
   Save it in your local folder as /382/php/createAcct.php.
   
   
   
2. Create a mySQL database Connection.
   
   Important Note: At some point during this process, you will be prompted to accept a Digital Certificate from ix.cs.uoregon.edu. Say "Yes" whenever this happens (typically once each session). You must accept the certificate in order to authenticate with the cs server, and make the database connection.
   
   In Dreamweaver, Select Windows > Databases to display the Databases panel.
   
   Click the Plus (+) button on the panel, select MySQL Connection from the menu, and complete the dialog box:
   
   Enter a name for the new connection, without spaces or special characters: (eg) connBH
   
   In the MySQL Server box, enter this server name and port number for the computer hosting MySQL.
   ix.cs.uoregon.edu:3171
   
   Enter your MySQL/WebDav user name and password.
   
   A MySQL database (userName_db1) was created for your use on this project. In the Database box, enter userName_db1, replacing "userName" with your actual MySQL username.
   
   Click Test. Dreamweaver attempts to connect to the database. If the connection fails, double-check the server name, user name, and password. If the connection still fails, check the settings for the testing folder Dreamweaver uses to process dynamic pages.
   
   Click OK.
   
   Upload /382/Connections/connBH.php to /cit381/userName/Connections/connBH.php on the server (using the Put Files blue up-arrow).
   
   

Next: