Difference between revisions of "MySQL Database Setup"
WetChicken (talk | contribs) |
WetChicken (talk | contribs) |
||
| Line 1: | Line 1: | ||
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. | ||
| + | In modules.conf, enable database:mysql and database:aliasdb.<br> | ||
After getting MySQL installed, install the MySQL administrator (Windows, Linux, and OS X are supported) which is also found on the MySQL download page.<br> | After getting MySQL installed, install the MySQL administrator (Windows, Linux, and OS X are supported) which is also found on the MySQL download page.<br> | ||
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. <br> | 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. <br> | ||
Assign permissions between the user and the database.<br> | Assign permissions between the user and the database.<br> | ||
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.<br> | 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.<br> | ||
| + | |||
A sample would look like:<p> | A sample would look like:<p> | ||
| Line 11: | Line 13: | ||
user=asss<br> | user=asss<br> | ||
password=whatever you selected for a password<br> | password=whatever you selected for a password<br> | ||
| − | database=asss | + | database=asss |
| − | |||
| − | |||
| + | <br> good luck! | ||
| + | WetChicken Sept 12 2005 | ||
[[Category:ASSS]] | [[Category:ASSS]] | ||
[[Category:Guides]] | [[Category:Guides]] | ||
Revision as of 14:44, 12 September 2005
Detailed MySQL instructions can be found at http://dev.mysql.com/doc/mysql/en/Installing.html.
In modules.conf, enable database:mysql and database:aliasdb.
After getting MySQL installed, install the MySQL administrator (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.
[mysql]
hostname=localhost
user=asss
password=whatever you selected for a password
database=asss
good luck!
WetChicken Sept 12 2005
