Do you have a question? Post it now! No Registration Necessary. Now with pictures!
August 23, 2009, 5:39 pm
rate this thread
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
Do I have to ask the admin at my ISP to change my privs? Or what?
Re: How to GRANT myself privs?
I assume here it's a SHARED server, with other customer's data on
it as well as your own.
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
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.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum