phpMyAdmin help?

[Bleek]

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.

 

[Bleek]

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.

 

[Bleek]

The following are the important ones; -

$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';

Thats very helpful, I'll use that in my config file and see if it works (obviously with fields filled in).

 

[Bleek]

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.

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

 

[Bleek]

<?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.

 

[Bleek]

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.

 

[Bleek]

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]

 

[Bleek]

another option would be to import in chunks - chop the 8mb file into say, 4 x 2mb files

How would I do that?