On Thu September 6 2007 19:30, Carl Hartung wrote:
> On Thu September 6 2007 09:14, Patrick Shanahan wrote:
> > on 10.1 but has been same afaict since 9.0.
>
> <snip>
>
> addendum...
>
> Hi Patrick, et al
>
> Changing the default 'config' entry to 'http' in line #71 changed
> *something* because I'm now getting a login prompt. But I started this
> project so long ago and got interrupted (of course) that I've forgotten if
> I already set a mysql root password. It won't let me log into either
> phpMyAdmin or set a password via CLI ;-)
<snip>
I reset my mysqld root password, as follows:
in shell 1:
# rcmysql stop
# killall mysqld
# mysqld --skip-grant-tables --user=root
in shell 2:
mysql
mysql> USE mysql
mysql> UPDATE user
-> SET password=password("new password") [put p/w between quotes]
-> WHERE user="root";
mysql> flush privileges;
mysql> exit;
su (then password)
#killall mysqld
exit
exit
All fixed. Thanks everyone!
Carl
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
