Can’t create database

  • I try to run install.php using the CLI php app, but I get a line telling me “Your PHP installation appears to be missing the MySQL which is required for WordPress.” I know this isn’t the case, so I try to make sure I’ve created a database, and none of my MySQL interfaces let me. mysql-admin crashes after I connect and start interacting with it; mysql-navigator kept telling me I had no permission to create a db. And now navigator won’t even launch. Running the CLI “mysql” interface doesn’t help me at all with creating a database. It’s good at telling me there is none, but the CREATE DATABASE command–I think that’s the right one–only responds with more input lines for me to type into until I give up and CTRL-Z the app. I’m certain that all I need to do is create a MySQL database. Yet this simple task is completely beyond me. What am I doing wrong?

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

  • Please give us lots of info about your server / OS / setup ?

    Thread Starter mithrandir

    (@mithrandir)

    Ubuntu. PHP4.3 and MySQL 4.0.23

    Trying to host locally. I’m calling the host localhost and letting everything have the most basic default names possible. I’ve sort of solved the above problem(s) by installing phpmyadmin, so now I have a comprehensible tool for creating a database. Unfortunately, I now get the following when trying to create the ‘wordpress’ database: #1044 – Access denied for user: ‘@localhost’ to database ‘wordpress’

    Login was just the MySQL default ‘mysql’ and no password. Not sure why access is/was denied. I’m the only user the app recognizes. Going to try running it as root. I’ll search around other threads, too.

    Creating a mysql user with a password would be a good idea. Now you’re trying to connect without a username..

    Thread Starter mithrandir

    (@mithrandir)

    >Creating a mysql user with a password would be a
    >good idea. Now you’re trying to connect without a
    >username..

    Yes, I suppose it would. But I’d rather worry about having the thing WORK before I worry about coming up with a password.

    And no, I am not trying to connect without a username. I am logged in as ‘mysql’ when I attempt to create the database and that is the error I get. If MySQL is confused, please help me figure out what’s confusing it. If I tried connecting without a username, I wouldn’t have gotten in in the first place, would I?

    Thread Starter mithrandir

    (@mithrandir)

    I’ve logged into phpmyadmin using the user “root” and everything appears to work now. I can make databases.

    I find the user documentation written by many in the opensource community to be very hard to follow since are writtey by people who are truly dedicated geeks (no offense intended; geeks are great but with severe limitations; they are very specialized) and not by someone with a knowledge of how to talk to newbies/non-specialists of their system. I try many things in many manuals and they simply don’t work. They need some usability expert tech writers. The problems arise often due to an instructions problem. When they blame the user’s misunderstanding you have to ask where this misunderstanding comes from. The MySQL documentation is a perfect example. Some of it is awfully hard to follow or reproduce; when you know how it all makes sense! Similarly the 5 minute WordPress install has a step, #4, where it states to Upload Everything. WHERE? WHAT? Only geeks would not put in the few nouns and adjectives that would clear up this statement. I think it means: “Using a FTP transfer client, upload (copy) all of the files (in the WordPress directory you just unzipped) to the database you will be using for your blog.” Notice how just a few words clears up so much. For newbies, it is just about impossible to understand or even know where to begin from the instructions given. At least you know above that you need an FTP Transfer client and you had better know how to get to the database you will be using. It’s a start.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Can’t create database’ is closed to new replies.