Установка MySQL сервер на CentOS 7. Установка mysql на centos 7
Установка MySQL сервер на CentOS 7
Linux Материал просмотрен 141 раз(а)
Содержание1 Выпуск сертификата2 Передача файлов3 Создание бота Предыдущая статья обязательна к прочтению. Итак, на
Linux Материал просмотрен 266 раз(а)
Содержание1 Задача2 Размышления3 Решение проблемы3.1 Зеркалирование трафика3.2 Сервер виртуализации3.3 Обзорчик NtopNG3.4 Забыл пароль админки
Работа с сетью Материал просмотрен 487 раз(а)
В настоящее время большое распространение получили беспроводные технологии доступа к сети, в частности к
Работа с сетью Материал просмотрен 1,043 раз(а)
Содержание1 Проблемы Интернет-соединения1.1 Низкая скорость скачивания файлов1.2 Потери пакетов1.3 Увеличенное время отклика1.4 Невозможность получения
Работа с сетью Материал просмотрен 5,749 раз(а)
Содержание1 Адресация2 Создаём структуру защищённой сети3 Работа с УКЦ3.1 КЛИКАБЕЛЬНО4 Установка софта ViPNet Итак,
Windows Материал просмотрен 665 раз(а)
Содержание1 Состав ViPNet Administrator2 Установка рабочего места администратора3 Установка ViPNet Client ViPNet Administrator, пожалуй,
litl-admin.ru
Установка MySQL-сервера (MariaDB) на Centos 7
Обновляем операционную систему
[root@localhost]# yum updateСтавим MariaDB
[root@localhost]# yum install mariadb-server mariadbДобавляем сервер в автозагрузку и запускаем его
[root@localhost]# systemctl enable mariadb.service [root@localhost]# systemctl start mariadb.serviceВначале будет запрошен root-пароль, но т.к. в новой установке его нет, просто жмем EnterПосле этого сценарий предложит создать root-пароль и задаст ряд вопросов.
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MariaDB to secure it, we'll need the current password for the root user. If you've just installed MariaDB, and you haven't set the root password yet, the password will be blank, so you should just press enter here. Enter current password for root (enter for none): OK, successfully used password, moving on... Setting the root password ensures that nobody can log into the MariaDB root user without the proper authorisation. You already have a root password set, so you can safely answer 'n'. Change the root password? [Y/n] n ... skipping. By default, a MariaDB installation has an anonymous user, allowing anyone to log into MariaDB 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? [Y/n] 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? [Y/n] y ... Success! By default, MariaDB 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? [Y/n] 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? [Y/n] y ... Success! Cleaning up... All done! If you've completed all of the above steps, your MariaDB installation should now be secure. Thanks for using MariaDB!Установка MySQL-сервера (MariaDB) на Centos 7, последнее изменение: Сентябрь 19, 2018, автор: Максим Макаров
Установка MySQL-сервера (MariaDB) на Centos 7
5/5
1
itdraft.ru
linux - Установка MySQL 5.6 на CentOS7
Я пытаюсь установить MySQL 5.6 на CentOS7. Я удалил mariadb-libs (так как мне нужно использовать только MySQL), поскольку они конфликтуют с некоторыми библиотеками MySQL. Я установил отсутствующий модуль perl с помощью yum install 'perl (Data :: Dumper)'. Установка по-прежнему не работает. Что мне не хватает? Я получаю следующую ошибку:
rpm -Uhvvv MySQL-server-5.6.17-1.linux_glibc2.5.x86_64.rpm | more D: ============== MySQL-server-5.6.17-1.linux_glibc2.5.x86_64.rpm D: loading keyring from pubkeys in /var/lib/rpm/pubkeys/*.key D: couldn't find any keys in /var/lib/rpm/pubkeys/*.key D: loading keyring from rpmdb D: opening db environment /var/lib/rpm cdb:0x401 D: opening db index /var/lib/rpm/Packages 0x400 mode=0x0 D: locked db index /var/lib/rpm/Packages D: opening db index /var/lib/rpm/Name 0x400 mode=0x0 D: read h# 1272 Header SHA1 digest: OK (e6870d8b02e1f67dee30779203c6104284ea269a) D: added key gpg-pubkey-f4a80eb5-53a7ff4b to keyring D: Using legacy gpg-pubkey(s) from rpmdb D: Expected size: 86961692 = lead(96)+sigs(264)+pad(0)+data(86961332) D: Actual size: 5307336 D: MySQL-server-5.6.17-1.linux_glibc2.5.x86_64.rpm: Header SHA1 digest: OK (8a971c3546cc413fe949982ab3237a01f64ec0f3) D: added binary package [0] D: found 0 source and 1 binary packages D: opening db index /var/lib/rpm/Conflictname 0x400 mode=0x0 D: ========== +++ MySQL-server-5.6.17-1.linux_glibc2.5 x86_64/linux 0x2 D: opening db index /var/lib/rpm/Basenames 0x400 mode=0x0 D: read h# 54 Header V3 RSA/SHA256 Signature, key ID f4a80eb5: OK D: Requires: /bin/sh YES (db files) D: Requires: /bin/sh YES (cached) D: Requires: /bin/sh YES (cached) D: Requires: /bin/sh YES (cached) D: Requires: /bin/sh YES (cached) D: read h# 72 Header V3 RSA/SHA256 Signature, key ID f4a80eb5: OK D: Requires: /sbin/chkconfig YES (db files) D: read h# 313 Header V3 RSA/SHA256 Signature, key ID f4a80eb5: OK D: Requires: /usr/bin/perl YES (db files) D: read h# 427 Header V3 RSA/SHA256 Signature, key ID f4a80eb5: OK D: Requires: /usr/sbin/groupadd YES (db files) D: Requires: /usr/sbin/useradd YES (db files) D: Requires: config(MySQL-server) = 5.6.17-1.linux_glibc2.5 YES (added provide) D: opening db index /var/lib/rpm/Providename 0x400 mode=0x0 D: read h# 426 Header V3 RSA/SHA256 Signature, key ID f4a80eb5: OK D: Requires: coreutils YES (db provides) D: read h# 77 Header V3 RSA/SHA256 Signature, key ID f4a80eb5: OK D: Requires: grep YES (db provides) D: read h# 139 Header V3 RSA/SHA256 Signature, key ID f4a80eb5: OK D: Requires: libaio.so.1()(64bit) YES (db provides) D: Requires: libaio.so.1(LIBAIO_0.1)(64bit) YES (db provides) D: Requires: libaio.so.1(LIBAIO_0.4)(64bit) YES (db provides) D: read h# 51 Header V3 RSA/SHA256 Signature, key ID f4a80eb5: OK D: Requires: libc.so.6()(64bit) YES (db provides) D: Requires: libc.so.6(GLIBC_2.2.5)(64bit) YES (db provides) D: Requires: libc.so.6(GLIBC_2.3)(64bit) YES (db provides) D: Requires: libc.so.6(GLIBC_2.3.4)(64bit) YES (db provides) D: Requires: libc.so.6(GLIBC_2.4)(64bit) YES (db provides) D: Requires: libcrypt.so.1()(64bit) YES (db provides) D: Requires: libcrypt.so.1(GLIBC_2.2.5)(64bit) YES (db provides) D: Requires: libdl.so.2()(64bit) YES (db provides) D: Requires: libdl.so.2(GLIBC_2.2.5)(64bit) YES (db provides) D: read h# 1 Header V3 RSA/SHA256 Signature, key ID f4a80eb5: OK D: Requires: libgcc_s.so.1()(64bit) YES (db provides) D: Requires: libgcc_s.so.1(GCC_3.0)(64bit) YES (db provides) D: Requires: libm.so.6()(64bit) YES (db provides) D: Requires: libm.so.6(GLIBC_2.2.5)(64bit) YES (db provides) D: Requires: libpthread.so.0()(64bit) YES (db provides) D: Requires: libpthread.so.0(GLIBC_2.2.5)(64bit) YES (db provides) D: Requires: libpthread.so.0(GLIBC_2.3.2)(64bit) YES (db provides) D: Requires: librt.so.1()(64bit) YES (db provides) D: Requires: librt.so.1(GLIBC_2.2.5)(64bit) YES (db provides) D: read h# 52 Header V3 RSA/SHA256 Signature, key ID f4a80eb5: OK D: Requires: libstdc++.so.6()(64bit) YES (db provides) D: Requires: libstdc++.so.6(CXXABI_1.3)(64bit) YES (db provides) D: Requires: libstdc++.so.6(GLIBCXX_3.4)(64bit) YES (db provides) D: read h# 446 Header V3 RSA/SHA256 Signature, key ID f4a80eb5: OK D: Requires: procps YES (db provides) D: Requires: rpmlib(CompressedFileNames) <= 3.0.4-1 YES (rpmlib provides) D: Requires: rpmlib(PayloadFilesHavePrefix) <= 4.0-1 YES (rpmlib provides) D: Requires: rpmlib(VersionedDependencies) <= 3.0.3-1 YES (rpmlib provides) D: Requires: rtld(GNU_HASH) YES (db provides) D: Obsoletes: MySQL-server-advanced NO D: Obsoletes: mysql-server < 5.6.17-1.linux_glibc2.5 NO D: Obsoletes: mysql-server-advanced NO D: Obsoletes: MySQL-server-classic NO D: Obsoletes: MySQL-server-community NO D: Obsoletes: MySQL-server-enterprise NO D: Obsoletes: MySQL-server-advanced-gpl NO D: Obsoletes: MySQL-server-enterprise-gpl NO D: opening db index /var/lib/rpm/Obsoletename 0x400 mode=0x0 D: ========== recording tsort relations D: ========== tsorting packages (order, #predecessors, #succesors, depth) D: 0 0 0 1 +MySQL-server-5.6.17-1.linux_glibc2.5.x86_64 D: installing binary packages D: closed db index /var/lib/rpm/Obsoletename D: closed db index /var/lib/rpm/Conflictname D: closed db index /var/lib/rpm/Providename D: closed db index /var/lib/rpm/Basenames D: closed db index /var/lib/rpm/Name D: closed db index /var/lib/rpm/Packages D: closed db environment /var/lib/rpm D: opening db environment /var/lib/rpm cdb:0x401 D: opening db index /var/lib/rpm/Packages (none) mode=0x42 D: sanity checking 1 elements D: opening db index /var/lib/rpm/Name (none) mode=0x42 D: running pre-transaction scripts D: computing 192 file fingerprints D: opening db index /var/lib/rpm/Basenames (none) mode=0x42 D: opening db index /var/lib/rpm/Group (none) mode=0x42 D: opening db index /var/lib/rpm/Requirename (none) mode=0x42 D: opening db index /var/lib/rpm/Providename (none) mode=0x42 D: opening db index /var/lib/rpm/Conflictname (none) mode=0x42 D: opening db index /var/lib/rpm/Obsoletename (none) mode=0x42 D: opening db index /var/lib/rpm/Triggername (none) mode=0x42 D: opening db index /var/lib/rpm/Dirnames (none) mode=0x42 D: opening db index /var/lib/rpm/Installtid (none) mode=0x42 D: opening db index /var/lib/rpm/Sigmd5 (none) mode=0x42 D: opening db index /var/lib/rpm/Sha1header (none) mode=0x42 D: computing file dispositions D: 0x0000fd01 4096 3494614 18243875 / D: ========== +++ MySQL-server-5.6.17-1.linux_glibc2.5 x86_64-linux 0x2 D: Expected size: 86961692 = lead(96)+sigs(264)+pad(0)+data(86961332) D: Actual size: 5307336 D: MySQL-server-5.6.17-1.linux_glibc2.5.x86_64: Header SHA1 digest: OK (8a971c3546cc413fe949982ab3237a01f64ec0f3) D: install: MySQL-server-5.6.17-1.linux_glibc2.5 has 192 files D: %pre(MySQL-server-5.6.17-1.linux_glibc2.5.x86_64): scriptlet start D: %pre(MySQL-server-5.6.17-1.linux_glibc2.5.x86_64): execv(/bin/sh) pid 14403 Preparing... ######################################## + '[' -x /usr/bin/my_print_defaults ']' ++ /usr/bin/my_print_defaults server mysqld ++ grep '^--datadir=' ++ sed -n s/--datadir=//p + mysql_datadir= ++ /usr/bin/my_print_defaults server mysqld ++ grep '^--pid-file=' ++ sed -n s/--pid-file=//p + PID_FILE_PATT= + '[' -z '' ']' + mysql_datadir=/var/lib/mysql + '[' -z '' ']' + PID_FILE_PATT='/var/lib/mysql/*.pid' ++ rpm -q --whatprovides mysql-server + installed='no package provides mysql-server' + '[' 1 -ne 0 -o -z 'no package provides mysql-server' ']' ++ rpm -q --whatprovides MySQL-server + installed='no package provides MySQL-server' + '[' 1 -eq 0 -a -n 'no package provides MySQL-server' ']' ++ ls -1 '/var/lib/mysql/*.pid' ++ wc -l + NR_PID_FILES=0 + case $NR_PID_FILES in + SERVER_TO_START= + STATUS_FILE=/var/lib/mysql/RPM_UPGRADE_MARKER + '[' -f /var/lib/mysql/RPM_UPGRADE_MARKER ']' + '[' -n '' ']' + NEW_VERSION=5.6.17-1.linux_glibc2.5 + '[' -d /var/lib/mysql/mysql ']' + '[' -x /etc/init.d/mysql ']' + /etc/init.d/mysql stop + echo 'Giving mysqld 5 seconds to exit nicely' + sleep 5 Giving mysqld 5 seconds to exit nicely D: %pre(MySQL-server-5.6.17-1.linux_glibc2.5.x86_64): waitpid(14403) rc 14403 status 0 D: ========== Directories not explicitly included in package: D: 0 /etc/init.d/ D: 1 /etc/logrotate.d/ D: 2 /etc/ D: 3 /usr/bin/ D: 4 /usr/lib64/mysql/ D: 5 /usr/lib64/mysql/plugin/ D: 6 /usr/lib64/mysql/plugin/debug/ D: 7 /usr/sbin/ D: 8 /usr/share/doc/ D: 10 /usr/share/man/man1/ D: 11 /usr/share/man/man8/ D: 12 /usr/share/ D: ========== D: create 100755 1 ( 0, 0) 10815 /etc/init.d/mysql;53e50cd1 Updating / installing... D: create 100644 1 ( 0, 0) 844 /etc/logrotate.d/mysql;53e50cd1 D: create 100755 1 ( 0, 0)4726596 /usr/bin/innochecksum;53e50cd1 D: create 100755 1 ( 0, 0)4666133 /usr/bin/my_print_defaults;53e50cd1 D: create 100755 1 ( 0, 0)6778320 /usr/bin/myisam_ftdump;53e50cd1 D: create 100755 1 ( 0, 0)7194676 /usr/bin/myisamchk;53e50cd1 GZDIO: 304 reads, 18291337 total bytes in 0.110334 secs error: unpacking of archive failed on file /usr/bin/myisamchk;53e50cd1: cpio: read failed - Inappropriate ioctl for device error: MySQL-server-5.6.17-1.linux_glibc2.5.x86_64: install failed D: running post-transaction scripts D: closed db index /var/lib/rpm/Sha1header D: closed db index /var/lib/rpm/Sigmd5 D: closed db index /var/lib/rpm/Installtid D: closed db index /var/lib/rpm/Dirnames D: closed db index /var/lib/rpm/Triggername D: closed db index /var/lib/rpm/Obsoletename D: closed db index /var/lib/rpm/Conflictname D: closed db index /var/lib/rpm/Providename D: closed db index /var/lib/rpm/Requirename D: closed db index /var/lib/rpm/Group D: closed db index /var/lib/rpm/Basenames D: closed db index /var/lib/rpm/Name D: closed db index /var/lib/rpm/Packages D: closed db environment /var/lib/rpm MySQL-server-5.6.17-1.linux_glibc2.5 ######################################## источник поделитьсяmysql - Не удалось установить MySql на CentOS 7
Почему это имеет какое-то отношение к mariadb? У меня была новая установка CentOS 7 и вы захотели установить версию сообщества MySql. Кажется, я должен сначала установить сервер Mariadb?
# yum install mysql-community-server Loaded plugins: fastestmirror, langpacks Loading mirror speeds from cached hostfile * base: linux.mirrors.es.net * extras: linux.mirrors.es.net * updates: linux.mirrors.es.net Resolving Dependencies --> Running transaction check ---> Package mariadb-server.x86_64 1:5.5.35-3.el7 will be obsoleted --> Processing Dependency: mariadb-server for package: akonadi-mysql-1.9.2-4.el7.x86_64 ---> Package mysql-community-server.x86_64 0:5.6.25-2.el7 will be obsoleting --> Processing Dependency: mysql-community-common(x86-64) = 5.6.25-2.el7 for package: mysql-community-server-5.6.25-2.el7.x86_64 --> Processing Dependency: mysql-community-client(x86-64) = 5.6.25-2.el7 for package: mysql-community-server-5.6.25-2.el7.x86_64 --> Running transaction check ---> Package mariadb.x86_64 1:5.5.35-3.el7 will be obsoleted ---> Package mariadb-server.x86_64 1:5.5.35-3.el7 will be updated ---> Package mariadb-server.x86_64 1:5.5.41-2.el7_0 will be an update --> Processing Dependency: mariadb-libs(x86-64) = 1:5.5.41-2.el7_0 for package: 1:mariadb-server-5.5.41-2.el7_0.x86_64 --> Processing Dependency: mariadb(x86-64) = 1:5.5.41-2.el7_0 for package: 1:mariadb-server-5.5.41-2.el7_0.x86_64 ---> Package mysql-community-client.x86_64 0:5.6.25-2.el7 will be obsoleting ---> Package mysql-community-common.x86_64 0:5.6.25-2.el7 will be installed --> Running transaction check ---> Package mariadb.x86_64 1:5.5.35-3.el7 will be updated ---> Package mariadb.x86_64 1:5.5.41-2.el7_0 will be an update ---> Package mariadb-libs.x86_64 1:5.5.35-3.el7 will be obsoleted ---> Package mariadb-libs.x86_64 1:5.5.35-3.el7 will be updated ---> Package mariadb-libs.x86_64 1:5.5.41-2.el7_0 will be an update ---> Package mysql-community-libs.x86_64 0:5.6.25-2.el7 will be obsoleting Removing mariadb-server.x86_64 1:5.5.41-2.el7_0 - u due to obsoletes from mysql-community-server.x86_64 0:5.6.25-2.el7 - u Removing mariadb.x86_64 1:5.5.41-2.el7_0 - u due to obsoletes from mysql-community-client.x86_64 0:5.6.25-2.el7 - u Removing mariadb-libs.x86_64 1:5.5.41-2.el7_0 - u due to obsoletes from mysql-community-libs.x86_64 0:5.6.25-2.el7 - u --> Restarting Dependency Resolution with new changes. --> Running transaction check ---> Package mariadb.x86_64 1:5.5.41-2.el7_0 will be an update ---> Package mariadb-libs.x86_64 1:5.5.41-2.el7_0 will be an update ---> Package mariadb-server.x86_64 1:5.5.41-2.el7_0 will be an update --> Processing Dependency: mariadb-server for package: akonadi-mysql-1.9.2-4.el7.x86_64 --> Finished Dependency Resolution Error: Package: akonadi-mysql-1.9.2-4.el7.x86_64 (@anaconda) Requires: mariadb-server Removing: 1:mariadb-server-5.5.35-3.el7.x86_64 (@anaconda) mariadb-server = 1:5.5.35-3.el7 Obsoleted By: mysql-community-server-5.6.25-2.el7.x86_64 (mysql56-community) Not found Updated By: 1:mariadb-server-5.5.41-2.el7_0.x86_64 (base) mariadb-server = 1:5.5.41-2.el7_0 источник поделитьсяqaru.site
