Forums » Access denied for user on main page

RSS feed for this topic

Info

  1. ccomeka Posted 1 year ago

    Hello
    I am receiving this error:
    Access denied for user 'user1'@'localhost' (using password: YES)
    after the install. All looks proper for db.ini and I followed the install guide closely.

    [database]
    host = "localhost"
    username = "user1"
    password = "user1password"
    name = "omeka"
    prefix = "omeka_"
    ;port = ""

    This is on Ubuntu server 10. Please assist.

  2. drhiii Posted 1 year ago

    Your MySQL password has probably not been assigned. Your error is the one that usually depicts this.

    You need to set, or reset, your MySQL password. Search around for how to do this. There are several ways to come at this and not knowing your setup, you can do this from the commend line, or through several admin interfaces like PhpMYAdmin, Webmin, and so on.

    Here is something that may get you started:

    http://www.cyberciti.biz/tips/recover-mysql-root-password.html

  3. ccomeka Posted 1 year ago

    Thanks for the suggestion - I did assign this on install and I tried both this password and the standard user password for user1 in the db.ini. Or do I have to reset this to resync things?

  4. drhiii Posted 1 year ago

    Unless one works with this stuff often, meaning how MySQL behaves, like on installs and stuff, I find myself for instance having to go back and redo, or just plain DO stuff that I thought was done.

    That error is typical of what I have seen when the MySQL password is either unassigned, incorrect, or it could be an act of providence.

    Regardless of why, you may need to resort to resetting the password from the command line. That URL I posted is a pretty concise way of doing it. How it came to be set or not set probably only matters if you are going to be working in MySQL often. Otherwise, just resetting which means syncing the password to correspond to your db.ini may be the easiest thing to do.

    Just my $0.02.

  5. ccomeka Posted 1 year ago

    I got this resolved buy doing the correct grant for mysql privilege

    rant all privileges on omeka.* to 'user1'@'localhost' identified by 'user1password';

    I was just using password considering it a variable and not the literal value.

Reply

You must log in to post.