Forums

WordPress › Support » Installation

Do I need to have a db or will Wp create it? (5 posts)

  1. desbigi
    Member
    Posted 3 years ago #

    I have uploaded al files editing config see below, Do I need to create a DB? I just made up my DB name (I'm a complete greenhorn) can anyone advise ?

    <?php
    // ** MySQL settings ** //
    define('DB_NAME', 'wordpress'); // The name of the database
    define('DB_USER', 'deshalcyoncoachi'); // Your MySQL username
    define('DB_PASSWORD', 'leahjenny'); // ...and password
    define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value
    define('DB_CHARSET', 'utf8');
    define('DB_COLLATE', '');

    // You can have multiple installations in one database if you give each a unique prefix
    $table_prefix = 'wp_'; // Only numbers, letters, and underscores please!

    // Change this to localize WordPress. A corresponding MO file for the
    // chosen language must be installed to wp-content/languages.
    // For example, install de.mo to wp-content/languages and set WPLANG to 'de'
    // to enable German language support.
    define ('WPLANG', '');

    /* That's all, stop editing! Happy blogging. */

    define('ABSPATH', dirname(__FILE__).'/');
    require_once(ABSPATH.'wp-settings.php');
    ?>

  2. MichaelH
    Volunteer
    Posted 3 years ago #

    Yes you need to create the database and user. Please review Installing WordPress.

  3. desbigi
    Member
    Posted 3 years ago #

    Hi Michael

    Thanks for the reply.

    I have got the Database setup, my phpadmin shows deshalc_wp (0) and states No tables found in database.

    I have tried various DB_host setting - local host only or this setting which is what is displayed at the top of my phpadmin screen

    <?php
    // ** MySQL settings ** //
    define('DB_NAME', 'deshalc_wp'); // The name of the database
    define('DB_USER', 'deshalc_admin'); // Your MySQL username
    define('DB_PASSWORD', 'password'); // ...and password
    define('DB_HOST', 'rmysql1.mchost.biz/localhost'); // 99% chance you won't need to change this value
    define('DB_CHARSET', 'utf8');
    define('DB_COLLATE', '');

    When ever I enter -> http://www.domainname.ie/wp-admin/install.php

    I just get a blank screen up the view source code show as below
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
    <HTML><HEAD>
    <META http-equiv=Content-Type content="text/html; charset=windows-1252"></HEAD>
    <BODY></BODY>
    <META content=VFPEUAGBSX name=SKYPE_FRAMEID>
    <META content=VFPEUAGBSX name=SKYPE_FRAMEID></HTML>

    I can add a new database, but I thought the wordpress install done that ? or perhaps it doesn't ?

  4. Samuel B
    moderator
    Posted 3 years ago #

    rmysql1.mchost.biz/localhost
    this is wrong

    rmysql1.mchost.biz
    this is correct

    Also, be sure you added the user to the database with ALL privileges. It's a common mistake to miss this step.

    Also, wordpress will create the tables for you on install but it does not create the database.

  5. desbigi
    Member
    Posted 3 years ago #

    Hi Guys

    Still no luck
    I can get into phpmyadmin, see the database deshacly_wp
    I can even add table
    I have dumped and restarted the database... and added user with DBA is this ok ?

    Below is some of the phpmyadmin displayed menu

    · Server version: 5.0.51
    · Protocol version: 10
    · Server: Localhost via UNIX socket
    · User: deshalc_desbigi@localhost
    · MySQL charset: UTF-8 Unicode (utf8)
    ·
    MySQL connection collation:
    · Create new database:
    No Privileges
    · Show MySQL runtime information
    · Show MySQL system variables
    · Processes
    · Character Sets and Collations
    · Storage Engines
    · Databases
    · Export
    · Import
    · Log out

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags