Advanced Search

Return to Snippet

Revision: 36576
at November 23, 2010 11:19 by isholgueras
Initial Code 
#From bash
#Stop mysql service
$> service mysqld stop
#Start mysql "for free". Seems dangerous :P
$> mysqld_safe --skip-grant-tables --skip-networking &

$> mysql -uroot
mysql> use mysql;
mysql> UPDATE user SET password=PASSWORD('nuevo_pass') WHERE user='root';
mysql> quit;

$> service mysqld restart
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
How to reset a root password in mysql with OS root user

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Reset root password in MySQL

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL