MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:September 21 2002 12:08pm
Subject:re: mysql -p as simple user ?
View as plain text  
hans,
Friday, September 20, 2002, 8:00:08 PM, you wrote:

hs> have done a succesful update 3.23.36 to 2.23.47 on my mandrake-box 8.2,
hs> but have now that question :
hs> as user root it is possible to login now with "mysql -p" the
hs> password-question appears, typing in the root-password is okay and I can
hs> see the prompt "mysql>" but as a simple user and doing all the steps
hs> above I get :
hs> [papabaer@hanna papabaer]$ mysql -p
hs> Enter password:
hs> ERROR 1045: Access denied for user: 'papabaer@localhost' (Using
hs> password: YES)

hs> is it not possible, doing a login as a simple user - not only as root ?
hs> thought, using "mysql -p" does the trick ?

You should give privileges for non-'root' user. Look in the manual how
to do it:
     http://www.mysql.com/doc/en/GRANT.html

hs> or may I have to do some changes more ? and if so, where I have to do
hs> that steps ? what I have to do there ?

hs> hope someone can help me. I know, this is a really question for
hs> "dummies" but I don't know it.




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com



Thread
mysql -p as simple user ?hans schneidhofer20 Sep
  • re: mysql -p as simple user ?Egor Egorov21 Sep
RE: mysql -p as simple user ?Luc Foisy20 Sep