MULTISITE multidb db and user creation failure

ok bought it.

==============
GRANT ALL PRIVILEGES ON * . * TO 'ptclient'@'localhost';
FLUSH PRIVILEGES;
CREATE DATABASE ptcmms_000 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE ptcmms_001 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

I get this:

MySQL said: Documentation

#1045 - Access denied for user 'ptclient'@'localhost' (using password: YES)
=======
with just this,

CREATE DATABASE ptcmms_000 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE ptcmms_001 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE ptcmms_002 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE ptcmms_003 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

I get this,

CREATE DATABASE ptcmms_000 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
MySQL said: Documentation

#1044 - Access denied for user 'ptclient'@'localhost' to database 'ptcmms_000'

=======
With this I get:
GRANT ALL PRIVILEGES ON * . * TO 'ptclient'@'localhost';
FLUSH PRIVILEGES;

SQL query:

GRANT ALL PRIVILEGES ON * . * TO 'ptclient'@'localhost';
MySQL said: Documentation

#1045 - Access denied for user 'ptclient'@'localhost' (using password: YES)
=======

So what do I do?

  • Tyler Postle
    • CGO

    Hey Thomas,

    Hope you're doing well today and welcome to the WPMU DEV Community!

    It sounds like your db user doesn't have the necessary priviledges.

    If you're using cPanel then go to your MySQL Databases and click on your user, then apply all privileges to it :slight_smile:

    Let us know if this does the trick!

    All the best,
    Tyler

  • Thomas
    • Design Lord, Child of Thor

    Tyler,

    I am well thank you for asking. Thank you for the welcome.

    ok,

    ran it again

    Error
    SQL query:

    CREATE DATABASE ptcmms_000 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    MySQL said: Documentation

    #1044 - Access denied for user 'ptclient'@'localhost' to database 'ptcmms_000'

    after running

    CREATE DATABASE ptcmms_000 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE ptcmms_001 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    I am trying to create 4106 db's but i tried it with one with the same results

    I do not know why the error about the user, it doesn't exist. I would like for it to be ptclient_mswp which I created manually, but that didn't help, since the creation of the db's seems to be a default assignment when creating a db.

    but i have no idea how to fix it

    #1044 - Access denied for user 'ptclient'@'localhost' to database 'ptcmms_000'

  • Tyler Postle
    • CGO

    Hey Thomas,

    Would you believe me if I said that would of been my next guess? :p

    Glad you got that one figured out and thanks for posting back Thomas! I'm sure that will help others that happen to find this post in their search for the same solution. Sending some points your way.

    Have a great weekend!

    Cheers,
    Tyler

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.