Sql

Search

grant select mysql

Copied 
CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'password';
GRANT ALL ON db1.* TO 'jeffrey'@'localhost';
GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost';
ALTER USER 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90;

Comment

PREVIOUS	NEXT

Code Example
Sql :: SQL DATEDIFF(date_part, start_date, end_date)
Sql :: md5 encode oracle
Sql :: intersect sql
Sql :: mysql grouping functions
Sql :: querry mysql by 2 columns
Sql :: oracle boolean to varchar
Sql :: mysql join same table multiple times group by
Sql :: top frequency in sql server
Sql :: postgres show table schema
Sql :: tsql generate rows
Sql :: oracle insert from select
Sql :: split string and copy last element postgresql
Sql :: initialize sql date
Sql :: create user with encrypted password postgresql
Sql :: how to verify sequence result in oracle SQL
Sql :: insert into table using openquery
Sql :: SQL IN Operator With Subquery
Sql :: sql server inner join
Sql :: merge command in sql
Sql :: into operator in sql
Sql :: insert command in sql
Sql :: how to reset the identity column in sql server
Sql :: postgresql between
Sql :: snowflake insert select
Sql :: what are the data types in sql
Sql :: column must appear in the GROUP BY clause or be used in an aggregate function
Sql :: how to output a different column name in mysql
Sql :: sql procedure
Sql :: 3rd height salary sql
Sql :: sql query interview questions githu

Search

SQL

grant select mysql

ADD CONTENT