[cobalt-users] mySQL root password

["Craig S. N." <spikeone@xxxxxxxxxxxxxx>]

Manuel,

mySQL will ask (encourage) you to set a root password right after the mySQL
database has been installed and fired up for the first time.  Here's some
commands you might find useful that I've discovered from my research in the
mySQL newsgroup..

- mySQL Login:   mysql -uroot -pxxxxxxx
- mySQL Admin Login (root):   mysqladmin -uroot -pxxxxxxx
- Shut Down mySQL Server:   mysqladmin -uroot -pxxxxxxx shutdown
- Change admin password:   mysqladmin -uroot -poldpassword password
newpassword
- Login to db:   mysql -uroot -pxxxxxxx mysql
- Start mySQL Server:   safe_mysqld --log &
- Display Variables:   mysqladmin variables
- Display Version:   mysqladmin version
- Simple Test 1:   mysqlshow
- Simple Test 2:   mysqlshow mysql
- Simple Test 3:   mysql -e "select host,db,user from db" mysql

Cheers,
Craig Napier


> ----- Original Message -----
> From: manitu <manitu@xxxxxxxxxx>
> To: Cobalt Mailinglist <cobalt-users@xxxxxxxxxxxxxxx>
> Sent: Wednesday, February 09, 2000 9:01 PM
> Subject: [cobalt-users] mySQL root password
>
>
> > Hello all,
> >
> > I just found in the mailing list archive that there's a root
> password for
> > mysql. I cannot remember to have entered such a password when
> installing.
> > How can I check what the current setting is ?
> >
> > Manuel