Link to home
Start Free TrialLog in
Avatar of beehlers
beehlersFlag for United States of America

asked on

PHPMyAdmin configuration problems

I have installed PHPMyAdmin on my laptop in order to access a remote MySql database to update my webpage.  I have spent hours and hours trying to figure this out and am stumped.  When I open the setup page I get an error that says "Cannot load or save configuration file".  I have set the permissions on the all the folders I can find to allow it to write the .inc file but I must be missing something.  Do I have to have MySql installed on my computer?  Any help would be greatly appreciated.
ASKER CERTIFIED SOLUTION
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gizmola
gizmola

You can manually setup the config file by editting it -- so you don't have to work out the permissions issues.

With that said, phpMyAdmin does require that php have mysql support.  You don't need the mysql server but you do need the client library.  You should see this support listed when you make a script with the phpinfo();   function in it

Typically mysql servers are setup so that remote machines can not connect to the database.  Your phpMyAdmin config file will need to be setup to configure to the public facing host or ip and the port, which by default is 3306 if I recall correctly.  The user you plan to connect as, also needs to be configured within mysql to allow connections from your ip or a wildcard.  Often users are setup as 'username@localhost' and won't support a connection from external ip's. .