Re: how to - new user...

[Mikael Ronström]

Hi,

Peter Schulz wrote:
> hmm that means - if i run out of my limitations i
> have to
> *run backup
> *shutdown
> *reconfigure
> *start with initial
> ?
>


All of these config changes is safe to perform as rolling
upgrades. Thus cluster can remain on-line and one data node restarted at a time.

Rgrds Mikael

> how to set up a user to get access on one db - i
> wanted to create a user "xyz" , but when i create
> it on each mysqlapi node i don't get access to my
> ndbcluster tables/dbs - how can i solve this?
>
> i created with queriing each node with this:
>
> DROP USER 'mynewuser'@ '%';
> CREATE USER 'mynewuser'@ '%' IDENTIFIED BY
> '*********'
> GRANT USAGE ON * . * TO 'mynewuser'@ '%'
> IDENTIFIED BY '**********' WITH
> MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0
> MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
> FLUSH PRIVILEGES
> GRANT SELECT , INSERT , UPDATE , DELETE ON `mydb`
> . * TO 'mynewuser'@'';
> FLUSH PRIVILEGES
>
>
> what fails? i can connect with this user but get
> no access to the databases :( any idea?
> _pete®

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog: http://mikaelronstrom.blogspot.com