472,111 Members | 1,992 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,111 software developers and data experts.

Help need for Grant Privileges...

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
  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...
PS I set up to use wordpress.
Nov 18 '08 #1
2 2689
5,058 Expert 4TB

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
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
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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.