25 messages in com.mysql.lists.mysqlRe: MySQL: 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:Re: MySQL: User Privledges
From:mtweito (mtwe@ix.netcom.com)
Date:09/09/1999 08:20:42 AM
List:com.mysql.lists.mysql

Thanks for writing back. I tried the mysqlshow mysql user and it worked to give me a master user table.

Then I tried:

mysqlshow jdbctest user AND mysqlshow mysql jdbctest

Cannot list fields in db: mysql, table: user: Can't find file 'jdbctest.frm' / 'user.frm'

Does this mean that you store all of the users and passwords in the mysql master database? Even if it applies to only one specific database on the host?

Thanks, Mark

John Millaway wrote:

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.

It SHOULD be set up already, at least mine was. Do this from the command line to verify that the table exists:

mysqlshow --user=root --password=XXXXXX mysql user

--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail mysq@lists.mysql.com

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail mysq@lists.mysql.com instead.