Percona’s industry-leading architecture design consultants have full stack expertise to build databases in hosted and private, public and hybrid cloud environments that are optimized and scale for growth while minimizing application downtime and operational costs.
This portion of tutorial we learn how to install percona database in CentOS 7.5 server and change default password
Installing Percona Server from Percona yum repository
|
1 |
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-6/percona-release-0.1-6.noarch.rpm
|
Install the packages. You can now install Percona Server by running
|
1 |
yum install Percona-Server-server-57
|
Running Percona Server:
Starting the service
|
1 |
service mysql start
|
Status of the service
|
1 |
service mysql status
|
Stopping the service
|
1 |
service mysql stop
|
Restarting the service
|
1 |
service mysql restart
|
After successfully install percona server 5.7 . It create a default password we need to get this default password and change it . To get this default password write this command
|
1 |
sudo grep "temporary password" /var/log/mysqld.log
|
Sample outputs of root user default password
|
1 |
[Note] A temporary password is generated for root@localhost: 0fR)jBZ*7j%k
|
Change Percona mysql default password
Enter mysql server using command line
|
1 |
mysql -u root -p
|
|
1 |
Then Enter password screen prompt write your desire password get from previous command in my case password is : 0fR)jBZ*7j%k
Then mysql coomand open then write this command
|
1 |
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
|
in new password section write your own choice password and click enter then write exit
Then enter previous step and write new password if you enter successfully then you are completely update percona database password successfully
|
1 |
mysql -u root -p
|
No more today
