Can you create Databases with MySQLMyAdmin?

[rush_11]

If you can, could you please give me a guide on how to make databases with the MYSQLMyAdmin please.

[CyPliX]

CONFIGURING PHPMYADMIN and ABYSS WEB SERVER:

If you havn't already, download and install phpmyadmin and host it on your server. Making sure you have php and mysql installed and configured properly, alias the phpmyadmin and stick access control so no one else can edit your databases.

on mine i did: /myadmin

The next step is to configure phpmyadmin. Open the folder where you stored phpmyadmin and edit the file called: config.inc.php
Opening it in notepad might not be a good idea, personally i would either use a html editor or 'Textpad'.

Scroll down till you see: $cfg['Servers'][$i]['host'] =''; variables, they should looks somthing like the following:

I have the following set in my config:
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = FALSE;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'username';
$cfg['Servers'][$i]['password'] = 'password';

You should have somthing similar, however, you must specify your own username and password that you specified when you installed mysql.

*Keep the editor open, but save so you can continue with the following.

Run/Open your internet explorer program and direct it to your host and alias address. example: http://localhost/myadmin

Provide your username and password details that you specified for the access control alias.

Assuming you did everything correctly you should see phpmyadmin appear.

Now, assuming also that you have installed the latest version of phpmyadmin..

You might see some red text down in the middle of the page, if so, open that config.inc.php file and change:

$cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;
to
$cfg['PmaAbsoluteUri_DisableWarning'] = TRUE;

*Save and refresh your page.

CREATEING A DATABASE:

There will be a neat little box in the centre of the page, called Create new database. Type in a name for your database and press Create.

**Your database has been created

The rest is pritty self explainitory.. Create a table, edit the tables to create fields and their properties.
Edit a table to fill in the fields.

::THE END::