stumbleupon toolbar
Make payments with PayPal - it's fast, free and secure!
This site is up for
Count
Get Firefox!
Last Shout - Posted by: acelere - Sunday, 10 June 2018 21:59
Just passed by to say hello!

  Reply to this topicStart new topicStart Poll

> reset mySQL root password, in case you've lost it...
dingetje
Posted: Oct 21 2003, 03:42 PM
Quote Post


Administrator
*****

Group: Admin
Posts: 713
Member No.: 1
Joined: 24-August 02



if you get an error like:

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

when you try to gain access to mySQL database (either via mysql or mysqladmin) and you cannot remember what your mySQL password was for user 'root' then follow this procedure to set the password to a known value:

QUOTE
[Linux] rc_mySQL stop
[Linux] fork /path/to/safe_mysqld --skip-grant-tables
[Linux] mysql -uroot mysql
mysql> update user set password=PASSWORD('your_new_password') where user='root';
Query OK, 2 rows affected (0.13 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> exit;
Bye
[Linux] rc_mySQL restart


for FREESCO 03x /path/to = /usr/local/mySQL/bin
for FREESCO 027 /path/to = /mnt/router/packages/mySQL/bin

your_new_password can also be empty:

QUOTE
mysql> update user set password=PASSWORD('') where user='root';


--------------------
PMEmail PosterUsers WebsiteICQ
Top
phbc50
Posted: Sep 18 2005, 05:51 AM
Quote Post


Advanced Member
***

Group: Members
Posts: 39
Member No.: 66
Joined: 8-June 03



Hello,
For mysql-4.1.7a-lightning, the safe_mysqld is replaced by mysqld_safe
So use
CODE
fork /path/to/mysqld_safe --skip-grant-tables

instead of
CODE
fork /path/to/safe_mysqld --skip-grant-tables

in the howto above.
Remark :
with this package : /path/to = /usr/local/mysql/bin (all lower case).

phbc50
PMEmail Poster
Top
0 User(s) are reading this topic (0 Guests and 0 Anonymous Users)
0 Members:

Topic Options Reply to this topicStart new topicStart Poll

 



[ Script Execution time: 0.3209 ]   [ 11 queries used ]   [ GZIP Enabled ]   [ Server Load: 1.62 ]


FREESCO WebRing
The FREESCO Router WebRing
[ Join Now | Ring Hub | Random | << Prev | Next >> ]

Nedstat Basic - Gratis web site statistieken
Eigen homepage website teller


MKPortal ©2003-2006 mkportal.it
Page generated in 0.808 seconds with 13 queries