joesaddigh Posted May 24, 2009 Share Posted May 24, 2009 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 Quote Link to comment https://forums.phpfreaks.com/topic/159474-adding-privileges-to-phpmyadmin-315/ Share on other sites More sharing options...
Axeia Posted May 24, 2009 Share Posted May 24, 2009 Are you sure it's the phpmyadmin version and not the account you used for phpmyadmin lacking rights to assign privileges to others? Quote Link to comment https://forums.phpfreaks.com/topic/159474-adding-privileges-to-phpmyadmin-315/#findComment-841197 Share on other sites More sharing options...
joesaddigh Posted May 25, 2009 Author Share Posted May 25, 2009 Well it seems like it is the phpmyadmin version as there is not even an option there to assign privileges. When i set up the database and the users using fasthosts it did not give an option to assign privileges either... Any ideas? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/159474-adding-privileges-to-phpmyadmin-315/#findComment-841584 Share on other sites More sharing options...
wildteen88 Posted May 25, 2009 Share Posted May 25, 2009 It is most probably the account your using when logging in to phpmyadmin which doesn't have sufficient privileges for altering privileges. phpmyadmin3.1.5 has a privileges tab at the top of the main page. This tab will not be visible if the account your using doesn't allow for privileges to be changed. You should get in contact with your host about this. When your host sets up new users the minimum privileges they should provide is select, delete, update and insert. Only your host will be able to fix this. Quote Link to comment https://forums.phpfreaks.com/topic/159474-adding-privileges-to-phpmyadmin-315/#findComment-841590 Share on other sites More sharing options...
joesaddigh Posted May 25, 2009 Author Share Posted May 25, 2009 Ok thank you I will do this now... Thank you for your advice Quote Link to comment https://forums.phpfreaks.com/topic/159474-adding-privileges-to-phpmyadmin-315/#findComment-841594 Share on other sites More sharing options...
joesaddigh Posted May 25, 2009 Author Share Posted May 25, 2009 I have contacted my hosting company and they think that there is something wrong with my connection string and that is why i cannot assign privileges. My connection string is as follows, do you know what the problem could be? <?php $i=0; $i++; $cfg['Servers'][$i]['host']='213.171.218.228'; // your database server's IP address $cfg['Servers'][$i]['auth_type']='cookie'; // Authentication method - config, http or cookie $cfg['Servers'][$i]['user']='user'; // your database username $cfg['Servers'][$i]['password']='password'; // your database user's password ?> Thanks Quote Link to comment https://forums.phpfreaks.com/topic/159474-adding-privileges-to-phpmyadmin-315/#findComment-841783 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.