Mysql

[dieguy]

I would like to know how to set up a Mysql. I would like to try out a program called postnuke, witch is similar but different then phpNuke. If some one could tell me step by step how to set up the mysql and then upload onto it I would appreciate it. Thanks for anyhelp. Rock Sign

[TCH-Dick]

You have to create a database and a user for that database via manage mysql in your sites cpanel, then you need to edit the congif.php file for your post nuke to include the database name, username and password.

[dieguy]

Thanks. Is there a certain program needed or do u use the web browser for the config.php.

[TCH-Dick]

you can edit the config.php in notepad

[dieguy]

What would be Mysql db hostname.

And I can not find the db in my FTP.

[TCH-Dick]

localhost

[dieguy]

Am I doing something wrong if I cant find it in FTP. It says the db is created. Or do I upload somewere else.

 

Sorry for all the questions.

[TCH-Dick]

cant find what with ftp? Your database wont show up in ftp

[dieguy]

Oh, then how do I upload the post nuke or where.

[TCH-Dick]

you upload nuke to your public_html folder, or a folder inside the public_html folder

[TCH-Dick]

Take a look here if you are having problems installing postnuke

 

PostNuke install help

[dieguy]

I think I almost have it. I have installed it properly I think, but it comes up that it cant find database. If you could help with these things mabe it will work.

 

What would be my,table prefix=

and my, table type=

 

Thanks

[TCH-Dick]

We dont provide support for PostNuke, like i said your best source for help is on the PostNuke site I linked above.

 

anyway.....you shouldnt change the table prefix or table type, leave them as default. Make sure your dbase name and username are in the format below, also make sure you assigned a user to the database in manage mysql

 

 

$pnconfig['dbtype'] = 'mysql';

$pnconfig['dbtabletype'] = 'MyISAM';

$pnconfig['dbhost'] = 'localhost';

$pnconfig['dbuname'] = 'cpanelname_dbaseusernamename';

$pnconfig['dbpass'] = 'whatever password';

$pnconfig['dbname'] = 'cpanelname_dbasename';

$pnconfig['system'] = '0';

$pnconfig['prefix'] = 'nuke';

$pnconfig['encoded'] = '1';

[dieguy]

Thanks Mike