SQL query Error

Databases
1

image
image1336Ă—744 82.9 KB

Error
SQL query:


CREATE USER 'sess_admin'@'localhost' IDENTIFIED BY 'secret'
MySQL said: Documentation

#1227 - Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation

Question:
what does this error mean? I am unable to complete the operation. I am on live server of Hostgator shared hosting.

2

Many hosts will probably only allow you one MySQL user. Is your intention to create a user for your site (which is a different thing from a MySQL user)?

1 Like
3

It’s also definitely not going to let you grant on “PERSISTENT.*”, as that’s not your database name.

From the looks of your leftbar, you’re not the DB owner.
From the address bar, you’re using HostGator, and from a thread a couple of days ago I helped with, HostGator does MySQL users through a cpanel interface, not through SQL queries.

1 Like
4

Got it. Thanks!

5

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.