to help the mysqld_safe 'finish' you'll need to append an '&' to your
command, which will have the process start in the background and give you
your prompt back.
/usr/local/mysql/bin/mysqld_safe --skip-grant-tables &
now you can hit the enter key, and you'll get your prompt back and
the server will still be running.
although i'd heed the warnings about runnign your server as root.
hth
Jeff
Parminder Singh
Chauhan To: MySql <[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
t.com> Subject: RE: Change of root password
10/29/2003 01:30
PM
I can't get through
I am doing as follow. Is it right or I am doing something wrong?
[EMAIL PROTECTED]
parminder]# /usr/local/mysql/share/mysql/mysql.server stop
Killing mysqld with pid 31796
Wait for mysqld to exit\c
done
I can't use mysqld
[EMAIL PROTECTED] parminder]# /usr/local/mysql/libexec/mysqld
--skip-grant-tables
Fatal error: Please read "Security" section of the manual to
find out how to run mysqld as root!
031029 18:10:34 Aborting
031029 18:10:34 /usr/local/mysql/libexec/mysqld: Shutdown
Complete
But when i use mysqld_safe session never finishes. Any way mysql server
is started. I have to close the console and start it again.
[EMAIL PROTECTED] parminder]# /usr/local/mysql/bin/mysqld_safe
--skip-grant-tables
Starting mysqld daemon with databases from /usr/local/mysql/var
I can't find what is going wrong
On Tue, 2003-10-28 at 18:51, Barry Byrne wrote:
> > -----Original Message-----
> > From: Parminder Singh Chauhan [mailto:[EMAIL PROTECTED]
>
> >
> > After long struggle I (A newbee to linux) was able to setup mysql4.0.16
> > and I don't know what I have done, I set the root password which I
don't
> > know. Now I can't access the mysql.
> > Is there anyway of changing root password.? and how?
>
> Start mysqld with the --skip-grant-tables option.
> Change the password
> and then run 'mysqladmin flush-privileges' to make the change take
effect.
>
> - Barry
--
Parminder Singh Chauhan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
