Answers for "grant privileges mariadb"

3

create database and grant user rights mariadb

create database [DB name];

CREATE USER '[DB_User_Name]'@'localhost' IDENTIFIED BY '[DB_Password]';
GRANT ALL PRIVILEGES ON [DB_Name].* TO '[DB_User_Name]'@'localhost';

show grants for 'demouser'@'localhost';

FLUSH PRIVILEGES;
Posted by: Guest on March-22-2020
0

mariadb grant all privileges

## for connections from everywhere
ALTER USER 'myuser'@'%' IDENTIFIED BY 'theUsersPassword';

## for connections only from localhost
ALTER USER 'myuser'@'localhost' IDENTIFIED BY 'theUsersPassword';
Posted by: Guest on May-03-2022

Code answers related to "grant privileges mariadb"

Code answers related to "TypeScript"

Browse Popular Code Answers by Language