Error On Grant New User To Database

[yuanyudistira]

I always get error when install using web interface

Code: Select all

Creating database user 'otrssupport@localhost':

False! :-(

---==> Access denied for user 'root'@'172.20.200.2' to database 'otrssupport'

I am using a root for mysql

but why root can not grant using the installer?

please help


YY

[crythias]

because root might need a password? (The error message doesn't indicate that root was tried with a password).

[yuanyudistira]

because root might need a password? (The error message doesn't indicate that root was tried with a password).

BUt it works from the previous step,

and when I check, yes database is created, and all tables and record is created.

but it can not create a new user and grant accees to the tables ...

is it a bug?

YY

[crythias]

It appears that root doesn't have grant privileges for some reason. I can't imagine that that's the case, but can you do it manually?

[yuanyudistira]

It appears that root doesn't have grant privileges for some reason. I can't imagine that that's the case, but can you do it manually?

I tried using a HeidySQL GUI, and yes I can use grant command without error ...

[earwax]

What about if you just gave the MySQL root user FULL privileges?