Connecting Tech Pros Worldwide Forums | Help | Site Map

Help need for Grant Privileges...

nomad's Avatar
Expert
 
Join Date: Mar 2007
Location: CA.
Posts: 570
#1: Nov 18 '08
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.

Atli's Avatar
Moderator
 
Join Date: Nov 2006
Location: Iceland
Posts: 3,755
#2: Nov 18 '08

re: Help need for Grant Privileges...


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.
nomad's Avatar
Expert
 
Join Date: Mar 2007
Location: CA.
Posts: 570
#3: Nov 18 '08

re: Help need for Grant Privileges...


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
Reply