Re: error with mysql when doing mysql -u root
On Sat, 20 Sep 2003 10:31:43 -0700 "Shawn Guillemette" <[EMAIL PROTECTED]> wrote: > is there a way to reset the mysql root user passwd? I'm starting to > wonder if I finger mumbled the passwd or something.. Start mysql with --skip-grant-tables Please red the docs. IOnut -- IOnut FreeBSD unregistered ;) user ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: error with mysql when doing mysql -u root
Hi,
Hi,
If you have set a root password, but forgot what it was, you can set a new
password with the following procedure:
1) Take down the mysqld server by sending a kill (not kill -9) to the mysqld
server. The pid is stored in a `.pid' file, which is normally in the MySQL
database directory:
shell> kill `cat /mysql-data-directory/hostname.pid`
You must be either the Unix root user or the same user mysqld runs
as to do this.
2) Restart mysqld with the --skip-grant-tables option.
3) Set a new password with the mysqladmin password command:
shell> mysqladmin -u root password 'mynewpassword'
4) Now you can either stop mysqld and restart it normally, or just load the
privilege tables with:
shell> mysqladmin -h hostname flush-privileges
5) After this, you should be able to connect using the new password.
Alternatively, you can set the new password using the mysql client:
1) Take down and restart mysqld with the --skip-grant-tables option as
described above.
2) Connect to the mysqld server with:
shell> mysql -u root mysql
3) Issue the following commands in the mysql client:
mysql> UPDATE user SET Password=PASSWORD('mynewpassword') WHERE
User='root';
mysql> FLUSH PRIVILEGES;
4) After this, you should be able to connect using the new password.
5) You can now stop mysqld and restart it normally.
Regards
SSR
Regards
SSR
From: "Shawn Guillemette" <[EMAIL PROTECTED]>
To: "Kevin Kinsey" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: error with mysql when doing mysql -u root
Date: Sat, 20 Sep 2003 10:00:39 -0700
like this ?
# mysql -u root -p password
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
if so is there a way I can reset the "root"' passwd for mysql?
I have tried mysqladmin -u root passowrd newpassword and get this
Shawn
- Original Message -
From: "Kevin Kinsey" <[EMAIL PROTECTED]>
To: "Shawn Guillemette" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, September 20, 2003 6:42 AM
Subject: Re: error with mysql when doing mysql -u root
> On Sat, Sep 20, 2003 at 08:55:30AM -0700, Shawn Guillemette wrote:
> > After setting the mysql root user passwd I get this when trying to log
in.
> >
> > # mysql -u root
> > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
> >
> > Just after the install of mysql I had created a database as a test
successfully..
> >
> IIRC, it's: 'mysql -u root -p mypassword'
>
> HTH,
>
> Kevin Kinsey
>
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to
"[EMAIL PROTECTED]"
_
A chance to meet Aishwarya Rai. http://www.myenjoyzone.com/msn/knk.php3 Win
lucky prizes.
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: error with mysql when doing mysql -u root
On Saturday, Sep 20, 2003, at 12:06 US/Eastern, Jan van Stekelenburg wrote: On Sat, Sep 20, 2003 at 10:31:43AM -0700, Shawn Guillemette wrote: is there a way to reset the mysql root user passwd? I'm starting to wonder if I finger mumbled the passwd or something.. It's written here: http://www.mysql.com/doc/en/Resetting_permissions.html Good luck. Jan. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]" Shawn, After you reset your MySQL root user password, did you reload the tables so that your new password would be recognized? That is done using either of the following: mysqladmin -u root reload mysqladmin -u root flush-privileges NOTE: The "-u root" portion is based on an assumption that prior to changing your password, the password had been blank. Regards, -- Barry C. Hawkins All Things Computed site: www.allthingscomputed.com/ weblog: www.allthingscomputed.com/blog/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: error with mysql when doing mysql -u root
On Sat, Sep 20, 2003 at 10:31:43AM -0700, Shawn Guillemette wrote: > is there a way to reset the mysql root user passwd? I'm starting to wonder > if I finger mumbled the passwd or something.. It's written here: http://www.mysql.com/doc/en/Resetting_permissions.html Good luck. Jan. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: error with mysql when doing mysql -u root
is there a way to reset the mysql root user passwd? I'm starting to wonder if I finger mumbled the passwd or something.. shawn - Original Message - From: "Jan van Stekelenburg" <[EMAIL PROTECTED]> To: "Shawn Guillemette" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, September 20, 2003 7:27 AM Subject: Re: error with mysql when doing mysql -u root > On Sat, Sep 20, 2003 at 08:55:30AM -0700, Shawn Guillemette wrote: > > After setting the mysql root user passwd I get this when trying to log in. > > > > # mysql -u root > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) > > You forgot the -p option. > For more info: http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Connecting-disconnecting > > Also reading man-pages never hurt. ;-) > > Jan. > ___ > [EMAIL PROTECTED] mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" > ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: error with mysql when doing mysql -u root
# mysql -u root -p test Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) thasts what i got when I tried that - Original Message - From: "Kevin Kinsey" <[EMAIL PROTECTED]> To: "Shawn Guillemette" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, September 20, 2003 6:42 AM Subject: Re: error with mysql when doing mysql -u root > On Sat, Sep 20, 2003 at 08:55:30AM -0700, Shawn Guillemette wrote: > > After setting the mysql root user passwd I get this when trying to log in. > > > > # mysql -u root > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) > > > > Just after the install of mysql I had created a database as a test successfully.. > > > IIRC, it's: 'mysql -u root -p mypassword' > > HTH, > > Kevin Kinsey > ___ > [EMAIL PROTECTED] mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" > ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: error with mysql when doing mysql -u root
On Sat, Sep 20, 2003 at 08:55:30AM -0700, Shawn Guillemette wrote: > After setting the mysql root user passwd I get this when trying to log in. > > # mysql -u root > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) You forgot the -p option. For more info: http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Connecting-disconnecting Also reading man-pages never hurt. ;-) Jan. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: error with mysql when doing mysql -u root
On Sat, Sep 20, 2003 at 08:55:30AM -0700, Shawn Guillemette wrote: > After setting the mysql root user passwd I get this when trying to log in. > > # mysql -u root > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) > > Just after the install of mysql I had created a database as a test successfully.. > IIRC, it's: 'mysql -u root -p mypassword' HTH, Kevin Kinsey ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: error with mysql when doing mysql -u root
like this ? # mysql -u root -p password Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) if so is there a way I can reset the "root"' passwd for mysql? I have tried mysqladmin -u root passowrd newpassword and get this Shawn - Original Message - From: "Kevin Kinsey" <[EMAIL PROTECTED]> To: "Shawn Guillemette" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, September 20, 2003 6:42 AM Subject: Re: error with mysql when doing mysql -u root > On Sat, Sep 20, 2003 at 08:55:30AM -0700, Shawn Guillemette wrote: > > After setting the mysql root user passwd I get this when trying to log in. > > > > # mysql -u root > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) > > > > Just after the install of mysql I had created a database as a test successfully.. > > > IIRC, it's: 'mysql -u root -p mypassword' > > HTH, > > Kevin Kinsey > ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
