First page Back Continue Last page Image

Grant A User Access Rights To The Database

Since it would be a security issue to run databases as the root user, we need to make this database available to a user

The Command for this is:

$ grant all on StarPeople.* to ‘nicole’@’localhost’ identified by ‘livelongandprosper’;

Rights granted to user ‘nicole’ on this computer

Grant all rights on a database

Database StarPeople AND .* all of it’s sub objects

With password protection by this password

The Password