phpMyAdmin help?

Bleek

Bleek

Bleek

Soldato
Joined
7 May 2004
Posts
5,503
Location
Naked and afraid
Not used this tool before and can't get it to connect to mySQL, do I have to do something special if my sql db is hosted on a different server?

Its fasthosts and their sql isn't on the same server as the home directory. :confused:
 
phpmyadmin must have config file where you input the MySQL server location - enter the address Fasthosts gave you. I can't remember the cobfig file's name off the top of my head but it should be fairly obvious :)
 
Do I enter the ip address in the host name?

Theres a host name and thats it, how can it find that host if I just put in the databases name when its not local. :confused:
 
The following are the important ones; -

Code: 
$cfg['PmaAbsoluteUri'] = 'http://www.your_web.net/path_to_your_phpMyAdmin_directory';
$cfg['Servers'][$i]['host'] = 'the ip of the host';
$cfg['Servers'][$i]['user'] = 'the db username';
$cfg['Servers'][$i]['password'] = 'the db password';
$cfg['Servers'][$i]['only_db'] = 'name of the db';
 
i seem to remember that you do not have to specify to exact database and it will show you all the databases available to you? (i maybe wrong).

With my myphpadmin when i log into it, it shows me all my databases.
 
IIRC Fasthosts only give you one db as standard and you have to pay £25 a year for each extra one.
 
Mr_L said:
The following are the important ones; -

Code: 
$cfg['PmaAbsoluteUri'] = 'http://www.your_web.net/path_to_your_phpMyAdmin_directory';
$cfg['Servers'][$i]['host'] = 'the ip of the host';
$cfg['Servers'][$i]['user'] = 'the db username';
$cfg['Servers'][$i]['password'] = 'the db password';
$cfg['Servers'][$i]['only_db'] = 'name of the db';
Click to expand...


Thats very helpful, I'll use that in my config file and see if it works (obviously with fields filled in). :)
 
Hmmm, I still get a #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured).

I even took out the absolute path to make things easier lol. :o :confused:

I just added that code between a <?php and ?> if thats correct?
 
<?php

$cfg['Servers'][$i]['host'] = ' 213.#.#.#';
$cfg['Servers'][$i]['user'] = '###';
$cfg['Servers'][$i]['password'] = '###';
$cfg['Servers'][$i]['only_db'] = '###';

?>

Obviously I've omitted the sensitive fields.
 
There should be an example config file you put your details into and then use. Those four lines alone won't do it, the actual config file is 800+ lines long.
 
Hmm thats odd, in my download there is no config file?

I think it must be created when you run the GUI but in the documentation it does suggest you can configure your own!

Sorry for being a numpty, this really isn't my area of expertise. :)
 
look in the /libraries folder and you should find config.default.php.

simply copy that into the root phpmyadmin folder and change the login details as per above.
 
Cheers guys I got it working!

... only to find I can't import my 8MB sql db because the phpmyadmin has a 2MB upload limit - lol!

[/bang head on wall and repeat]
 
either raise your max upload limits (php.ini and httpd.conf) or if you have access to the command line then upload it through there instead.

edit: just remembered your on fasthosts so you can't.

another option would be to import in chunks - chop the 8mb file into say, 4 x 2mb files :)
 
You must log in or register to reply here.
Back
Top Bottom