Answers for "mysql grant"

SQL
13

mysql add user with all privileges

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
Posted by: Guest on January-02-2020
2

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
24

mysql grant all privileges to a user

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';
Posted by: Guest on March-18-2020
2

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';
Posted by: Guest on April-21-2021
12

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';
Posted by: Guest on June-08-2020
4

mysql grant

if(curl_exec($ch) === false)
{
    echo 'Curl error: ' . curl_error($ch);
}
else
{
    echo 'Operation completed without any errors';
Posted by: Guest on September-30-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language