Database Setup

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Database Setup

Postby Win7 » 30. May 2012 20:34

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!
Win7
 
Posts: 5
Joined: 28. May 2012 08:00
Operating System: Windows 7

Re: Database Setup

Postby Altrea » 30. May 2012 22:45

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8290
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Database Setup

Postby Win7 » 31. May 2012 07:42

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.
Win7
 
Posts: 5
Joined: 28. May 2012 08:00
Operating System: Windows 7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 60 guests