Answers for "the database have permissions to create database or tables Unable to connect to db to check permisions mysql"

SQL
13

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
6

grant all priviledges to mysql user

/*
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 mydb.* TO 'myuser'@'%' WITH GRANT OPTION;

/*
I hope it will help you.
Namaste
*/
Posted by: Guest on May-06-2020

Code answers related to "the database have permissions to create database or tables Unable to connect to db to check permisions mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language