How do I give someone access to my SQL database?

How do I give access to my database?

Procedure1From the Start menu, select Programs > SQL Management Studio. ... 2Select Microsoft SQL Server.3Select your server name and expand.4Select Security.5Right-click on Logins and select New. ... 6To set permissions, double-click the user account and do one of the following: ... 7Change the default database to GentranDatabase .

How do I share a MySQL database with another user?

Allowing a Remote Server to Access Your Database1Log into cPanel and click the Remote MySQL icon, under Databases.2Type in the connecting IP address, and click the Add Host button. ... 3Click Add, and you should now be able to connect remotely to your database.

How do I grant user privileges to user in MySQL?

Create a new MySQL user account mysql> CREATE USER 'local_user'@'localhost' IDENTIFIED BY 'password'; This command will allow the user with username local_user to access the MySQL instance from the local machine (localhost) and prevent the user from accessing it directly from any other machine.

How do I create a database user and grant permissions in MySQL?

To create a new user account in MySQL, follow these steps:1Access command line and enter MySQL server: mysql.2The script will return this result, which verifies that you are accessing a MySQL server. mysql>3Then, execute the following command: CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'password';