One other thing to bear in mind for the future is that MySQL security is more finely grained than (say) Microsoft SQL Server.
If you put the sa password in with MS SQL then you get in. With MySQL you can specify which machines a user can connect from (this can help to make it much more secure - even if a user knows the admin password they can't use it when they've hacked your webserver; they need to hack the db server as well)
this can mean that a username and password which will work when you type them directly at the MySQL console won't work when they're in a PHP page running from a different web server.
config.inc.php - What's in there?
That file is also in config and libraries/*
* Generated configuration file
* Generated by: phpMyAdmin 2.11.7 setup script by Michal ÄŚihaĹ™
* Version: $Id: setup.php 10748 2007-10-10 07:30:59Z cybot_tm $
* Date: Mon, 14 Jul 2008 21:56:49 GMT
/* Servers configuration */
$i = 0;
/* Server localhost (config:root)  */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = '';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* End of servers configuration */
Nothing's ever simple, I don't use phpmyadmin on windows so I'm perhaps little use.
I've just downloaded phpmyadmin from their site and there is no "config" directory and the file doesn't exist in libraries.
Grab this, extract it into your "public" space ie wwwpub or whatever its called in IIS land.
Copy the config.sample.inc.php file to config.inc.php.
It should then "just work" as the same config is set to cookie anyway.
Give that a whirl.
Theres a script to create the config file in the scripts dir. Think its scripts/setup.php (it is on my server)
That should let you create the config, you dont need a password if you use cookie auth like kmount said
Ok to add the chaos, below is what I use for my phpmyadmin config.inc.php file. It will prompt you to login and you should use the same credentials that you use at the mysql command prompt.
I recommend you backup your config first
Code:$i = 0; /* * First server */ $i++; /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'http'; /* Server parameters */ $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = '3306'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; /* Select mysqli if your server has it */ $cfg['Servers'][$i]['extension'] = 'mysql';
Yes if i rename i rename, it no longer works
I'm intrigued now. Rather than poking it extensively with the stick of no hope, is it possible to get FTP access to the box under a limited account or something to see what its playing at?
We don’t have FTP, this is only a test server and is not live on the net. If my site runs good on IIS i will put it on the main server. I don’t want to get stuck next time. When i migrate to the proper server can i just copy the whole folder over? Or should I just put the website on the test server and on the main one concentrate on getting everything up and running? Does that make sense?
Instead of FTP I can setup a VPN connection if you like?
Thanks for the help.
In theory, moving from one server to another is relatively straight forward, grab the files, grab a sql dump and off you go.
EDIT: (Or even RDP as I assume once I'm on the VPN I'll need to access the files somehow ...)
Last edited by kmount; 15th July 2008 at 06:59 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)