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...

Expert 100+
P: 664
Hello Everyone.
I need some help in create Privileges for a new db.
I'm using a host call 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 is the db and blog is the table
  3. TO  // trying to make a new user
  4. IDENTIFIED BY "12345";
I get this error code:
MySQL said:

#1044 - Access denied for user: '' to database 'mysql'

Note this is a new db with a table called blog_db with one field.
Since 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
Share this Question
Share on Google+
2 Replies

Expert 5K+
P: 5,058

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

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 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.