FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


How to Reset Password of root user in MySQL





limchivy
I have set password of user "root" at the first installation. Now, I forget this password, so I need some help to solve this problem for using MySql again. How do I change MySQL root Password?
Xaferrow
i haven't read it, but try this one

http://www.cmdln.org/2008/02/09/reset-mysql-root-password/
spring567
/usr/local/bin/safe_mysqld --skip-grant-tables & (old version)
/usr/local/bin/mysqld_safe --skip-grant-tables & (new version)

>use mysql
>update user set password=password("new_pass") where user="root";
>flush privileges;
>quit
Related topics
what is the myphp admin code?
How do you access phpmyadmin?
can't access local mysqlserver. help plz!
my advance guestbook doesnt work..
Installing Apache Php and MySQL [newbie tutorial]
Warning: mysql_connect(): Client does not support authentica
SQL user/password files in SMF
Database Privilege
Need help with mySQL
Never recived a reset password email
Database connection class!
CPanel Password won't reset
XP password expired!
How to bypass Vista Admininistrator password?
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.