welcome: please sign in

Diff for "DaemonAdmin/MySQL"

Differences between revisions 4 and 5
Revision 4 as of 2007-01-06 18:07:03
Size: 783
Comment:
Revision 5 as of 2007-01-10 13:51:32
Size: 915
Comment: Added note about network permissions.
Deletions are marked like this. Additions are marked like this.
Line 15: Line 15:
Still need to re-locate the data files to the correct location in the AFS file system. Where should this be? dbtool will need to be programmed to store data files in user home directories. It will also need to set up the appropriate GRANT permission on creation of each database to allow a connection from mire or other front-end servers by default.

1. DaemonAdmin/MySQL

Because we wanted to have version 5 of MySQL running on our stable server, we used the [http://dotdeb.org] package. For this reason there should be mirrors from dotdeb.org listed in the file /etc/apt/sources.list on deleuze.

1.1. Configuration details

my.cnf file modified to leave a port open over the network, default is local pipe only.

1.2. Progress

As of Sat Jan 6 12:29:23 EST 2007, the MySQL 5.0 daemon and client libraries have been installed on deleuze. I also installed the mysql-common and mysql-client 5.0 packages on mire which should will allow for users to connect back to the main DB server.

1.3. To Do

dbtool will need to be programmed to store data files in user home directories. It will also need to set up the appropriate GRANT permission on creation of each database to allow a connection from mire or other front-end servers by default.

DaemonAdmin/MySQL (last edited 2012-04-23 04:19:38 by ClintonEbadi)