The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Installing Database in Home

Discussion in 'General Discussion' started by Dakota10, May 11, 2010.

  1. Dakota10

    Dakota10 Registered

    Joined:
    May 11, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    I am attempting to manually install SMF (Simplemachine Forums) in the home directory.

    Example: mysite.com instead of a subdomain like mysite.com/forums

    The trouble is that once the files are installed by FTP, SMF needs a database name, usernam and passowrd password to install using their install.php script. These options are only available in cPanel when setting up a database using a subdomain, something like mysite.com/forums. There is no way to find the database name, username and password to set up my forums in the home directory.

    Example that SMF requires:

    Database type: MySQL
    Only recommended for small, low volume and/or intranet-type forums
    Multiple supported database types were detected - which do you wish to use.

    Server name: localhost
    This is nearly always localhost - so if you don't know, try localhost.

    Username: database_henry
    Fill in the username you need to connect to your database here.
    If you don't know what it is, try the username of your ftp account, most of the time they are the same.

    Password: Blablabla
    Here, put the password you need to connect to your database.
    If you don't know this, you should try the password to your ftp account.

    Database name: database_mysite
    Fill in the name of the database you want to use for SMF to store its data in. If this database does not exist, this installer will try to create it.

    Database filename:
    This is the name of the file in which to store the SMF data. We recommend you use the randomly generated name for this and set the path of this file to be outside of the public area of your webserver.

    Table prefix: smf
    The prefix for every table in the database. Do not install two forums with the same prefix!
    This value allows for multiple installations in one database.

    Any help finding the database name, username and password to install into the home directory is much appreciated.
     
  2. thewebhostingdi

    thewebhostingdi Well-Known Member

    Joined:
    Jan 10, 2008
    Messages:
    141
    Likes Received:
    0
    Trophy Points:
    16
    You will have to first create the MySQL database from cPanel and then you can fill up the details when installing SMF in your domain mysite.com/forum.
     
  3. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,453
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    While this post is for creating a database for some other software, you should be able to use it for creating your SMF database, the details are the same.
    http://forums.cpanel.net/f34/loading-joomla-site-138977.html#post595825


    Short of that, you're host can assist you with the details if you run into problems.

    Good luck.
     
  4. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    Me thinks you a little more than a bit confused here ;) :D

    Seriously though, MySQL has absolutely no bearing on your web address or whether you have things in your main domain or a subdomain.

    By the way you wrote your post, I get the feeling that you are only used to using automatic 3rd party installers like Fantastico or Softaculous which automatically create the MySQL database for you.

    If you are manually installing most any application on your web site,
    you need to login to your Cpanel control panel and if you look closely, you will see the options to manage your MySQL databases and a MySQL database wizard to setup new MySQL databases and users.

    All that matters is that you use the same information in the database that you create with the script application you are trying to install which in this case is SMF forums.

    Just for the record, MySQL doesn't care in the slightest where your script program is located. Folder or address doesn't matter. In fact, doesn't even need to be the same hosting account either as long as the login credentials used are accurate.
     
  5. Dakota10

    Dakota10 Registered

    Joined:
    May 11, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    I understand this but when using the Database Wizard it needs a subdomain (mysite_somthinghere).
    It does not allow you to leave the field blank to install into the Home directory as like Fantastico does.
    As of now the only thing in the Home directory is cgi-bin and the loaded SMF files.
     
Loading...

Share This Page