acces denied

[ronald1961]

Hello,
I’m so
Recently I rent a server with Direct Admin. At user level I created my site to direct admin and load it up to the server. I also created a database. Of course I wanted to look and I wanted to see if its works. My site has the extension .php. what do I see:Error:
Access denied for user 'apache'@'localhost' (using password: no)
So I changed the extension to shtml. Now I can see the site. I wanted to setup the database. I get almost the result Error:
Access denied for user 'ronald'@'localhost' (using password: YES).
I looked in phpMyAdmin and I have No Privileges to create a database. I don’t know how to change this. So Please help.
In advance thanks
Ronald

 

[eagle]

Hello,
I also created a database.
......
I have No Privileges to create a database.
Ronald

You have to create a db through DA and a db user, and use the db name/db user + pass in your config file.

 

[ronald1961]

thanks

But that's what I did. I created the datebase. but stil the same message

 

[eagle]

You didn't forget the account prefix (account_user)?

 

[ronald1961]

do you mean if I set the numbers of databases?
and if php is allowed. in that the answer is yes.
that is is why I don't understand what is wrong.

 

[eagle]

do you mean if I set the numbers of databases?
and if php is allowed. in that the answer is yes.
that is is why I don't understand what is wrong.

No, I meant, do you use the account prefix when you enter the db name and db user in your config file. When your da account is 'john' and you create a db called 'joe', you have to enter john_doe in your config file. It shows in the summary when you have finished the creation of a db.

 

[ronald1961]

as you already find out, I kinda new to this.
what I did.
I added in my domain in user level
I created the ftpaccount
I allowed the use of PHP and set number of db to unlimited,
then I went to MySQL Management, there I created a new database.
database name: john
username: joe
password: klaasje
then I get the summery

database name: admin_johm
username: admin_joe
password: klaasje

thanks for helping my

 

[Bradhost]

as you already find out, I kinda new to this.
what I did.
I added in my domain in user level
I created the ftpaccount
I allowed the use of PHP and set number of db to unlimited,
then I went to MySQL Management, there I created a new database.
database name: john
username: joe
password: klaasje
then I get the summery

database name: admin_johm
username: admin_joe
password: klaasje

thanks for helping my

before going any further i would change your password & dont post it on a public forum

in your config file for your site you need to use the values
database name: admin_johm
username: admin_joe
password: whatever you change it to