Member Avatar for phorce

Hello, basically I have two tables:

People
Orders

Now I want to grant the first person in "Peoples" with all privileges, now I've tried to do this:

GRANT ALL
ON Orders 
TO {testUser |PUBLIC |role_name} 
[WITH GRANT OPTION];

Doesn't work (because they are technically not a user, therefore, cannot do anything anyway) SO, I tried to make a new user in my database using this:

CREATE USER 'testUser@localhost' IDENTIFIED BY 'mypass'

Which returns: "Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation"
Even though I'm signed in as the administrator, does anyone have any ideas?

Thanks :)

  • 3 Contributors
  • 2 Replies
  • 132 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by mlesniak
Member Avatar for rotten69

Do you have the privileges for creating new users? there must be something that you need to modify in order to create new users in your DB. Looking at the error message, it simply says that you aren't granted the CREATE USER privilege(s). Check if you are or not. If you're not privileged to create NEW USERS, then grant yourself.

I hope this helps a little bit.

Member Avatar for mlesniak

First determine if you have the permission to create a user.

USE MYSQL;
 select user,create_priv from user where user = '<your username>';

If the query fails or if the returned row shows a N in the create_user column, then you don't have the permission.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.