|
Home > Archive > MySQL ODBC Connector > September 2005 > I forgot the admin password
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
I forgot the admin password
|
|
| Luis Garay 2005-09-21, 11:24 am |
| ------=_Part_385_11141324.1127312851503
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
hi
im pretty newbie in mysql. i installed this in my computer few weeks ago an=
d
today i want to begin practicing and i cant log in . i suppose i forget the
rigth password, how can a blank this??
thank you
lgaray
------=_Part_385_11141324.1127312851503--
| |
| Johan Höök 2005-09-21, 11:24 am |
| -------------- 02040100080708040203
0608
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Hi Luis,
you can start your server with --skip-grant-tables
see:
http://dev.mysql.com/doc/mysql/en/p...es-options.html
/Johan
Luis Garay wrote:
> hi
> im pretty newbie in mysql. i installed this in my computer few weeks ago and
> today i want to begin practicing and i cant log in . i suppose i forget the
> rigth password, how can a blank this??
>
> thank you
> lgaray
>
>
>
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.344 / Virus Database: 267.11.3/107 - Release Date: 2005-09-20
-------------- 02040100080708040203
0608
Content-Type: text/plain; charset=us-ascii
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
-------------- 02040100080708040203
0608--
| |
|
|
|
|
|
|
| Martijn Tonies 2005-09-21, 1:26 pm |
|
>
> That will not work !! MySQL doesnt delete an existing database. No
> offense, but you should have known better as professional.
>
> "--skip-grant-tables" is what the original user wanted to know.
Well, given that the OP only said " I installed it a few weeks ago
and now I want to start practicing ", it doesn't really matter...
Just reinstall it and you're fresh to go, right?
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www. databasedevelopmentf
orum.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| SGreen@unimin.com 2005-09-21, 1:26 pm |
| --=_alternative 0063C04C85257083_=
Content-Type: text/plain; charset="US-ASCII"
"Martijn Tonies" <m.tonies@upscene.com> wrote on 09/21/2005 01:56:16 PM:
>
>
> Well, given that the OP only said " I installed it a few weeks ago
> and now I want to start practicing ", it doesn't really matter...
>
> Just reinstall it and you're fresh to go, right?
NO! depending on how the Luis installed MySQL in the first place (which
method was used), the "uninstaller" may not remove or overwrite the
mysql.user table rendering this exercise fruitless as well as being
overkill. I understand you work with many databases other than MySQL and
for some of them the only way to recover from a lost admin password would
be to remove/replace/restore. However, in this case Valentin was correct.
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS
SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www. databasedevelopmentf
orum.com
>
Respectfully,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 0063C04C85257083_=--
| |
| Martijn Tonies 2005-09-21, 1:26 pm |
| >> > > Uninstall, reinstall.
>
>NO! depending on how the Luis installed MySQL in the first place (which
method was used), the "uninstaller" may not remove or >overwrite the
mysql.user table rendering this exercise fruitless as well as being
overkill. I understand you work with many >databases other than MySQL and
for some of them the only way to recover from a lost admin password would be
to >remove/replace/restore. However, in this case Valentin was correct.
Right -- perhaps I should have mentioned: uninstall and delete everything
:-)
Done that a couple of times myself...
I understand that Valentin is correct for the "normal" approach, especially
when you have a running server and/or databases.
I kinda figured, the fastest way (without having to search for an e-mail
list), would be just to reinstall the thing. MySQL - on Windows - has a
very nice install these days, kudos for that.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www. databasedevelopmentf
orum.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| valentin_nils@be-known-online.com 2005-09-21, 8:23 pm |
| Martijn,
sorry if I sounded perhaps unfriendly. That was not against you.
Imagine that many people read the list (+20.000), some which read this
which might take your word for granted and just do as you told ;-).
I just wanted to clear that before it becomes practice. I understand that
in an Microsoft environment it is usual practice to reinstall software
when the original cause cant be find. Unfortunately that is poor practice.
If feasable, it is important to understand what the original cause is and
how to stop it, rather than fixing around it.
Reinstalling an
This time its perhaps not REAL data but when disaster strikes, often there
is not much time to "learn" how it should have been done - mostly that
means it is already to late. Its important to learn how to do it proberly
with test data BEFORE disaster strikes.
O.K I believe you got my points. Again, didnt mean to hurt anybody. Peace ;-)
Best regards
Nils Valentin
Tokyo / Japan
http://www.be-known-online.com
> method was used), the "uninstaller" may not remove or >overwrite the
> mysql.user table rendering this exercise fruitless as well as being
> overkill. I understand you work with many >databases other than MySQL and
> for some of them the only way to recover from a lost admin password would
> be
> to >remove/replace/restore. However, in this case Valentin was correct.
>
> Right -- perhaps I should have mentioned: uninstall and delete everything
> :-)
> Done that a couple of times myself...
>
> I understand that Valentin is correct for the "normal" approach,
> especially
> when you have a running server and/or databases.
>
> I kinda figured, the fastest way (without having to search for an e-mail
> list), would be just to reinstall the thing. MySQL - on Windows - has a
> very nice install these days, kudos for that.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www. databasedevelopmentf
orum.com
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| valentin_nils@be-known-online.com 2005-09-21, 8:23 pm |
| Martijn,
sorry if I sounded perhaps unfriendly. That was not against you.
Imagine that many people read the list (+20.000), some which read this
which might take your word for granted and just do as you told ;-).
I just wanted to clear that before it becomes practice. I understand that
in an Microsoft environment it is usual practice to reinstall software
when the original cause cant be find. Unfortunately that is poor practice.
If feasable, it is important to understand what the original cause is and
how to stop it, rather than fixing around it.
Reinstalling an application, probably deleting the database would be a
last desperate step for me personally.
This time its perhaps not REAL data but when disaster strikes, often there
is not much time to "learn" how it should have been done - mostly that
means it is already to late. Its important to learn how to do it proberly
with test data BEFORE disaster strikes.
O.K I believe you got my points. Again, didnt mean to hurt anybody. Peace ;-)
Best regards
Nils Valentin
Tokyo / Japan
http://www.be-known-online.com
> method was used), the "uninstaller" may not remove or >overwrite the
> mysql.user table rendering this exercise fruitless as well as being
> overkill. I understand you work with many >databases other than MySQL and
> for some of them the only way to recover from a lost admin password would
> be
> to >remove/replace/restore. However, in this case Valentin was correct.
>
> Right -- perhaps I should have mentioned: uninstall and delete everything
> :-)
> Done that a couple of times myself...
>
> I understand that Valentin is correct for the "normal" approach,
> especially
> when you have a running server and/or databases.
>
> I kinda figured, the fastest way (without having to search for an e-mail
> list), would be just to reinstall the thing. MySQL - on Windows - has a
> very nice install these days, kudos for that.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www. databasedevelopmentf
orum.com
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Luis Garay 2005-09-22, 3:23 am |
| ------ =_Part_1610_11305797
.1127354998865
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Thanks to all. This was a Linux machine and im also learning how to interac=
t
with this so iwill try to do all you said. Thanks.
lgaray
On 9/21/05, valentin_nils@be-known-online.com <
valentin_nils@be-known-online.com> wrote:
>
> Martijn,
>
> sorry if I sounded perhaps unfriendly. That was not against you.
>
> Imagine that many people read the list (+20.000), some which read this
> which might take your word for granted and just do as you told ;-).
>
> I just wanted to clear that before it becomes practice. I understand that
> in an Microsoft environment it is usual practice to reinstall software
> when the original cause cant be find. Unfortunately that is poor practice=
..
>
> If feasable, it is important to understand what the original cause is and
> how to stop it, rather than fixing around it.
>
> Reinstalling an
>
> This time its perhaps not REAL data but when disaster strikes, often ther=
e
> is not much time to "learn" how it should have been done - mostly that
> means it is already to late. Its important to learn how to do it proberly
> with test data BEFORE disaster strikes.
>
> O.K I believe you got my points. Again, didnt mean to hurt anybody. Peace
> ;-)
>
>
> Best regards
>
> Nils Valentin
> Tokyo / Japan
> http://www.be-known-online.com
>
>
> and
> would
> everything
l[color=darkred]
> SQL
>
>
------ =_Part_1610_11305797
.1127354998865--
| |
| Martijn Tonies 2005-09-22, 3:23 am |
| Hello Nils,
> sorry if I sounded perhaps unfriendly. That was not against you.
>
> Imagine that many people read the list (+20.000), some which read this
> which might take your word for granted and just do as you told ;-).
No worries, I should have stated that --in this particular case--
(to me) this would be a solution for the problem.
Obviously, in a working environment, this wouldn't be a correct
answers and I stand fully corrected on that :-)
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www. databasedevelopmentf
orum.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| dagdabrona@hotmail.com 2005-09-27, 1:23 pm |
| Hi,
If you wish to restore or change your pass, you can use Password
Changer tool. It is really great and saved me couple a times. Give it a
try!!
http://www.password-changer.com/
|
|
|
|
|