Creating a mySQL database

  • bert0

    (@bert0)


    21 years, 7 months ago

    Does anyone know how to create a mySQL database. Under the wp-config.php file I put in blog_database for the name of the database. When I am in the terminal I type in the following:
    [rvillatoro@acmserver public_html]$ mysql
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 187 to server version: 3.23.58
    Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
    mysql> CREATE DATABASE blog_database;
    ERROR 1044: Access denied for user: ‘@localhost’ to database ‘blog_database’
    mysql>
    I have no idea what this means. Lol, this installation process is driving me nuts when it shouldn’t be so hard to do.

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

    (@carla)

    21 years, 7 months ago

    I find it much easier to use the web interface for my database–not quite so frustrating. http://mysql.mydomain
    I hope this will help: htmllite’s tutorial for creating a database.

    Cypher

    (@cypher)

    21 years, 7 months ago

    First of all, make sure you have a user account to access MySQL. Next, you should login using that user account. So something like “mysql -u <username> -p” and then enter your password when prompted.
    You should now be able to do “show databases;” and list some databases, incliding “mysql” and “test”.
    Now you can try your “create database <wp-database>” command then redo the “show databases” command to see your new database.
    Regards

    Moderator Matt Mullenweg

    (@matt)

    21 years, 7 months ago

    In most shared hosting situations you create the database through your account control panel. Here are instructions for cPanel:
    http://wiki.wordpress.org/Cpanel

    Thread Starter bert0

    (@bert0)

    21 years, 7 months ago

    Bleh the system admin is on vacation and he as locked all users from creating a database on the ACM server. 🙁

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

The topic ‘Creating a mySQL database’ is closed to new replies.