December 16, 2017, 06:49:36 PM

News : LinuxSolved.com Linux Help Community Forum..


Author Topic: Setting the root password for MySQL  (Read 3469 times)

Offline vwvr9

  • New Member
  • Posts: 3
Setting the root password for MySQL
« on: January 24, 2007, 11:36:04 AM »
I just installed MySQL version 4.1.20 on my CentOS 4.4 server. The default install of MySQL server uses a blank password for root so I had to have it changed. I also set the MySQL service to start up every time my machine boots up.

This is how I did it;

Method 1
Code: [Select]

1. # yum -y install mysql-server (This will install the mysql binaries)
2. # chkconfig mysqld on (Adds mysqld to the startup services)
3. # service mysqld start (Starts the MySQL server)
4. # mysql -u root@localhost (Brings up the MySQL console)
5. #mysql> set password for root@localhost=password(’password’); (Sets the root password to “password”)
6. #mysql> reload privileges; (Reloads the grant tables)

Method 2
Code: [Select]

1. # mysql -u root@localhost (Brings up the MySQL console)
2. #mysql> use mysql (Use the mysql database)
3. #mysql> update user
              -> set password=password(”password”) (Sets the root password to “password”)
              -> where user=”root”;
4. # reload privileges; (Reloads the grant tables)

That’s it, the next time you want to get the MySQL console up you’ll have to run #mysql -u root -p to get the password prompt.

source: the danesh project tech blog

Offline gauravbajaj

  • LST CareTaker
  • Experienced
  • *****
  • Posts: 658
Setting the root password for MySQL
« Reply #1 on: January 26, 2007, 08:01:05 PM »
Yeah

You are right ..but  we can also use this command

#mysqladmin -u root password "newpassowrd"


Thanks
Gaurav