
GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'Artegam@2008' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON agendax.* TO 'root'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON agendax.* TO 'tonio'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON agendax.* TO 'user1'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON agendax.* TO 'tonio'@'192.168.1.13' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON agendax.* TO 'user1'@'192.168.1.13' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'hp-dv6.home' WITH GRANT OPTION;


GRANT RELOAD ON *.* TO 'root'@'localhost';
FLUSH PRIVILEGES;

-- for MySQL
-- ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';

-- for MariaDB
-- ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('root');
