Configuring PHPMyAdmin v3.1.5

[joesaddigh]

Hi,

 

I have recently uploaded my site to the server so that it is live. I had to install phpmyadmin as an add-on as it was not provided with the hosting (fasthosts).

 

The version is 3.1.5 and is slightly different to the version i was using on my client WAMP server...

 

MY problem at the moment is that i have created users using the control panel of the fasthosts site and created the database. Imported the database and all of its data using PHPMyAdmin. The site works but it will not run any of the update, delete or insert queries...

 

This is because I have not assigned the users with any privileges..

 

 

Does anybody have any idea how to do this using this version of PHPMyAdmin as it does not have a privileges section.

 

Any help would be grateful

 

Thanks

 

[Daniel0]

Did you create a configuration file for it? There should be a folder called setup within the phpMyAdmin directory that can create those for you.

[joesaddigh]

The config file that I create is as follows:

 

<?php
$i=0;
$i++;
$cfg['Servers'][$i]['host']='host'; // your database server's IP address
$cfg['Servers'][$i]['auth_type']='config'; // Authentication method - config, http or cookie
$cfg['Servers'][$i]['user']='user'; // your database username
$cfg['Servers'][$i]['password']='password'; // your database user's password
?>

 

There is a folder called setup but what am i looking for inside there?

 

Thanks