MySQL-4

From Helpme

(Redirected from Mysql-4)
Jump to: navigation, search

Contents

DEPRECATED

MySQL-4 is no longer available. Please see the MySQL-5 page for current instructions.

Availability

MySQL4 can be used on Linux and Solaris machines in Engineering Design Center.

Preparation

Account Creation

To use MySQL, you must first have a MySQL account created for you. This account is separate from your normal DC account. To request one, please e-mail support@engr.scu.edu

Your account username will be identical to your DC username, but the password is independent. (By default it is set to your Access Card ID)


Database Name

Your database name will be of the format:

sdb_<username>

If, for example, your username were "testuser", your database would be named:

sdb_testuser


Database Server

The database server runs on a single system. Its hostname is:

dbserver.engr.scu.edu

Running

  • To setup MySQL in your environment, type:
setup mysql4
  • Run MySQL by executing:
mysql -h dbserver.engr.scu.edu -p -u <username> <db_name>
This will prompt you for your MySQL password. (note: this might be different from your DC account password)
Once authenticated, you will be left at the mysql> prompt.

Notes

  • To change your MySQL password, at the mysql> prompt run:
mysql> set password = password("yournewpassword");

Further Reading

  • Thorough MySQL documentation can be found at the MySQL website.
  • A tutorial on connecting to MySQL through PHP is available here.
Personal tools