• Resolved questionsgalore

    (@questionsgalore)


    I am a newbie and have a few questions that I hope someone will answer.
    I am just trying to set up wordpress locally on my Macintosh, running OSX version 10.4.10. I would like to get everything up and running before I publish my website.

    I am using MAMP Pro as my local Apache server and MySQL application server. However, I have no idea of what to set up as a database for a blog. How many fields would I need? Tables? What would it look like? I am totally lost on this and haven’t been able to find anything on the WordPress site or Mamp site or on Google. Please help.

Viewing 12 replies - 1 through 12 (of 12 total)
  • MichaelH

    (@michaelh)

    WordPress installation will automatically create the necessary tables it needs. You need to create the Database, the Database User (with Password), and put that information in wp-config.php.

    Release review Installing WordPress and the sections on creating the Database and User.

    Resources:
    https://www.mamp.info/en/help.html

    Thread Starter questionsgalore

    (@questionsgalore)

    Wow! Awesome assistance. Much appreciated.
    OK, well, I setup and saved the wp_config.php file and saved in the wordpress/wp-admin/ directory as wp_config.php as per instructions. Then when I point my browser to the install.php file, the browser pops up a WordPress page saying “Error establishing a database connection” This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at MessageRocks. This could mean your host’s database server is down.

    Are you sure you have the correct username and password?
    Are you sure that you have typed the correct hostname?
    Are you sure that the database server is running?
    If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.

    and that is where I am hung up. Suggestions?

    Thanks in advance,

    Thread Starter questionsgalore

    (@questionsgalore)

    MichaelH,
    Just wondering. When I set up the wp-config.php file, I put in my own database name, user name and password. Perhaps I should have used “wordpress” “root” and “root” ???

    MichaelH

    (@michaelh)

    MessageRocks looks like a weird server (DB_HOST) but at this point if the information in wp-config.php is correct then you may have something wrong with your MYSQL server or some configuration between PHP and MYSQL might not be correct–that’s beyond my level…so maybe https://www.mamp.info/en/help.html has some help.

    Thread Starter questionsgalore

    (@questionsgalore)

    Michael,
    I actually have named my host “MessageRocks” because my website, when finished will be found at https://messagerocks.com. I am using MAMP Pro so am able to set up multiple hosts, etc.

    Now, I re-edited the wp-config.php file using the database name “wordpress” and a user name of “root” and a password of “root” but still get the same error page.

    I gather from your first posting that WordPress will create the tables/database needed, no matter what name I give to the proposed database, Correct???

    Thread Starter questionsgalore

    (@questionsgalore)

    Michael,
    Have you abandoned me or can I reasonably expect an answer to my questions?

    Chris_K

    (@handysolo)

    Side note: nobody is paid here to service anyone’s needs. everyone here is a volunteer with other obligations besides the forums.

    Patience is often a virtue.

    Thread Starter questionsgalore

    (@questionsgalore)

    I do understand that. However, If you are being helped by someone, I think it is reasonable to be able to continue until the problem is solved. Perhaps I’m wrong. Anyway, I have made some progress since talking to Michael and have managed to get a different message, but nothing like an automatically created database.????
    The message is: Can’t select database

    We were able to connect to the database server (which means your username and password is okay) but not able to select the wp_blog_messagerocks database.

    Are you sure it exists?
    On some systems the name of your database is prefixed with your username, so it would be like username_wordpress. Could that be the problem?
    If you don’t know how to setup a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.

    Now, are you willing to help me or do I need to wait for someone else?? Speaking of course with all due humility and respect.

    Kafkaesqui

    (@kafkaesqui)

    Yeah Michael, if it takes 36 hours non-stop, no sleep, then so be it!

    [punch drunk with love for our members]

    Thread Starter questionsgalore

    (@questionsgalore)

    Well, Obviously, I have not hit it off too well with many of the volunteers, so at this point I will just drop the whole issue so as to not be an inconvenience to any of you. I guess it was just foolish to think this was a place to get some answers. Unreasonable expectations.

    Kafkaesqui

    (@kafkaesqui)

    QG, I was only making a gentle swipe at my fellow mod.

    You want to get something to work. We understand the desire. We even understand the impatience. But — even though you do — not everyone understands we are *not* paid monkeys here.

    Moderator Samuel Wood (Otto)

    (@otto42)

    www.remarpro.com Admin

    Wow. Just keep in mind that nobody monitors these forums 24/7. A few hours between responses is normal.

    Anyway, you have to create the database yourself. WordPress doesn’t create one for you. It will create the tables and such, but the database is something you have to do.

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Re: Database Needed’ is closed to new replies.