MySQL je jedním z populárních systémů pro správu databází. V současné době již MySQL není v úložišti Centos a MariaDB je nyní výchozí databází, kterou nabízejí repozitáře Centos.
Domníváme se, že jste k provedení těchto kroků přihlášeni jako uživatel root. Chcete-li nainstalovat MySQL 5.7 na Centos 7.1
, postupujte podle následujících kroků- Nejprve aktualizujeme centos pomocí příkazu yum update.
Yum update
- Nainstalujte wget a stáhněte si soubory z internetu.
yum install wget
- Pokračujeme v instalaci MySQL . Nejprve si stáhněte a přidejte úložiště.
wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
rpm -ivh mysql80-community-release-el7-3.noarch.rpm - Spuštěním níže uvedeného příkazu nainstalujte MySQL 5.7 na váš VPS.
yum -y install mysql-community-server --disablerepo=mysql80-community --enablerepo=mysql57-community
- Spusťte a zkontrolujte stav služby MySQL.
systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld - Získejte dočasné heslo pro uživatele root:
less /var/log/mysqld.log | grep pass
A temporary password is generated for [email protected]: o!5y,JGALQa - Spusťte nástroj pro zabezpečenou instalaci a resetujte heslo.
$ sudo mysql_secure_installation
Securing the MySQL server deployment.
Enter password for user root: The 'validate_password' plugin is installed on the server. The subsequent steps will run with the existing configuration of the plugin. Using existing password for root. Estimated strength of the password: 100 Change the password for root ? ((Press y|Y for Yes, any other key for No) : y New password: Re-enter new password: Estimated strength of the password: 100 Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y By default, a MySQL installation has an anonymous user, allowing anyone to log into MySQL without having to have a user account created for them. This is intended only for testing, and to make the installation go a bit smoother. You should remove them before moving into a production environment. Remove anonymous users? (Press y|Y for Yes, any other key for No) : y Success. Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the network. Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y Success. By default, MySQL comes with a database named 'test' that anyone can access. This is also intended only for testing, and should be removed before moving into a production environment. Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y - Dropping test database... Success. - Removing privileges on test database... Success. Reloading the privilege tables will ensure that all changes made so far will take effect immediately. Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y Success. All done!
- Připojte server mysql :
mysql -u root -p