Hello dear readers,
I’ve been checking the MySQL server options and new features which show that far from dying as many predicted when it fell under Oracle, it has evolved to something awesome.
In this post, I will use Percona for reasons I’d like to keep undisclosed. So let’s get started.
The easiest way to get up and running with Percona is to rely on the YUM repositories.
# yum install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm
This will install the Percona repository on your system so that you can then install the actual server and additional tools.
# yum install Percona-Server-server-57
This installs the server software, but doesn’t start the service. You need to manually start it for the first time.
# systemctl start mysql
After you get Percona MySQL running, you need to update your root password.
# cat /var/log/mysqld.log | grep generated 2018-03-24T15:54:37.006018Z 1 [Note] A temporary password is generated for root@localhost: Mr9nwsjduw=j
Use that password to login on your database and set your own:
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('Your#Pass');
You’re all set! Grab your SQL Database Client of choice and start managing your Percona server!