List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 9 1999 6:43pm
Subject:Re: MySQL: User Privledges
View as plain text  
On Thu, 1999-09-09 10:01:16 -0500, Mark Tweito wrote:
> 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'));
[...]
> Unfortunately I get the error "Can't find file: user.frm".

Maybe your current database was not 'mysql'?
Then try:  INSERT INTO mysql.user ...

And don't forget to issue the SQL command
  FLUSH PRIVILEGES;
afterwards, because otherwise MySQL won't take notice of such manual
changes in the privilege tables.
Alternatively, you can use the shell command: mysqladmin flush-privileges


Or even better, if you have MySQL V3.22.11 or later, use the GRANT
command to create the new user.  The it's as easy as this:
  GRANT SELECT ON dbname TO bike@bikedev2 IDENTIFIED BY 'bike';

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
Backup tabelBen-Nes Michael6 Sep
  • Re: Backup tabelMartin Ramsch6 Sep
  • Re: Backup tabelBen-Nes Michael6 Sep
    • Re: Backup tabelMartin Ramsch6 Sep
  • Re: Backup tabelBen-Nes Michael9 Sep
    • Re: Backup tabelMartin Ramsch9 Sep
  • Re: Backup tabelBen-Nes Michael9 Sep
    • Re: Backup tabelMichael Widenius9 Sep
  • MySQL: User Privledgesmtweito9 Sep
    • Re: MySQL: User PrivledgesMartin Ramsch9 Sep
RE: MySQL: User PrivledgesJohn Millaway9 Sep
  • Re: MySQL: User Privledgesmtweito9 Sep
  • Re: MySQL: User Privledgesmtweito9 Sep
RE: MySQL: User PrivledgesJohn Millaway9 Sep
  • Re: MySQL: User Privledgesmtweito9 Sep
RE: MySQL: User PrivledgesJohn Millaway9 Sep
  • RE: MySQL: User Privledgessinisa9 Sep
    • Re: MySQL: User PrivledgesBenjamin Pflugmann9 Sep
      • Re: MySQL: User Privledgessinisa10 Sep
        • get_lockA. Brandic10 Sep
          • Re: get_lockMartin Ramsch10 Sep
          • Re: get_locktonu10 Sep
RE: MySQL: User PrivledgesJohn Millaway9 Sep
RE: MySQL: User PrivledgesJohn Millaway9 Sep
  • Re: MySQL: User PrivledgesChristian Mack13 Sep