By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,304 Members | 3,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,304 IT Pros & Developers. It's quick & easy.

Help need for Grant Privileges...

nomad
Expert 100+
P: 664
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
Share this Question
Share on Google+
2 Replies


Atli
Expert 5K+
P: 5,058
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
Expert 100+
P: 664
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.