Database Setup

[Win7]

Hi everyone, 30 years on computers, BBC Basic, Turbo Pascal, Dbase, AutoLisp, VBA, HTML but no PHP or Apache or MySQL. Am so close yet so far. Setting up a local development for PhpFox. Install went fine, but phpFox wants to know
Database driver - I assume MySQL
Database host - I assume http://localhost
Database name - I did manage to create one I think using Phpmyadmin
Database user name - Also created one using Phpmyadmin
Database Password - Also created one using Phpmyadmin

But Phpmyadmin cannot connect to the database I created because I think MySQL needs to have the same password? Which I did set in
my-small.ini in the MySQL folder.

Am using Xampp V3.0.2 control panel. Xampp is working very well on Windows 7 Home Premium SP1 64bit.

Any links to MySQL and PHPmyadmin help or simple instructions to set up one simple database would save me going crazy!

[Altrea]

Hi Win7,

Database driver - I assume MySQL

Thats correct. MySQL is the name of a valid database driver. Another one would be MySQLi which has some improvements.

Database host - I assume http://localhost

Not correct! http is a protocol, thats not part of the host. A host identifier can be an IP-Address, or a Computername.
localhost has the role of a computername. it's an alias for the IP 127.0.0.1 (or ::1 for IPv6). So only localhost without http:// should work

Database name - I did manage to create one I think using Phpmyadmin

The name of your new database name should be typed in here

Database user name - Also created one using Phpmyadmin
Database Password - Also created one using Phpmyadmin

If the newly created database user has the needed permissions on that database, you can use them here.

But Phpmyadmin cannot connect to the database I created because I think MySQL needs to have the same password?

The phpmyadmin shipped with XAMPP comes preconfigured to autologin.
You can edit that behavior in the \xampp\phpmyadmin\config.inc.php file:
Search for $cfg['Servers'][$i]['auth_type'] = 'config';
Replace with $cfg['Servers'][$i]['auth_type'] = 'cookie';

After that you will not be logged in automatically but get a login form.

Which I did set in
my-small.ini in the MySQL folder.

Thats the complete wrong place for anything. That file is just a template, an example how a mysql configuration file for very old computers can look like.

best wishes,
Altrea

[Win7]

Altrea what we do without you? You have been such a help, thank you! I will try all that and hopefully get another step closer.