CHEAP WEB HOSTING SERVICES AND AFFORDABLE LINUX WEB HOSTING PACKAGES WITH FREE DOMAIN NAME REGISTRATION

LINUX WEB HOSTING WITH PHP MYSQL TOMCAT SITE BUILDER FANTASTICO RVSKIN OSCOMMERCE AGORA CUBECART ZENCART PHPLIST PHP NUKE POSTNUKE

Forgot the MySQL root password :

First you will have to stop the MySQL service on the server.

# service mysqld stop

Start MySQL as

# /usr/bin/safe_mysqld –skip-grant-tables &

# /usr/bin/mysqld_safe –skip-grant-tables &

safe_mysqld is a script that starts mysqld and traps any forceful terminationof the MYSQL server and it privents any database corruption.

Change the password for root user as

# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD(’new_password’) WHERE user=’root’
mysql> FLUSH PRIVILEGES;
mysql> exit;

# service mysqld start

[link]

You must be logged in to post a comment.

Micfo International LLC Leading the hosting Industry with Cheap and Affordable Linux Web Hosting Packages.

Micfo, delivering the best cpanel web hosting with maximum reliability is our exclusive focus.
— Micfo International LLC

33 queries. 0.098 seconds