Hi!
On Sep 15, Ronald Willis wrote:
> Hello Serg,
>
> I have a quick question. I am new to MySQL but not databases. I have
> installed a default installation of MySQL with Mandrake 8.0. It runs but for
> the life of me I cannot remember the password for any user including root.
>
> I was able to (what appeared) change the password for root and other users
> via webmin!
> But not so.
>
> So I went in and removed the MySQL directory and other trace files
> (considering deps) and intalled from RPM, still it wont allow me to even log
> in. I have used the Sams book MySQL in 24 hours for starters, but cant get
> past the first darn chapter!
>
> I so dearly want to learn to use MySQL because of its fantastic capabilities
> and also for future project pending on my desk now.
>
> Please assist in the area of how to do a fresh install, either from source
> or rpm in a way to get this password problem resolved. BTW I have had the
> same problem serveral times in the past on other installs of Linux. It is
> now time for me to master the source and learn to admin the password files.
>
> I am not adverse to a fresh install of Mandrake again.
>
> Thanks.
First:
Unfortunately, I get too many e-mails to handle help requests
which are sent directly to me.
If you have purchased MySQL support, you may write to
[EMAIL PROTECTED], and will get an answer quickly. If you
would like to purchase support, please see the Support
section of our web site:
http://www.mysql.com/support/
If you do not want to purchase support, please send e-mail
to the appropriate mailing list. We host several mailing
lists related to MySQL:
http://www.mysql.com/documentation/lists.html
When you post your question, be sure to follow these hints
about how to ask effective questions:
http://www.mysql.com/documentation/mysql/commented/manual.php?section=Asking_questions
Second:
You definitely should not reinstall neither Mandrake nor MySQL.
Start mysqld with --skip-grant-tables option. This way mysqld
will give full access to every user. Change root password (and any other
passwords you like) then and FLUSH PRIVILEGES to cause mysqld
to read grant tables and enable privilege system.
And - read the manual. There's a section "Common errors", by the way.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
