Instalando Apache, MariaDB e PHP com HTTPS no Arch Linux
No presente artigo iremos aprender a instalar os serviços Apache com SSL, MariaDB e PHP no Arch Linux.
[ Hits: 23.280 ]
Por: Rodrigo Leutz em 16/07/2018 | Blog: https://uware.com.br
:: There are 2 providers available for mysql: :: Repository extra 1) mariadb :: Repository community 2) percona-server Enter a number (default=1): << [ Enter ] resolving dependencies... looking for conflicting packages... Packages (4) jemalloc-1:5.1.0-1 libmariadbclient-10.1.34-1 mariadb-clients-10.1.34-1 mariadb-10.1.34-1 Total Download Size: 32.49 MiB Total Installed Size: 229.92 MiB :: Proceed with installation? [Y/n] << [ Y ]2. Agora vamos inicializar a base de dados do MariaDB, necessário antes de iniciar o serviço:
● mariadb.service - MariaDB 10.1.34 database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Active: active (running) since Fri 2018-07-06 12:02:33 -03; 5s ago Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Process: 6750 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited> Process: 6669 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/ga> Process: 6668 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited,> Main PID: 6722 (mysqld) Status: "Taking your SQL requests now..." Tasks: 27 (limit: 4915) Memory: 63.2M CGroup: /system.slice/mariadb.service └─6722 /usr/bin/mysqld Jul 06 12:02:33 arch mysqld[6722]: 2018-07-06 12:02:33 140084921851840 [Note] InnoDB: Highest supported> Jul 06 12:02:33 arch mysqld[6722]: 2018-07-06 12:02:33 140084921851840 [Note] InnoDB: 128 rollback segm> Jul 06 12:02:33 arch mysqld[6722]: 2018-07-06 12:02:33 140084921851840 [Note] InnoDB: Waiting for purge> Jul 06 12:02:33 arch mysqld[6722]: 2018-07-06 12:02:33 140084921851840 [Note] InnoDB: Percona XtraDB (> Jul 06 12:02:33 arch mysqld[6722]: 2018-07-06 12:02:33 140084921851840 [Note] Plugin 'FEEDBACK' is disa> Jul 06 12:02:33 arch mysqld[6722]: 2018-07-06 12:02:33 140084282128128 [Note] InnoDB: Dumping buffer po> Jul 06 12:02:33 arch mysqld[6722]: 2018-07-06 12:02:33 140084921851840 [Note] Server socket created on > Jul 06 12:02:33 arch mysqld[6722]: 2018-07-06 12:02:33 140084921851840 [Note] /usr/bin/mysqld: ready fo> Jul 06 12:02:33 arch mysqld[6722]: Version: '10.1.34-MariaDB' socket: '/run/mysqld/mysqld.sock' port:> Jul 06 12:02:33 arch systemd[1]: Started MariaDB 10.1.34 database server.4. Colocando password para o 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): << [ Enter ] OK, successfully used password, moving on... Setting the root password ensures that nobody can log into the MariaDB root user without the proper authorisation. Set root password? [Y/n] [ Enter ] New password: [ Entre com o password ] Re-enter new password: [ Digite novamente o password ] Password updated successfully! Reloading privilege tables.. ... Success! 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] [ Enter ] ... 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] [ Enter ] ... 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] [ Enter ] - 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] [ Enter ] ... 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!MariaDB está instalada e pronta para o uso!
Implementando segurança no SSH
Sudoers 1.8.12 - Parte II - Manual
Instalando o Nagios via APT ou YUM
Iptraf Sniffer - noções básicas
Melhorando o tempo de boot do Fedora e outras distribuições
Como instalar as extensões Dash To Dock e Hide Top Bar no Gnome 45/46
E a guerra contra bots continua
Tradução do artigo do filósofo Gottfried Wilhelm Leibniz sobre o sistema binário
Conheça o firewall OpenGFW, uma implementação do (Great Firewall of China).
Instalando o FreeOffice no LMDE 6
Anki: Remover Tags de Estilo HTML de Todas as Cartas
Colocando uma opção de redimensionamento de imagem no menu de contexto do KDE
[Shell Script] Script para desinstalar pacotes desnecessários no OpenSuse
[Shell Script] Script para criar certificados de forma automatizada no OpenVpn
[Shell Script] Conversor de vídeo com opção de legenda
[C/C++] BRT - Bulk Renaming Tool
[Shell Script] Criação de Usuarios , Grupo e instalação do servidor de arquivos samba