CODEWITHSUNDEEP
mysql
roacha
roacha

Reputation: 603

MySQL Grant All Commands?

I am trying to install daisy and I am following their install guide and running these commands as localhost root:

CREATE DATABASE daisyrepository CHARACTER SET 'utf8';
GRANT ALL ON daisyrepository.* TO daisy@'%' IDENTIFIED BY 'daisy';
GRANT ALL ON daisyrepository.* TO daisy@localhost IDENTIFIED BY 'daisy';
CREATE DATABASE activemq CHARACTER SET 'utf8';
GRANT ALL ON activemq.* TO activemq@'%' IDENTIFIED BY 'activemq';
GRANT ALL ON activemq.* TO activemq@localhost IDENTIFIED BY 'activemq';

The databases are created successfully but each of my GRANT ALL commands completes but it shows 0 records updated:

mysql> GRANT ALL ON *.* TO daisy@localhost IDENTIFIED BY 'daisy';
Query OK, 0 rows affected (0.00 sec)

I am running into a problem in the future of the install guide that seems to be related to this section. What am I doing wrong?

Additional info in the install guide about this section if it helps: Now create the necessary databases, users and access rights by entering (or copy-paste) the commands below in the mysql client. What follows behind the IDENTIFIED BY is the password for the user, which you can change if you wish. The daisy@localhost entries are necessary because otherwise the default access rights for anonymous users @localhost will take precedence. If you'll run MySQL on the same machine as the Daisy Repository Server, you only need the @localhost entries.

Upvotes: 0

Views: 1109

Answers (1)

zerkms
zerkms

Reputation: 255115

What am I doing wrong?

Everything is fine. The query haven't returned any rows and didn't affect any rows (only explicit DML queries affect rows) - so you get 0

Upvotes: 2

Related Questions