Changeset 3413 for pykota/trunk/initscripts/mysql/README.mysql
- Timestamp:
- 09/27/08 22:02:37 (16 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/initscripts/mysql/README.mysql
r3279 r3413 25 25 DataBase using MySQL as a backend. 26 26 27 - edit the pykota-mysql.sql file and modify the passwords at 27 - edit the pykota-mysql.sql file and modify the passwords at 28 28 the end of the 'GRANT USAGE' lines. 29 29 30 30 - As MySQL's administrative user, usually root, 31 31 do the following : 32 32 33 33 # mysql <pykota-mysql.sql 34 34 35 35 - If no error message appear, your MySQL PyKota storage 36 36 is now ready for use. 37 37 38 38 - In ~pykota/pykota.conf, ensure that the following lines 39 39 are present and unique inside the [global] section : 40 40 41 41 storagebackend : mysqlstorage 42 42 storageserver : localhost … … 44 44 storageuser : pykotauser 45 45 storageuserpw : readonlypw 46 46 47 47 NB : replace 'readonlypw' with the password you chose 48 48 for user 'pykotauser' when you modified pykota-mysql.sql 49 49 50 50 - In ~pykota/pykotadmin.conf ensure that the following lines 51 51 are present and unique inside the [global] section : 52 52 53 53 storageadmin : pykotaadmin 54 54 storageadminpw : readwritepw 55 55 56 56 NB : replace 'readwritepw' with the password you chose 57 57 for user 'pykotaadmin' when you modified pykota-mysql.sql 58 59 - IMPORTANT : if your database is not located on the print server, 60 replace 'localhost' in the lines above with your database server's 58 59 - IMPORTANT : if your database is not located on the print server, 60 replace 'localhost' in the lines above with your database server's 61 61 hostname or IP address. If your database server doesn't listen on 62 62 its standard port, add the port number at the end of the hostname 63 63 with a colon to separate the hostname from the port. 64 64 See pykota/conf/pykota.conf.sample for examples. 65 65 66 66 ============================================================