Help: mySQL Database Access

mySQL is an easy to use yet powerful relational database system. If you do not have an account on the mySQL server, click Here to create one. DogNET runs a mySQL server on the machine db. Databases can be accessed two ways:

	From Fang:
	fang:~> mysql -h db -u username -p username

	From db:
	db:~> mysql -u username -p username	

	You will then be prompted for your password.

Alternatively, an alias can be created so that by typing my, the mysql client will be started and you will be logged in (you will still need to enter your password, however). To create this alias, append the following line to the .alias file in your home directory. If you are using the default DogNET .alias file, the alias has already been set up for you.

	alias	my	'mysql -h db -u username -p username'

For more information on the mysql command and what the switches mean check the man page. Also, there is a great deal of information on the mySQL Website.

If you are in need of help setting up your database, contact the admins