How do I give someone access to my MySQL database?

Question

To GRANT ALL privileges to a user , allowing that user full control over a specific database , use the following syntax: mysql> GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

Once you have the MySQL database connected to the DW, your teammates should be able to access the tables you've authorized them to see. This way you can also share your SQL queries with your teammates so they can run them against the MySQL server themselves.

How do I create a user and grant all privileges in MySQL?

Try this to create the user: CREATE USER 'user'@'hostname'; Try this to give it access to the database dbTest : GRANT ALL PRIVILEGES ON dbTest.

Expert · Answer

Once you have the MySQL database connected to the DW, your teammates should be able to access the tables you've authorized them to see. This way you can also share your SQL queries with your teammates so they can run them against the MySQL server themselves.

Expert · Answer

Try this to create the user: CREATE USER 'user'@'hostname'; Try this to give it access to the database dbTest : GRANT ALL PRIVILEGES ON dbTest.

How do I give someone access to my MySQL database?

Can you share a MySQL database?

How do I create a user and grant all privileges in MySQL?

Related Questions