Search code examples
mysqlpermissionsnavicat

MySQL, Permission Issue

I have a MySQL database that has several databases used by more than 1 web app.

I need to now create a new Database that can only be accessed via a new user account. I've been using Navicat v5.3.3 manage users to try to set this up but it doesn't seem to work and I don't know if that's bec of MySQL or Navicat.

But given that I want a new DB that a new account can only access (not the other dbs) what's the best way to set this up?

Thanks

Solution

  • You just have to create your database and grant to the user the desired privileges, you should start a mysql query tool and type following queries:

    CREATE DATABASE foobar;
GRANT ALL PRIVILEGES ON foobar.* TO 'foobar_user'@'localhost'
IDENTIFIED BY 'goodsecret';

    you can take a look at the MySQL manual here