Re: Password error
Someone the other day said this worked:
started safe_mysqld with --skip-grant-tables and then did:
mysql -u root mysql
mysql> UPDATE user SET password=PASSWORD('abc') WHERE User='root'
-> AND Host='whichever host you want to match'
- Original Message -
From: "Mike Ryerse" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 06, 2001 12:23 PM
Subject: Password error
> I have resently installed mysql 3.23.41 on Redhat 7.1
>
> When I installed it, I could access the example
> databases 'mysql' and 'test'. Mysql said to change
> the root password right away with :
> mysqladmin -h host -u root -p password 'new password'
>
> so I did it, but now mysql won't let me log in as any
> user, not even root.
>
> I have tried to re-install with rpm -i --force, and
> uninstall with rpm -e, neither will change the
> permissions of mysql.
>
> What should I do?
>
> -Mike Ryerse
>
> __
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant messaging with Yahoo!
Messenger
> http://im.yahoo.com
>
> -
> 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
>
-
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
USE UPDATE and root password
> Also remember to set your root password! Check the manual for this as
well.
Yeah, right... That's easier said than done!
I'm still chasing my tail from using the erroneous commands the install said
to use.
Speaking of which, someone thankfully told me to do a USE mysql before using
the UPDATE command, which then returned yet another error:
mysql> USE mysql
Database changed
mysql> UPDATE user SET Password=PASSWORD("letmein") WHERE User="root"
ERROR 1175: You are using safe update mode and you tried to update a table
without a WHERE that uses a KEY column
So any ideas that get me fixed up will be rewarded by copius quantities of
liquor and massages! ;)
Using GRANT though, I can get root password set up, but only until
restarting server.
Now for the Snitz Forum 2000 part (that's why I'm using MySQL and
Chili!ASP). Snitz says I need to start an empty database prior to running
setup.asp, yet I believe Snitz looks to this database for the user/password.
When I do a mysqladmin create blahbblah, it just make a directory, is that
an empty database? I would have thought it at least had some files, ie.
tables and such but without any info in them.
If I run setup.asp it says I need to logon first.
This is the Snitz error when running setup.asp?RC=5 after I add root and
root password where indicated:
=
Please Wait until the installation has been completed !
Error:
3704
strSql:
DROP TABLE IF EXISTS FORUM_CATEGORY
Error:
3704
strSql:
CREATE TABLE FORUM_CATEGORY ( CAT_ID INT (11) DEFAULT ''
NOT NULL auto_increment, CAT_STATUS SMALLINT (6) DEFAULT
'1'
NOT NULL , CAT_NAME VARCHAR (100), CAT_MODERATION int
(11) DEFAULT '0', CAT_SUBSCRIPTION int (11) DEFAULT '0',
CAT_ORDER int (11) DEFAULT '1', PRIMARY KEY (CAT_ID),
KEY
FORUM_CATEGORY_CAT_ID(CAT_ID), KEY
FORUM_CATEGORY_CAT_STATUS (CAT_STATUS) )
===
... and many more 3704 errors
Now if I enter root and leave password blank, it says Installation Complete
and has a test database link, I take the link and it's back to the "need to
logon" error page.
I am posting this at the Snitz forum and the mysql list.
Thank you very much,
eeehaah/Gregg Baker
-
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
Re: Problems getting into MySQL.com
yes, i just tried and failed - Original Message - From: "Philip Daggett" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 9:50 AM Subject: Problems getting into MySQL.com > Is anybody else not able to get onto mysql.com??? > > > - > 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 > - 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
Re: Root password revisited
Hi all, I got a "No Database Chosen". What's the syntax for adding the
database? I tried *.*, mysql, and test between UPDATE and user but all
returned syntax error.
Thanks much, Gregg
UPDATE user SET Password=PASSWORD("desiredpasswordhere") WHERE User="root";
-
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
Root password revisited
Hi all, I just joined list. I spent a couple hours in the archive and
decided MySQL better improve their install message regarding setting the
root password! Half the posts are about it going badly. ;)
I believe I found the answer in the archives, but they all aren't the same
answer. So is the concensus for resetting the root password, whether it was
set or not the following?
If it is, add it to your binaries! (I'm actually quite friendly and patient
:)
root# ./bin/safe_mysqld --user=mysql --skip-grant-tables &
root# ./bin/mysql -u root -p
Enter password: (hit return at this point)
> UPDATE user SET Password=PASSWORD("desiredpasswordhere") WHERE
User="root";
> Exit
root# ./bin/mysqladmin flush-privileges
root# ./bin/mysql -u root -p
Enter password: desiredpasswordhere
-
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
