drquek
08-29-2008, 10:29 AM
Creating MYSQL Database
If you’ve never created a MySQL database before this will probably be the most difficult part of the operation (although still not very difficult).
Thankfully you’ll need to do this only once. The way that you do this will be different depending upon which hosting control panel software your hosting company provides. Rather than reinvent the wheel, I’ll point you to a few flash videos online that document how to create a MySQL database.
Choose the one that applies to your situation. (View the link in a new browser window).
Cpanel: http://www.demodemo.com/1/tutorials/cpanel_xv2_mysql.htm
Ensim: http://www.demodemo.com/1/tutorials/ensim_sa_mysql.htm
H-Sphere: http://www.demodemo.com/1/tutorials/hsphere23_mysql.htm
Plesk: http://www.demodemo.com/1/tutorials/plesk8_eu_mysql.htm
The basic process is this.
1. You’ll create a database
2. You’ll create a user
3. You’ll then give the new user permission to access the new database
At the end of it, you’ll want to get four values. Make sure you look at the end result because often the server well append an extra value to your database and username (e.g. dbname turns into “user754_dbname”)
1. Database Location (most of the time this will simply be localhost)
2. Database Name
3. Database Username
4. Database Password
Once you have this info, you’re ready to roll.
Uploading the script:
You’ll now want to unzip the contents of the software and put them on your local drive. Ensure that you unzip it with folder names intact. The default folder name is /amlmlite. You can change this folder name to whatever you like. Now upload (via FTP) to your server.
You’ll now want to CHMOD the /amlmlite (or whatever you renamed it to) folder and the /upload to 757. Normally this is just a case of right clicking on the folder once it’s on the server and clicking on the “Permissions” or “CHMOD” option.
If you’ve never created a MySQL database before this will probably be the most difficult part of the operation (although still not very difficult).
Thankfully you’ll need to do this only once. The way that you do this will be different depending upon which hosting control panel software your hosting company provides. Rather than reinvent the wheel, I’ll point you to a few flash videos online that document how to create a MySQL database.
Choose the one that applies to your situation. (View the link in a new browser window).
Cpanel: http://www.demodemo.com/1/tutorials/cpanel_xv2_mysql.htm
Ensim: http://www.demodemo.com/1/tutorials/ensim_sa_mysql.htm
H-Sphere: http://www.demodemo.com/1/tutorials/hsphere23_mysql.htm
Plesk: http://www.demodemo.com/1/tutorials/plesk8_eu_mysql.htm
The basic process is this.
1. You’ll create a database
2. You’ll create a user
3. You’ll then give the new user permission to access the new database
At the end of it, you’ll want to get four values. Make sure you look at the end result because often the server well append an extra value to your database and username (e.g. dbname turns into “user754_dbname”)
1. Database Location (most of the time this will simply be localhost)
2. Database Name
3. Database Username
4. Database Password
Once you have this info, you’re ready to roll.
Uploading the script:
You’ll now want to unzip the contents of the software and put them on your local drive. Ensure that you unzip it with folder names intact. The default folder name is /amlmlite. You can change this folder name to whatever you like. Now upload (via FTP) to your server.
You’ll now want to CHMOD the /amlmlite (or whatever you renamed it to) folder and the /upload to 757. Normally this is just a case of right clicking on the folder once it’s on the server and clicking on the “Permissions” or “CHMOD” option.