MySQL - Creating a Database and User

MySQL MySQL – Creating a Database and User

MySQL – Creating a Database and User

Creating a Database and User

Creating a Database and User
View the existing databases

1	show databases ;

Create a database

1	CREATE DATABASE exampledb DEFAULT CHARACTER SET utf8;

Create a user

1	CREATE USER 'exampledb_user'@'localhost' IDENTIFIED BY 'password';

Granting privileges

1	GRANT ALL PRIVILEGES ON * . * TO 'exampledb_user'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

Granting privileges only on the created database

1	GRANT ALL PRIVILEGES ON `exampledb` . * TO 'exampledb_user'@'localhost';

1	show databases ;

1	use exampledb;

To allow connection from anywhere

1	GRANT ALL PRIVILEGES ON . TO 'root'@'%.%' IDENTIFIED BY 'PASSWORD';

Allowing connections from specific hosts, identified by their IP address or hostname

1 2	GRANT ALL PRIVILEGES ON . TO 'root'@'192.168.7.93' IDENTIFIED BY 'PASSWORD'; GRANT ALL PRIVILEGES ON . TO 'root'@'host_name' IDENTIFIED BY 'PASSWORD';

Written By