I set up mysql on my new macbook.

no problem there, everything works fine...BUT THEN

I accidentally added in passwords as plain text....directly into the
db

now when i try to login i cannot because i dont know what the reverse
of my password is? I tried to just over ride it, but I apparently
cannot do that at all...im wondering if there is a way to uninstall
mysql on mac os x (leopard) so I can simply do it again, but this
time, add in the right string as my password?


any or suggestions are greatly appreciated!!

Edit/Delete Message

On Jan 7, 10:36 pm, Bunsenator <Auston.Bun...@gmail.com> wrote:
> I set up mysql on my new macbook.
>
> no problem there, everything works fine...BUT THEN
>
> I accidentally added in passwords as plain text....directly into the
> db
>
> now when i try to login i cannot because i dont know what the reverse
> of my password is? I tried to just over ride it, but I apparently
> cannot do that at all...im wondering if there is a way to uninstall
> mysql on mac os x (leopard) so I can simply do it again, but this
> time, add in the right string as my password?
>
> any or suggestions are greatly appreciated!!
>
> Edit/Delete Message
Forgot to add, I get this output when I try to start mysqld with no
credentials i run this:
'/usr/local/mysql/bin/mysqld_safe --skip-grant-tables ==user=root'

and get this:
'touch: /usr/local/mysql/data/auston-bunsens-macbook.local.err:
Permission denied
chown: /usr/local/mysql/data/auston-bunsens-macbook.local.err:
Permission denied
Starting mysqld daemon with databases from /usr/local/mysql/data
/usr/local/mysql/bin/mysqld_safe: line 380: /usr/local/mysql/data/
auston-bunsens-macbook.local.err: Permission denied
rm: /usr/local/mysql/data/auston-bunsens-macbook.local.pid: Permission
denied
/usr/local/mysql/bin/mysqld_safe: line 388: /usr/local/mysql/data/
auston-bunsens-macbook.local.err: Permission denied
STOPPING server from pid file /usr/local/mysql/data/auston-bunsens-
macbook.local.pid
tee: /usr/local/mysql/data/auston-bunsens-macbook.local.err:
Permission denied
080107 23:01:33 mysqld ended
tee: /usr/local/mysql/data/auston-bunsens-macbook.local.err:
Permission denied
'

any ideas?

On Mon, 7 Jan 2008 19:36:20 -0800 (PST), Bunsenator
<Auston.Bunsen@gmail.com> wrote:

>
>I set up mysql on my new macbook.
>
>no problem there, everything works fine...BUT THEN
>
>I accidentally added in passwords as plain text....
>directly into the db
>
>now when i try to login i cannot because i dont know what the reverse
>of my password is? I tried to just over ride it, but I apparently
>cannot do that at all...im wondering if there is a way to uninstall
>mysql on mac os x (leopard) so I can simply do it again, but this
>time, add in the right string as my password?
>
>
>any or suggestions are greatly appreciated!!

http://dev.mysql.com/doc/refman/5.0/...rmissions.html
--
( Kees
)
c[_] As scarce as truth is, the supply has
always been in excess of demand. (#351)