User Tools

Site Tools


database:mysql:add_root

Add another root user to MySql

CREATE USER 'newuser'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Limit access from local lan, use 10.0.0.%

database/mysql/add_root.txt · Last modified: 2017/08/10 10:59 (external edit)