Carlos, 1) To list the users having access to a database, mysql> SELECT user,host from mysql.db where db = "*<database_name>*";
In your case that would be mysql> SELECT user,host from mysql.db where db = "*cal*"; 2) To grant access to a *NEW *user, you can use GRANT statement along with IDENTIFIED BY clause, which creates a new user and grants specified privileges to the specified database, in a single statement. Hence to create a new user, you could use either of the following - mysql> CREATE USER 'carlos'@'localhost' IDENTIFIED BY 'p...@$$w3rd'; mysql> GRANT ALL PRIVILEGES ON forums.* TO 'carlos'@'localhost' WITH GRANT OPTION; *OR* ** mysql> GRANT ALL PRIVILEGES ON forums.* TO 'carlos'@'localhost' IDENTIFIED BY 'p...@$$w3rd' WITH GRANT OPTION; Regards, Uma Bhat On 4/22/09, Carlos Williams <carlosw...@gmail.com> wrote: > > This seems to be a simple beginer question for MySQL and I have > searched online but I wanted to ask before I really confuse myself. > > I have MySQL running on Linux and right now I have created a 2nd > production database: > > mysql> show databases; > +-----------------------------+ > | Database | > +-----------------------------+ > | information_schema | > | cal | > | forums | > | mysql | > +-----------------------------+ > > I know when I created 'cal' I also created a specific user to have > permissions to this database as I was told root was not a good idea. I > don't remember who or what user I created so can someone please tell > me how I am able to look up the user who has permissions to 'cal' > database and I would also like to have that same user permissions to > the new database I created called 'forums'. > > Sorry for my ignorance but I greatly appreciate any and all assistance > to my question above! > > -- > Carlos W. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=bhat....@gmail.com > >
