List:General Discussion« Previous MessageNext Message »
From:Tom.Prouty Date:May 1 2003 8:27pm
Subject:RE: Red Hat rpms...
View as plain text  
If on 'localhost ' -- mysqladmin -u root password 'newpassword' , where 
password is the constant "password". ;-)

tcp
tanstaafl




Curtis Maurand <curtis@stripped>
05/01/2003 12:58 PM
 
        To:     "Slighter, Tim" <tslighter@stripped>
        cc:     "'mysql@stripped'" <mysql@stripped>
        Subject:        RE: Red Hat rpms...



thats if you've managed to get in in the first place.


On Thu, 1 May 2003, Slighter, Tim wrote:

> easiest way I know to set the root password is:
> 
> mysql> set password for 'root'@'localhost'=PASSWORD('newpassword');
> 
> 
> -----Original Message-----
> From: shrek-m@stripped [mailto:shrek-m@stripped]
> Sent: Thursday, May 01, 2003 8:50 AM
> To: mysql@stripped
> Subject: Re: Red Hat rpms...
> 
> 
> Mike Chambers schrieb:
> > Hello-
> > 
> > Has anyone successfully installed MySQL using rpms for
> > Red Hat 8?
> > 
> > The rpm install seems to work fine. However, I am
> > stumped when it somes to setting the initial root
> > password. I have tried every derivation of "mysqladmin
> > -u [user] -p [password]" that I can think of and still
> > cannot gain access. What is the initial username?
> > Initial password?
> 
> root, no_password  :-)
> 
> without_password you do not need  -p
> later you can use  -p  or  -pyour_password
> 
> you can connect with
> $mysql -uroot -h localhost
> mysql> set password = password('new_password');
> Query OK, 0 rows affected (0.01 sec)
> 
> mysql>grant all privileges on *.* to 'user'@'host_or_ip' identifid by 
> 'your_password';
> 
> mysql> show grants for user@host_or_ip;
> 
> 
> revoke, ...
> select, alter, update, use, show, ...
> 
> 
> 
> > Am I using the right method to
> > change it?
> > 
> 
> $man mysqladmin
> 
> > Any help for a clueless newbie?
> 
> 
> 
> lynx /usr/share/doc/mysql-*/manual.html
> http://www.mysql.com/documentation/index.html
> 
> http://www.mysql.com/products/mysqlcc/index.html
> 
> 

-- 
--
Curtis Maurand
mailto:curtis@stripped
http://www.maurand.com



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1



Thread
Red Hat rpms...Mike Chambers1 May
  • Re: Red Hat rpms...gerald_clark1 May
  • Re: Red Hat rpms...shrek-m@gmx.de1 May
RE: Red Hat rpms...John Griffin1 May
  • Fails: MultipleStatements in StringsTheMechE1 May
    • Re: Fails: MultipleStatements in StringsMark Matthews1 May
    • Re: Fails: MultipleStatements in StringsKeith C. Ivey1 May
      • Re: Fails: MultipleStatements in StringsMark Matthews1 May
RE: Red Hat rpms...James Marcinek1 May
  • RE: Red Hat rpms...Curtis Maurand1 May
    • RE: Red Hat rpms...Curtis Maurand1 May
RE: Red Hat rpms...John Griffin1 May
  • RE: Red Hat rpms...Curtis Maurand1 May
RE: Red Hat rpms...Tim Slighter1 May
  • RE: Red Hat rpms...Curtis Maurand1 May
    • RE: Red Hat rpms...Tom.Prouty2 May
      • RE: Red Hat rpms...Curtis Maurand2 May