At 16:52 -0700 6/21/02, Cindy wrote:
>Bhavin Vyas writes:
> >Does the error file (hostname.err) have any messages?
>
>OK, I didn't think to look at this:
>020213 14:23:52 mysqld started
>/usr/local/mysql-3.23.47-sun-solaris2.8-sparc/bin/mysqld: ready for
>connections
>020430 17:09:08
>/usr/local/mysql-3.23.47-sun-solaris2.8-sparc/bin/mysqld: Norma
>l shutdown
>
>020430 17:09:09
>/usr/local/mysql-3.23.47-sun-solaris2.8-sparc/bin/mysqld: Shutd
>own Complete
>
>020430 17:09:09 mysqld ended
>
>
>So it looks like it shut down shortly after my last round with it. I can
>cope with that.
>
>OK, so in theory I should just be able to restart this, right?
>And when I restart, I have to reset the root password? So given that
No, just restart it. The password doesn't have to be reset.
Re: a previous question about the socket file vamoosing - yes, the server
removes it when it shuts down, and recreates it when it starts up next
time.
>the mysql user is mysql_st, I'd do the following:
>
>cd /usr/local/mysql
>bin/safe_mysqld --user=mysql_st
>bin/mysqladmin -u root password "kool"
>
>and then after that, this
>bin/mysql -u root -p
>would work?
>
>"kool", being of course just used illustratively :-)
>
>I dunno, it seems like I just wind up reinstalling. So if any of you
>see something I'm missing here, please feel free to pipe up...
>
>Thanks,
>--Cindy
