[SOLVED] Installing MYSQL and using it to connect to a database to assign privileges

[joesaddigh]

Hi,

 

I have been told by my hosting company 'fasthosts' that the only way that I can assign privileges to my users is by using MYSQL which I have downloaded.

 

When I try and login on the command line client I am not sure what password to enter. I have tried various combinations of passwords that it could be including the one that they sent me which logs me into the mysql site.

 

Does anybody know a way of resetting the password or what a possible password could be.

 

At this point I would like to add that I have not done anything with the MYSQL server instance config wizzard. Will I need to do this to assign permissions to my users...

 

Any help would be much appreciated!!

 

Thanks

[trq]

First question. Why do your users need access to mysql?

[joesaddigh]

My users don't need access to MYSQL but i want to grant them privileges such as select, update, delete because I have developed a cms which needs this functionality.

 

When working on it in my development environment using WAMP server I used PHPMYADMIN to give the users different privileges.

 

I have downloaded this for the real hosting and configured it but when i login it says that I have no privileges. After a long conversation with their support team they told me to install MYSQL and do it that way....

 

The tutorial they sent me is as follows...

 

 

http://www.fasthosts.co.uk/knowledge-base/?article_id=1081

 

This is what I am trying to follow

 

Thanks

[trq]

Still doesn't make much sense. Wouldn't your users be using your cms to select, insert, update, and delete records?

[joesaddigh]

I have fixed the problem now as one of my friends knew how to do it luckily. All i needed to do was to use the windows command prompt. Navigate to the sql bin directory then I could connect to my database and grant the privileges. The users now have the correct permissions to use the cms to add, delete, update records in the db.

 

 

Thanks anyways