Access my websites database?

@Chusaroo --

You write:

I have tried researching mySQL and phpmyadmin and linode have said i should be able to access the database via: user root and the root password: mysql -u root -p but i cant achieve this.

Are you sure the mysql db administrator's account name is root? Note that this account name can be different than the Linode's superuser login name (which also happens to be root).

It would be helpful if you posted more information…like the results of your attempts. Post your transcript between lines of 3 backticks (```) to turn off interpretation of special characters by Linode's Markdown processor.

-- sw

If you can post more information about it, then I will try to better assist you.

One thing, you must know that without Database Username and Password you can't access it.

If you have a proper backup of your Database and system files, then you reconfigure MySQL server.

Thanks,

Thank you all for your replies. The digital agency seem reluctant to give me the database credentials.

Am i able to set up the mySQL database now so all the data in my website including images are backed up from fresh?

Apologies if i seem clueless i am a newbie to all this!!

David