Difference between revisions of "MySQL"

From mi-linux
Jump to navigationJump to search
 
Line 15: Line 15:
 
If you wish to create your own database, follow these steps
 
If you wish to create your own database, follow these steps
  
1. Visit [https://mi-linux.wlv.ac.uk/mysqlreg https://mi-linux.wlv.ac.uk/mysqlreg]
+
1. Visit https://mi-linux.wlv.ac.uk/mysqlreg - '''NOT CURRENTLY ACTIVE'''
  
 
2. Read and agree to the terms and conditions, paying particular attention to the note that '''all student databases are deleted at the beginning of each academic year''' unless prior arrangements to keep databases are made with the MySQL administrator via email at [mailto:m.a.green@wlv.ac.uk m.a.green@wlv.ac.uk]
 
2. Read and agree to the terms and conditions, paying particular attention to the note that '''all student databases are deleted at the beginning of each academic year''' unless prior arrangements to keep databases are made with the MySQL administrator via email at [mailto:m.a.green@wlv.ac.uk m.a.green@wlv.ac.uk]

Revision as of 14:27, 19 December 2006

MySQL on mi-linux

MySQL is a very popular, open source, freely available, relational database management system available from MySQL.com

It has been installed on mi-linux and forms the backbone of most web applications/resources available to students, including this wiki!

Students will most likely make advantage of the database server in conjunction with web applications (created in PHP, Java, etc.) to form the data storage/retrieval component of any application.

Registering to use MySQL on mi-linux

YOU DO NOT NEED TO REGISTER to use MySQL on mi-linux unless you wish to create your own database. A number of freely accessible databases exist on the server, which can be viewed through the phpMyAdmin administration application, also installed on the server. Login to phpMyAdmin using "demo" as the account with no password to see the freely available databases.

HOW TO REGISTER

If you wish to create your own database, follow these steps

1. Visit https://mi-linux.wlv.ac.uk/mysqlreg - NOT CURRENTLY ACTIVE

2. Read and agree to the terms and conditions, paying particular attention to the note that all student databases are deleted at the beginning of each academic year unless prior arrangements to keep databases are made with the MySQL administrator via email at m.a.green@wlv.ac.uk

3. Enter your university account and password and click register

THIS IS NOT THE END OF THE REGISTRATION PROCESS

4. You will be sent an email with a confirmation code - read the instructions in the email to complete the registration.

5. Once registered, you can administer your database using the phpMyAdmin web interface.