1. Request a MySQL account from Blue 105 support
Go to our contact form and request a MySQL account, making sure to indicate your server ID (vsxxxxx) and password. Blue 105 support team will then send you your new MySQL user name and password.
2. How do I
access my database and verify it's ready?
From your telnet prompt, type the following at the command line to access your database:
$ mysql -u vs##### -p vs#####DB $ Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 53 to server version: 3.22.23b Type 'help' for help. $ mysql>
If you see the prompt above appear ("$ mysql>") your account is in place and you are ready to continue...
3. Download and install phpMyAdmin
For the beginner we recommend to download a free administration script that will help in creating and modifying MySQL tables. Go to http://phpwizard.net/phpMyAdmin/ and download the latest version of this script.
Setting up this script is very easy. Unzip all files into a directory and open the file "config.inc.php3". Modify the first few lines according to the following example (where vsxxxxx is your user name, 12345 is your password and vsxxxxxDB is your database name):
$cfgServers[1]['host'] = 'localhost';
$cfgServers[1]['port'] = ''; // Leave blank for default port
$cfgServers[1]['adv_auth'] = false;
$cfgServers[1]['stduser'] = 'vsxxxxx';
$cfgServers[1]['stdpass'] = '12345';
$cfgServers[1]['user'] = 'vsxxxxx';
$cfgServers[1]['password'] = '12345';
$cfgServers[1]['only_db'] = 'vsxxxxxDB';
// if set to a db-name, only this db is accessible
That's it. Close the file and upload all of them in ASCII format (very important) to your preferred server directory.
4. Design your first table structure
phpMyAdmin is quite self explanatory to work with. So now that you have your database installed and your administration script working, I believe we should start creating a simple table to get our feet wet. To do that open phpMyAdmin, click on your database name on the left sidebar and voil? the main window now shows some meaningful commands.
Congratulations! You have just
created your first table.
You are now ready to fill it with existing data or use it to store new data submitted
from your website.
For help on setting up this system, to make a one-click publishing system, or for all your PHP/MySQL development needs, contact me via our online form.