MySQL Forums
Forum List  »  Newbie

Error 1044 from client machine
Posted by: Thomas Jüntgen
Date: June 08, 2010 05:45AM

Hello all,

I connect from a client to the MySQL Server and create a database.
I'm logged in with root user. I do the following.

CREATE DATABASE `p_compliance`;
DROP TABLE IF EXISTS `p_compliance`.`t_item`;
CREATE TABLE `p_compliance`.`t_item` (
`c_source` varchar(10) CHARACTER SET latin1 NOT NULL,
`c_id` varchar(25) CHARACTER SET latin1 NOT NULL,
`n_type` int(3) NOT NULL DEFAULT '1' COMMENT '1=person, 2=company',
PRIMARY KEY (`c_source`,`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Now I want to grant privileges to my application user.

GRANT ALL PRIVILEGES ON p_compliance.* TO 'appuser'@'%';

Now I get the error message
- 1044 Access denied for user 'root'@'%' to database p_compliance

If I log direct on the server with root I can execute the statement.
Ok the I'm logged in as root@localhost, but how can grant privileges from a client machine?

Thanks for your help
Thomas

Options: ReplyQuote


Subject
Written By
Posted
Error 1044 from client machine
June 08, 2010 05:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.