469,150 Members | 1,941 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,150 developers. It's quick & easy.

Help need for Grant Privileges...

nomad
664 Expert 512MB
Hello Everyone.
I need some help in create Privileges for a new db.
I'm using a host call addr.com and I hate them for there cpanel sucks.
any I hav to write a MySQL to Grant All Privileges for a user to use a db.

Here is my code
Expand|Select|Wrap|Line Numbers
  1. GRANT ALL
  2. on allyson.blog    //allyson is the db and blog is the table
  3. TO nomad@adc.com  // trying to make a new user
  4. IDENTIFIED BY "12345";
I get this error code:
MySQL said:

#1044 - Access denied for user: 'allyson@xx.xxx.xxx.%' to database 'mysql'

Note this is a new db with a table called blog_db with one field.
Since addr.com us no real cpanel I don't know what Privileges the db has

I'm also using phpMyAdmin 2.6.2 but they have no localhost set up window.

Any help would be great...
nomad
PS I set up to use wordpress.
Nov 18 '08 #1
2 2549
Atli
5,058 Expert 4TB
Hi.

The problem there is that the user that you are using to execute your GRANT command does not have the privileges required to GRANT privileges.

Doesn't the cPanel have a feature that allows you to modify database privileges?
That is at least how my host has it set up for me.
Nov 18 '08 #2
nomad
664 Expert 512MB
Hi Atli:
No in the cpanel there is no hardly anything in it. I wrote to the company and I hope they get back to me. I will never use addr.com again. Once my wife contract is over I will transfer it to another host site.
Thank so far any other ideals
damon
Nov 18 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

12 posts views Thread by | last post: by
3 posts views Thread by Marc | last post: by
4 posts views Thread by Amardeep Verma | last post: by
reply views Thread by Ola Ogunneye | last post: by
reply views Thread by Charles Cantrell | last post: by
6 posts views Thread by maxwell | last post: by
reply views Thread by Marc | last post: by
reply views Thread by Julie Warden | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.