Jun 092010
On many occasions, I forgot the password of the user Administrator (root) of me Mysql server, may be that Why was not the administrator?, but good if you get local access to the system, you can use the following instructions, to obtain the administrator access.
Option 1:
#the easiest is run mysqladmin using the following instruction. "Mysql Path" /mysqladmin -u root password "new password" #without quote #where the common path on windows system is: c:\mysqlbin or c:\Archivos de programa\mysql\bin #on linux system is: /usr/bin or /usr/local/bin or (sbin) in some case.
Option 2:
#Other option is stop the mysql service using: mysql stop #after, open mysql on safe mode: safe_mysql --skip-grant-table & #run the mysql client and update the user table on db mysql changing the user password.
$ USE mysql;
$ UPDATE user SET password=PASSWORD('new password') WHERE user='root';
$ flush privileges;
get out using “exit” on the client and restart the mysql service.
the first options is most recommendable, but in occasions is better to have alternatives.
NOTE: Sorry for my english, but i am learning. I accept corrections.
(NOTE: was migrated of the old site)


English
Español
Français
Italiano
Русский