Apache Friends Support Forum

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!

Hi Win7,

Win7 wrote: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.

Win7 wrote: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

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

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

Win7 wrote: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.

Win7 wrote: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.

Win7 wrote: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

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.