setting up db with mysql

[lennon123]

Hi there,
Im going crazy trying to sort this out.. should be really straight forward. Im trying to set up a simple database using phpmyadmin. I have downloaed it.. then followed the instructions in the documentation and then uploaded it to my host. When i go to logon it says
"#1045 access denied for user 'root@localhost'
I realsie that I have to edit the config file but not sure what to edit... is it the line that says
$cfg['Servers'][$i]['host'] = 'localhost';?
if so what do i need to change it to?
any help is appreciated
thanks

 

[jpadie]

phpmyadmin is not a database. it can only run sql queries for you that creates a database on a mysql server.

if your host offers a mysql server then you need the confg data from them.

 

[southbeach]

Like jpadie says, you need to contact your hosting service provider and set you query commands accordingly. I do not think they will give you a "root" user but one for your database.

Contact them, see what they come back with and if you still need help, come back here and post you up-to-date problem(s).

Good luck!

 

[Bertiethedog]

I had a problem with concept when I first started, In theory you don't need phpmyadmin at all, just the mysql control console.

I have loaded a wamp server onto my portable which allows access to all the config files.

Its quite difficult to request access to various files if you don't know of there existance

Best of luck