25 messages in com.mysql.lists.mysqlMySQL: User Privledges
FromSent OnAttachments
Ben-Nes Michael06 Sep 1999 01:15 
Martin Ramsch06 Sep 1999 01:38 
Ben-Nes Michael06 Sep 1999 02:03 
Martin Ramsch06 Sep 1999 02:11 
Ben-Nes Michael09 Sep 1999 02:40 
Martin Ramsch09 Sep 1999 03:04 
Ben-Nes Michael09 Sep 1999 05:51 
John Millaway09 Sep 1999 08:00 
mtweito09 Sep 1999 08:00 
John Millaway09 Sep 1999 08:15 
mtweito09 Sep 1999 08:17 
John Millaway09 Sep 1999 08:18 
mtweito09 Sep 1999 08:20 
John Millaway09 Sep 1999 08:21 
mtweito09 Sep 1999 08:25 
Michael Widenius09 Sep 1999 11:05 
Martin Ramsch09 Sep 1999 11:43 
sin...@cytanet.com.cy09 Sep 1999 12:02 
John Millaway09 Sep 1999 12:11 
Benjamin Pflugmann09 Sep 1999 14:41 
sin...@cytanet.com.cy10 Sep 1999 05:03 
A. Brandic10 Sep 1999 05:26 
Martin Ramsch10 Sep 1999 06:14 
Tõnu Samuel10 Sep 1999 11:56 
Christian Mack13 Sep 1999 07:48 
Subject:MySQL: User Privledges
From:mtweito (mtwe@ix.netcom.com)
Date:09/09/1999 08:00:54 AM
List:com.mysql.lists.mysql

Hi,

I am new to MySQL. I have a question about user priviledges. I have a database on my machine called "jdbctest". I started MySQL as a standalone database on Windows NT Workstation 4.0.

A colleague of mine is on the same network and needs to connect to the database. I tried to add him and give him permissions.

I used:

insert into user (host,user,password)
values('bikedev2','bike',password('bike'));

^ ^ ^ his host user password

Unfortunately I get the error "Can't find file: user.frm".

Apparently, the user table isn't set up automatically on MySQL on NT. Is there a script or a command to create the table easily.

Thanks, Mark Tweito mtwe@ix.netcom.com