After you have installed deployed MySQL Cluster you should add GRANTs so your applications and users can connect to the database cluster:
The easiest is if you do:
or for rpm installs:
and then do:
./execute-all-mysql.sh -uroot -p<the root password you have set> -e "< the grant you wish to set>'"
The 'execute-all-mysql.sh' script will set the GRANT on all started MySQL Servers that you have deployed.
./execute-all-mysql.sh -uroot -ppassword \
-e "grant select on *.* to 'johan'@'ip-10-150-115-208' identified by 'mypassword' "
This will give the SELECT privilege to user 'johan' coming from 'ip-10-150-115-208' using the password 'mypassword'.
Please sign in to leave a comment.