Creating MySQL databases on my own server (OS X)

  • I want to get my computer setup to host WordPress sites for building, and I’ll later push them to another hosting service, but for now I’m having trouble creating a MySQL database. Actually, I created the database in an SQL server running in my terminal. I’m using MAMP, and this is my config-sample file:

    define('DB_NAME', 'wordpress');

/** MySQL database username */
define('DB_USER', 'username');

/** MySQL database password */
define('DB_PASSWORD', 'password');

/** MySQL hostname */
define('DB_HOST', 'localhost');

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');

    I created another file called `wordpress’.sql and in the sql server created a database called wordpress. The problem is, when I go to run the installation, it’s giving me this error message:

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

    Since I’m my own host, I’m sure that I don’t need to put my username_wordpress for the database name…

    Anyone know what to do?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Anonymous User 9588789

    (@anonymized-9588789)

    Try logging into mysql on the command line with the username and password you tried using when setting up WordPress.

    Then run: SHOW DATABASES;

    If you don’t see the database you created for your WordPress installation, the user you logged in with does not have the privileges to access the database you made.

    I would recommend setting up phpMyAdmin or adminer to modify privileges. Otherwise, consult the MySQL manual to modify them on the command line.

    Anthony, can you please help me resolve my issue, refer to the topics in forum titled, “Cannot secure a connection to www.ads-software.com”
    thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Creating MySQL databases on my own server (OS X)’ is closed to new replies.