Difference between revisions of "MySQL Database Setup"
From ASSS Wiki
WetChicken (talk | contribs) |
(personal messages are inappropriate in this context IMO) |
||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | ===Installing MySQL=== | ||
Detailed MySQL instructions can be found at http://dev.mysql.com/doc/mysql/en/Installing.html. | Detailed MySQL instructions can be found at http://dev.mysql.com/doc/mysql/en/Installing.html. | ||
| − | After getting MySQL installed, install the MySQL administrator (Windows, Linux, and OS X are supported) which is also found on the MySQL download page. | + | ===Getting ASSS and MySQL talking=== |
| − | Create a user, a password for this user, and a database in MySQL. The default is asss for the user name and database name, and your choice on the password. | + | #In modules.conf, enable database:mysql and database:aliasdb. |
| − | Assign permissions between the user and the database. | + | #After getting MySQL installed (and functioning), install the MySQL administrator (NT based Windows, Linux, and OS X are supported) which is also found on the MySQL download page. |
| − | In global.conf in the [mysql] section change the user name, password, and the table name to what you have chosen above. The hostname should be localhost if MySQL is running on the same computer the server is. Otherwise you can use an IP address. | + | #Create a user, a password for this user, and a database in MySQL. The default is "asss" for the user name and database name, and your choice on the password. |
| − | + | #Assign permissions between the user and the database. | |
| − | + | #In global.conf in the [mysql] section change the user name, password, and the table name to what you have chosen above. The hostname should be localhost if MySQL is running on the same computer the server is. Otherwise you can use an IP address. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | A sample would look like: | ||
| + | <pre>[mysql] | ||
| + | hostname=localhost | ||
| + | user=asss | ||
| + | password=whatever you selected for a password | ||
| + | database=asss</pre> | ||
| + | Good Luck! | ||
[[Category:ASSS]] | [[Category:ASSS]] | ||
[[Category:Guides]] | [[Category:Guides]] | ||
Latest revision as of 20:34, 12 September 2005
Installing MySQL
Detailed MySQL instructions can be found at http://dev.mysql.com/doc/mysql/en/Installing.html.
Getting ASSS and MySQL talking
- In modules.conf, enable database:mysql and database:aliasdb.
- After getting MySQL installed (and functioning), install the MySQL administrator (NT based Windows, Linux, and OS X are supported) which is also found on the MySQL download page.
- Create a user, a password for this user, and a database in MySQL. The default is "asss" for the user name and database name, and your choice on the password.
- Assign permissions between the user and the database.
- In global.conf in the [mysql] section change the user name, password, and the table name to what you have chosen above. The hostname should be localhost if MySQL is running on the same computer the server is. Otherwise you can use an IP address.
A sample would look like:
[mysql] hostname=localhost user=asss password=whatever you selected for a password database=asss
Good Luck!
