How to GRANT myself privs?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

Hi folks --

MySQL server is on my ISP. I want to GRANT myself privileges on my own
databases. In particular, I want to be able to CREATE/DROP DATABASE
from my C-language connector. I think I should be able to change my
privs, but MySQL refuses me:

  mysql> use mysql
  ERROR 1044 (42000): Access denied for user 'calls'@'localhost' to
database 'mysql'

Do I have to ask the admin at my ISP to change my privs? Or what?


-- Pete

Re: How to GRANT myself privs?

Quoted text here. Click to load it

I assume here it's a SHARED server, with other customer's data on
it as well as your own.

Quoted text here. Click to load it

Try the GRANT request, which does not require "use mysql" to work.
I suspect that you will not be able to grant yourself privileges
you don't already have.  If you have multiple user accounts with
different privileges you might be able to grant privileges from one
user account to another.  Or not.  GRANTing privileges WITH GRANT
OPTION is something that is likely to cause the ISP to get more
tech support calls when users mess it up, so they will tend not to
allow it.

It is possible that your ISP is going to deny your request because
they use the lack of the ability to "CREATE DATABASE" to limit you
to a fixed number of databases that you get when you sign up for
the account.  It may also permit you to create or delete databases
for other people, something which they can't allow.

Site Timeline