Database Setup

[jayson]

ok, I have coppermine it's database is ********_***

 

I just installed a forum, but could not install it because it could not find a database, I wanted the DB to be rondo_ecfe so I have to install the forum with my copermine info, How do I install it in its own DB.

 

 

Thanks

[TCH-Rob]

Did you create a database in cPanel and add a user to it?

[jayson]

ahhh no, I will go do that now. I hope I can do it right.

 

Thanks for the 411

[jayson]

HELP!!!!!!! I have no idea what all that means, is there a walkthrough somewhere? I hate sounding like a total dweeb, but the last host, I ran 4 db off the one

[TCH-Bruce]

How about a Create MySQL Database tutorial.

[stevevan]

In a nutshell:

 

To set up and use a database, it's basically a 3-step process. First, you have to create the database. Then you have to create a user. Lastly, you add the user to the database. This is all done out of CPanel from the MySQL section.

 

Better idea so you can understand the concept behind things, check out Bruce's link.

[TCH-Don]

-- databse connect ----

 

Be sure that in MySql you

 

1 - created the database

2 - created a user

3 -added the user to the database (go back to MySql and find the Add user

select the user and database, and then Add user to database)

 

 

Then to connect to the database in a script use:

 

host: localhost

database: yourCpanelName_databaseName

user: yourCpanelName_databaseUser

password: mypassword

 

* Note password is just as the password,

do not add the CpanelName to it.

 

---------------------------

[jayson]

I had a guy that was on a site I was on, now he is here help me out, now if I cou7ld just get then darn error fixed, I would be 7th heaven

 

Thanks for all the help and support

[TCH-Bruce]

Have you opened a ticket with the help desk? Maybe they have an idea.

[jayson]

well I really hate to bother the help desk, they are busy enough without my problems, but I can give it a try

[stevevan]

well I really hate to bother the help desk, they are busy enough without my problems, but I can give it a try

That's what they are there for!

[jayson]

yea, I just asked them kill all my db and reset all my passwords, back to the default. got to many usernames and passwords, got to get a solution, they are good people.

[JTD]

Why does everyone complicate making a database. I go in make a database and that is all I do. The user is my default cpanel username and the password is whatever I have reset my cpanel password to. YOU DO NOT Have to create a new user for each and every database!

[TCH-Rick]

While it will work to use the cPanel username/password that can also create a different set of problems. It is advisable to change the cPanel password from time to time. It is easy to change the password in your cPanel but then you will need to change the password in your configuration files for any databases as well.

[JTD]

While it will work to use the cPanel username/password that can also create a different set of problems. It is advisable to change the cPanel password from time to time. It is easy to change the password in your cPanel but then you will need to change the password in your configuration files for any databases as well.

 

I do that on a regular basis. But my password is also a 128 bit encrypted one at the minimum. Something along these lines. N$%4A3nhyXy9c@MNxE51e <-- not my password