IT dragons tamed since 2006 (with 735 solutions and growing)

[login]
[join]

your IP[54.81.71.8]




If you thought this solution was helpfull, please login and vote. Not a member? click here

ID727
TitleSetting, Changing And Resetting MySQL Root Passwords
Byjohn
Keywordsmysqladmin mysql
Categorymysql
Votes0
Views90
Score90
Date2016-12-22
Body
Setting, Changing And Resetting MySQL Root Passwords

Set up root password for the first time
=======================================

If you have never set a root password for MySQL, the server does not require a password at all for
connecting as root. To set up a root password for the first time, use the mysqladmin command at the
shell prompt as follows: $ mysqladmin -u root password newpass If you want to change (or update) a root password, then you need to use the following command: $ mysqladmin -u root -p oldpassword newpass Enter password: If you get... mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' then follow the instructions below on how to recover your MySQL password. Change MySQL password for other users ===================================== To change a normal user password you need to type: $ mysqladmin -u user-name -p oldpassword newpass Update or change password ========================= MySQL stores usernames and passwords in the user table inside the MySQL database. You can directly
update a password using the following method to update or change passwords: 1) Login to the MySQL server, type the following command at the shell prompt: $ mysql -u root -p 2) Use the mysql database (type commands at the mysql> prompt): mysql> use mysql; 3) Change password for a user: mysql> update user set password=PASSWORD("newpass") where User='ENTER-USER-NAME-HERE'; 4) Reload privileges: mysql> flush privileges; mysql> quit This method you need to use while using PHP or Perl scripting. Recover MySQL root password =========================== You can recover a MySQL database server password with the following five easy steps: Step # 1: Stop the MySQL server process. Step # 2: Start the MySQL (mysqld) server/daemon process with the --skip-grant-tables option so that
it will not prompt for a password. Step # 3: Connect to the MySQL server as the root user. Step # 4: Set a new root password. Step # 5: Exit and restart the MySQL server. Here are the commands you need to type for each step (log in as the root user): Step # 1 : Stop the MySQL service: # /etc/init.d/mysql stop Output: Stopping MySQL database server: mysqld. Step # 2: Start the MySQL server w/o password: # mysqld_safe --skip-grant-tables & Output: [1] 5988 Starting mysqld daemon with databases from /var/lib/mysql mysqld_safe[6025]: started Step # 3: Connect to the MySQL server using the MySQL client: # mysql -u root Output: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> Step # 4: Set a new MySQL root user password: mysql> use mysql; mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root'; mysql> flush privileges; mysql> quit Step # 5: Stop the MySQL server: # /etc/init.d/mysql stop Output: Stopping MySQL database server: mysqld STOPPING server from pid file /var/run/mysqld/mysqld.pid mysqld_safe[6186]: ended [1]+ Done mysqld_safe --skip-grant-tables Start the MySQL server and test it: # /etc/init.d/mysql start # mysql -u root -p
SharediggDigg this solutiondel.icio.usPost to del.icio.usSlashdotSlashdot it!email to a friend
PrintPrint This Solution Print
If you thought this solution was helpfull, please login and vote. Not a member? click here


Latest News

Thanks to Dave for hosting this site!

Paying the Rent



Advanced Search:

Choose body, keywords, title, or all to include in search 
words to include in search 
and(+)

Choose body, keywords, title, or all to include in search 
additional words to include in search 
not(-)

Choose body, keywords, title, or all to exclude in search 
words to exclude from search 


catagory
order by






diggDigg Dracko
del.icio.usPost to del.icio.us
SlashdotSlashdot us!




Don't forget to vote!
Powered by John Core
Bye!

Dracko by John Core

me

View John Core's profile on LinkedIn


Certifications
security logo saber ccsa logo ccna-logo hbss veritas

Technologies
oracle_logo
solaris_logo linux-logo openstack_logo vbox_logo splunk storagetek_logo sun_logo oraclevm_logo brocade_logo bsd_logo

Languages
c-logo bash-logo php-logo

Employers
PlanetPayment Medecision AWi PennStateHershey DISA DLA cim Sun

Consulting
KMBS PNC FBI CCS PTD Sentinel