mysql grant code example

Example 1: mysql add user with all privileges

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

Example 2: mysql grant all privileges to a user

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

Example 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;

Example 4: grant all privileges mysql

/*
The GRANT statement is used to assign full control over specific database by providing all priviledge.
Follow below statement for assign priviledge to user
*/

Syntax: 
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

Example 5: mysql grant

-- Grants list
SELECT * FROM information_schema.user_privileges;
SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') FROM mysql.user;

-- Grant a user
/*  ALL PRIVILEGES  All privileges
    CREATE          Create databases and tables
    DROP            Drop databases and tables
    DELETE          Delete rows from a specific table
    INSERT          Insert rows into a specific table
    SELECT          Read a database
    UPDATE          Update table rows   */
GRANT SELECT, UPDATE ON db_name.table_name TO 'my_user'@'localhost';
GRANT SELECT ON *.* TO 'my_user'@'localhost';
GRANT ALL PRIVILEGES ON db_name.* TO 'my_user'@'localhost';

--Display user grants
SHOW GRANTS FOR 'my_user'@'localhost';

Example 6: mysql grant

if(curl_exec($ch) === false)
{
    echo 'Curl error: ' . curl_error($ch);
}
else
{
    echo 'Operation completed without any errors';