Help How To

[shadyDW]

How do I create a database in my cpanel?

[TCH-Bruce]

Try this tutorial.

[shadyDW]

So I have finally created my database.

I went to the link to launch and install the script.

But now no matter what I place in the following fields I get an error message:

 

DB server :

DB name :

DB login :

DB password :

Admin login :

Admin password :

 

Please help

[stevevan]

Did you add a user to the newly-created database?

[TCH-Rob]

Aside from adding the user, do not forget that your database name and username should be cpanelname_dbname or _username respectively.

[TCH-Bruce]

DB server : localhost

DB name : yourcpanelname_database (the database you created)

DB login : yourcpanelname_databaseuser (the user you added to the database)

DB password : the password you gave for the database user (the password you assigned to the user)

Admin login : name you will access the admin panel with

Admin password : password for the name you enter for admin login

[msohns]

What about the content of the database? Does one enter data into, say, an Access database, then upload it to mysite.com? And then how does one access the database from mysite.com?

 

I want to include in mysite.com a listing of my orgranization's members in a searchable database: info to include name, company name, address, city, state -- and be "query-able" (just like a database) by name, comapny name, or city.

 

I'm perfectly willing to learn the CGI, Perl, PHP, XHTML, XML, Java, or whatever I need, but what do I need to learn, and then what do I need to do to get it working?

[TCH-Bruce]

Welcome to the forums, Mr Wobbles

 

No, it's not an Access database although you would probably be able to dump one and import it into a MySQL database on the server. (don't know how to accomplish this task, maybe someone else does).

 

The database can be manipulated using phpMyAdmin which is in cPanel.

 

What you are wanting to accomplish is possible and I would suggest that you use PHP for the programming side of things.

[TweezerMan]

Welcome to the forums, Mr. Wobbles!

[TCH-Andy]

Welcome to the forums, Mr Wobbles

[TCH-Thomas]

Welcome to the forum, Mr Wobbles.

[stevevan]

Welcome to the forums Mr. Wobbles! I'm thinking you might be able to export the contents of the Access DB into maybe a comma-delimited format, then using a script, import it into MySQL. Of course, that might be a little bit more than what you want to get into.

[msohns]

Welcome to the forums Mr. Wobbles! I'm thinking you might be able to export the contents of the Access DB into maybe a comma-delimited format, then using a script, import it into MySQL. Of course, that might be a little bit more than what you want to get into.

 

I'm not sure what I want to get into. My understanding, now, is this:

 

The PHP book I have tells me to download Apache, MySQL, and PHP; write the database in MySQL, run it with PHP, and test it with Apache.

 

Is this now what I need to do: write the database (set up the structure and enter the content) in MySQL, write the query/seach instructions in PHP, test it in Apache, then upload it to TCH mysite.com, "create"* the database with MySQL in cpanel, and do something with PHPAdmin.

 

Am I close?

 

*is "create" a misnomer, because I've already created the database before uploading -- or do I actually create the database (structure and content) in cpanel?