Your Database has been set up successfully. It is empty and you may now start using it to create tables and records. This mail should contain enough information to allow you to connect and begin working on the database. Your details are : MySQL Server hostname : danu6.it.nuigalway.ie MySQL Server port : 3306 (default MySQL port) Database : mydb2890 Username : mydb2890mk Password : vy4nig Note: The user above is a Database Owner, and has full permissions on the database and is used to manage the database e.g. create tables A further account has been created with just select, insert,update and delete permissions. This account is useful for using within scripts (PHP/ASP) or other programming languages (Java/Perl/C/C++), but it cannot create/drop tables Username : mydb2890u Password : mydb2890u Interacting with the Database structure : _______________________________ Interacting with your database is supported in various ways. The simplest may be by using the online phpmyadmin which offers a graphical interface via any web browser. Alternatives are using the command line mysql. This allows you to type SQL statements directly to the server. One other graphical method is to use the MySQL Workbench which is installed on PC's in IT labs. Online ------ Use the online open source phpMyAdmin which is installed on this server : http://danu6.it.nuigalway.ie/phpmyadmin/ Log in with your Database Owner credentials and use the online help for further instructions. Using Linux ----------- If you already have a linux user account on Danu6 you can log in using ssh (or PuTTY). Refer to your MySql documentation on how to interact with your database, but the standard login method is from the shell/terminal : mysql -u mydb2890mk -p vy4nig You can apply for a linux account using the IT Intranet. If you are using the mysql command from another machine then just add the host option : mysql -h danu6.it.nuigalway.ie -u mydb2890mk -p vy4nig Some sample pages for using PHP and MySQL: http://danu6.it.nuigalway.ie/samples/ Further General Help : http://danu6.it.nuigalway.ie/ or email : [email protected] Information Technology Technical Support College of Engineering and Informatics NUI Galway