• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 390
  • Last Modified:

why is access denied to my user right after i create the database? How do i fix it?

OK - this is one of those tech questions that simply pisses me off that I even have to ask it. I am logged into mysql. I create a database. Then I try to grant all permissions on that database to another user and I receive the message that I (the user that just created the database) is denied access to the database.

What am I doing wrong?
0
mcorsi62
Asked:
mcorsi62
1 Solution
 
mcorsi62Author Commented:
never mind - i created that database as root instead. There must be some sort of wacky permissions thing where my user can create a database but then root has to allow it access to it.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now