Database Problems

  • On closer inspection, the instructions are indeed very simple, just a few confusing things for newbies.
    At any rate, I think I have everythingn properly configured, and I uploaded all the files to my online website. Then I found the MySQL icon in my C-Panel and created a new User, Password and Database.
    As you probably know, C-Panels add your account username to MySQL usernames. Thus, if my C-Panel username is “boy, and I choose “wordpress” for a MySQL database, my actual database name would be boy_wordpress.
    Assuming I used “boy_wordpress” as a database name, the error message I got when I accessed the Install page would translate like this:
    We’re having a little trouble selecting the proper database for WordPress.
    * Are you sure it exists?
    * Your database name is currently specified as boy_wordpress. Is this correct?
    * 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?
    And assuming I created another database named “boy_blog,” this is what the next error message would look like:
    We’re having a little trouble selecting the proper database for WordPress.
    * Are you sure it exists?
    * Your database name is currently specified as boy_blog. Is this correct?
    * 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?
    I’m new to creating MySQL databases, so I could be making a simple mistake, but the instructions look VERY simple. The absense of the word “password” in the error message suggest there’s nothing wrong with my password.
    My Install page is set up something like this:
    define(‘DB_NAME’, ‘boy_blog’); // The name of the database
    define(‘DB_USER’, ‘boy_deuce’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘second’); // …and password
    define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value
    Can you see any problems?
    Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)

  • Have you given permissions to user boy_deuce on the database boy_blog using Cpanel?

    Thread Starter bearpress

    (@bearpress)

    Holy cow, all this localhost, username, password, privileges, permissions stuff gets a little deep! In other words, I don’t know the answer to your question.
    Looking at my C-Panel’s MySQL page, I see the three databases I created at the top of the page.
    Beneath them are two dropdown boxes. The dropdown box on the left says User and lists my username. The box on the left is labeled Db, and it lists all three databases.
    Beneath that is a series of boxes:
    Privileges: ALL ALTER CREATE TEMPORARY TABLES CREATE DELETE DROP SELECT INSERT UPDATE REFERENCES INDEX LOCK TABLES
    The only one that’s checked is the first, ALL Privileges.
    Beneath that are forms for adding new dB’s, Users and Hosts.
    I don’t see any mention of the word “permissions.”

    Thread Starter bearpress

    (@bearpress)

    Nevermind – I just figured it out. It looks like everything installed successfully, and I’m ready to log in.
    This is really the most amazing installation I’ve ever seen – relatively simple, witty, and I learned a little more about MySQL in the process!

    Good to hear that! ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database Problems’ is closed to new replies.