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
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
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams carlosw...@gmail.com wrote:
On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley brentt...@gmail.com wrote:
All user information is stored in the mysql database. If you want to
see a list of users that have been created, query the user information
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams carlosw...@gmail.com wrote:
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams carlosw...@gmail.com wrote:
On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley brentt...@gmail.com wrote:
All user information is stored in the mysql database. If you want
On Wed, Apr 22, 2009 at 2:45 PM, George Larson
george.g.lar...@gmail.com wrote:
Is this what you mean?
SELECT * FROM user;
Yes. That was exactly what I was looking for. Thank you for that info.
Still learning these commands so pardon my ignorance.
Now I did create that new database called
On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams carlosw...@gmail.com wrote:
Now I did create that new database called 'forums' and would like to
create a new user who has access only to that specific database from
localhost. I can't seem to find the command via Google on how I create
the user
On Wed, Apr 22, 2009 at 3:11 PM, Carlos Williams carlosw...@gmail.com wrote:
On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams carlosw...@gmail.com wrote:
Now I did create that new database called 'forums' and would like to
create a new user who has access only to that specific database from