RE: MySQL - Finding Out Root Password
- From: "Ken Perry" <whistler@xxxxxxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Sun, 4 May 2008 06:10:03 -0700
Ok in windows if you have set a root password I am not sure if you can find
the root password but if you have not set one then you just do
Mysql - u root
Do not put the -p because that will just freeze.
If you want to set one the command is
mysql> SET PASSWORD FOR root@localhost=PASSWORD('theOC');
I guess you could try setting it again and see if it will let you set a new
one.
Ken
-----Original Message-----
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Jim
Sent: Sunday, May 04, 2008 4:51 AM
To: programmingblind@xxxxxxxxxxxxx
Subject: Re: MySQL - Finding Out Root Password
Hi,
Thanks for the answers, but the original question was about MySQL on
Windows.
Jim
----- Original Message -----
From: "Sina Bahram" <sbahram@xxxxxxxxx>
To: <programmingblind@xxxxxxxxxxxxx>
Sent: Saturday, May 03, 2008 7:55 PM
Subject: RE: MySQL - Finding Out Root Password
> To amend this just a bit ... If you actually have a password set, this is
> not the case.
>
> Also, it might require you to do mysql -p, indicating that you will type
> in
> a password, but then not ask you for one.
>
> Take care,
> Sina
>
> ________________________________
>
> From: programmingblind-bounce@xxxxxxxxxxxxx
> [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Ken Perry
> Sent: Saturday, May 03, 2008 7:23 PM
> To: programmingblind@xxxxxxxxxxxxx
> Subject: RE: MySQL - Finding Out Root Password
>
>
>
>
> I just realized my reply might sound stupid if you don't realize I meant
> if
> your logged in as Root on your linux machine then you just use mysql and
> your in the root account with no password. It figures if your on the root
> account then you got access to everything.
>
> Ken
>
> ________________________________
>
> From: programmingblind-bounce@xxxxxxxxxxxxx
> [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Ken Perry
> Sent: Saturday, May 03, 2008 4:21 PM
> To: programmingblind@xxxxxxxxxxxxx
> Subject: RE: MySQL - Finding Out Root Password
>
>
>
>
> If you are logged in as root you don't need a password. You just use
> mysql
> with no user
>
> Ken
>
> ________________________________
>
> From: programmingblind-bounce@xxxxxxxxxxxxx
> [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Jim
> Sent: Saturday, May 03, 2008 11:00 AM
> To: programmingblind@xxxxxxxxxxxxx
> Subject: MySQL - Finding Out Root Password
>
>
> Hi,
> Does anyone know how to find out what a local Windows installation of
> MYSQL
> is trying to use as a root password if you don't know?
>
> Thanks.
>
> Jim
>
> __________
> View the list's information and change your settings at
> //www.freelists.org/list/programmingblind
>
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
