The Ultimate Guide to High Availability with MariaDB

Comments - Setting up MariaDB MaxScale

6 years, 8 months ago Roland Giesler
Re: Setting up MariaDB MaxScale

Is it correct to do this?

create user '*username*'@'*maxscalehost*' identified by '*password*';

The '*' should be removed, not so?

 
6 years, 8 months ago Markus Mäkelä
Re: Setting up MariaDB MaxScale

Yes, they are meant to be interpreted as placeholder values. Here's an example creation of a user named maxuser identified by the password maxpwd for MaxScale. The MaxScale instance is located on 192.168.121.100:

CREATE USER 'maxuser'@'192.168.121.100' IDENTIFIED BY 'maxpwd';
GRANT SELECT ON mysql.user TO 'maxuser'@'192.168.121.100';
GRANT SELECT ON mysql.db TO 'maxuser'@'192.168.121.100';
GRANT SELECT ON mysql.tables_priv TO 'maxuser'@'192.168.121.100';
GRANT SHOW DATABASES ON *.* TO 'maxuser'@'192.168.121.100';
GRANT REPLICATION CLIENT ON *.* TO 'maxuser'@'192.168.121.100';
 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.