1,591 entries found:
) Next »
Recently, at a presentation I was giving on the newer features of MySQL 8.0, I noticed one person in the audience getting very upset. The more I talked about one feature, the more agitation I could see this one person getting. We're talking upset at a level where I was wondering if I was going to worry about my physical safety. The person in question finally snapped, "If I had known about that, it would have saved me four months of my life!"
In this guide, you will install a LEMP stack on a Fedora 31 based server. LEMP is an acronym for Linux, )Nginx server, MySQL (we will be using MariaDB), and PHP. We will also install PHPMyAdmin, Redis, and Opcache.
In this series, we’ll cover how to install Apache, generate a free Let’s Encrypt SSL certificate, install, and secure MySQL and install PHP 7.
In this tutorial, we will look at how you can create MySQL user accounts and grant privileges to allow them to access and manage the created databases.
Metabase is a free, opensource platform built to visualize the data with graphs and charts without writing a single line of SQL query or hiring a developer to analyze the data. In this guide you are going to install Metabase and use remote MySQL database server and also install Nginx and finally secure the installation with Let’s Encrypt SSL certificate for free.
The FAMP stack, which is akin to a LAMP stack on Linux, is a collection of open-source software that is typically installed together to enable a FreeBSD server to host dynamic websites and web applications. FAMP is an acronym that stands for FreeBSD (operating system), Apache (HTTP server), MySQL/MariaDB (database server), and PHP (programming language to process dynamic PHP content).
Managing database systems like MySQL, PostgreSQL, Oracle, and SQLite form the web-based UI is easier than using the command-line tool. Adminer is one of the best full-featured database management tool written in PHP.
Open source database vendor MariaDB updates its flagship platform with new features to enable the convergence of transactional and analytical databases
FEMP is an acronym that stands for FreeBSD (operating system), Nginx (HTTP server pronounced Engine-x), MySQL (database server), and PHP (programming language to process dynamic PHP content). In this tutorial, we'll set up components of a FEMP stack on a FreeBSD 12.1 server using pkg, the FreeBSD package manager.
phpMyAdmin is a free and open-source tool to manage MySQL and MariaDB servers over a web-based interface. In this tutorial, we will show you how to install and secure phpMyAdmin on CentOS 8 server.
MySQL is a popular Open Source Relational Database System aka RDBMS. MySQL uses a relational database & structured query language (SQL) to manage all the data. It’s used for developing all sorts of web-based applications. It’s one of the most widely used database servers in the world & also the main component of the LAMP stack. In this tutorial, we will learn how we can install MySQL on Ubuntu.
osTicket is an open-source ticketing system on the Linux platform written in PHP. In this tutorial, I will show you how to install osTicket on Ubuntu 18.04, using Nginx as a web server, MySQL/MariaDB as a database server and PHP.
Read how to automate tasks such as website and database backups using small bash scripts.
MariaDB is an open-source relational database management system, backward compatible, binary drop-in replacement of MySQL. It is developed by some of the original developers of MySQL and by many people in the community.
MariaDB is the latest open source and popular relational database management system, compatible and replacement of MySQL.
This post is about installation of MySQL using MariaDB on the major Linux distributions.
This post gets you started in Python Pandas. This article is a good primer for users who come from SQL background and want to leverage python Pandas for data analytics.
This post is about enabling MySQL auto suggest and autocomplete using a small utility called mycli. Once installed, it enables users auto complete previous used commands, also prompts and auto suggests users with built in MySQL commands, available databases, tables and fields depending the command typed. Please read the post to learn more about it.
MySQL is the most popular open-source relational database management system. The latest version of the MySQL database server, version 8.0, is available for installation from the default CentOS 8 repositories. In this tutorial, we will show you how to install and secure MySQL 8.0 on CentOS 8 systems.
This guide will walk you through the installation and configuration of NGINX to allow for the running of multiple physical servers, virtual machines or a combination of both behind a single public-facing IP Address.
This article shows how to list tables in a MySQL or MariaDB database via the command line.
MySQL replication is a process of copying data from one database server (master) to one or more servers (slaves). MySQL supports several replication topologies with Master/Slave topology being one of the most well-known topologies in which one database server acts as the master, while one or more servers act as slaves. By default, the replication is asynchronous where the master sends events that describe database modifications to its binary log and slaves request the events when they are ready.
In this guide, we will explain how to create an SSH tunnel and connect to the MySQL server from remote clients.
Bolt is a sophisticated, lightweight and simple CMS built with PHP. This tutorial shows the installation of Bolt CMS in FreeBSD 12 with Nginx web server, MySQL database server and Let's Encrypt SSL certificate.
This tutorial allows you to manage the MySQL / MariaDB server using the MySQLAdmin command.
By default, the MySQL server listens for connections only from localhost, which means it can be accessed only by applications running on the same host.
2DayGeek: This tutorial helps you to check queries running on the MySQL/MariaDB server.
MySQL workbench is a graphical application which let us manage data and perform administrative tasks on MySQL databases. In this tutorial we will see how to install the program on Ubuntu 18.04 (Bionic Beaver) and we will perform a brief tour of some of its most basic functionalities to make your Linux system administration job easier.
MySQL allows you to create multiple user accounts and grant appropriate privileges so that users can connect and manage databases. If the user account is no longer needed, it is a good idea to either remove the user privileges or to completely delete the user account. This tutorial explains how to delete MySQL/MariaDB user accounts.
OpenShift is a free and open-source Platform-as-a-Service developed by Red Hat. It is used to develop, host and scale applications in the cloud environment. OpenShift provides support for lots of languages like Java EE6, Ruby, PHP, Python, Perl, MongoDB, MySQL, and PostgreSQL.
MySQL, the most popular and reliable open-source relational database management system, is no longer available with CentOS’s repositories. In this article, we will learn how to install MySQL into CentOS 7 Operating System.
Matomo (formerly Piwik) is a free and open-source web analytics application developed by a team of international developers, that runs on a PHP/MySQL webserver. This tutorial will show you how to install Matomo on a FreeBSD 12.0 system using Nginx as the webserver and we will secure the website with a Let's Encrypt SSL certificate.
A database view is nothing but a virtual table, which does not contains data itself, but references data contained in other tables. Views are basically the result of stored queries which can vary on complexity and can be used, for example, to hide data from users, allowing access only on selected columns of a table, or simply to provide a different point of view on the existing data. In this tutorial we will see how to create, update, alter and drop a view on a MySQL, MariaDB database.
MySQL, the world’s most popular open source relational database management system is not available in the default Debian’s repositories. MariaDB is the default database system in Debian 10. This tutorial, explains how to install and secure MySQL on Debian 10 from the MySQL Apt Repository.
MySQL (and its drop-in replacement MariaDB) is the most popular open-source relational database management system. There are some important differences between MySQL versions, so knowing which version is running on your server might be important in some situations. For example, if you are installing an application that requires a specific MySQL version before starting with the installation you’ll need to find out the version of your MySQL server. In this article, we’ll show you how to check the version of the MySQL or MariaDB server that is installed on your system.
Visual Studio, ASP.NET Core and Linux: Some tension
Hands On Microsoft loves Linux – but coding and deploying an ASP.NET Core application for the open-source OS comes with a bit of friction compared to using Windows.…
MariaDB is an open source, multi-threaded relational database management system, backward compatible replacement for MySQL. MariaDB is the default implementation of MySQL in Debian.
This tutorial shows how to prepare a Debian 10 server (with Apache2, BIND, Dovecot) for the installation of ISPConfig 3.1. The web hosting control panel ISPConfig 3 allows you to configure the following services through a web browser: Apache web server, Postfix mail server, Dovecot IMAP/POP3 server, MySQL, BIND nameserver, PureFTPd, SpamAssassin, ClamAV, and many more.
This tutorial explains how to show all databases in a MySQL or MariaDB server through the command line.
Phorum is a PHP and MySQL based Open Source forum software. In this guide, we will guide you step-by-step through the Phorum installation process on the Fedora 30 operating system using Nginx as the web server, MariaDB as the database, and acme.sh and Let's Encrypt for HTTPS.
MySQL Workbench is a cross-platform graphical application for MySQL database administrators and architects. It includes tools for managing databases and users, creating and running SQL queries, configuring servers, taking backups, performing migrations and much more. In this tutorial, we will show you how to install and use MySQL Workbench on Ubuntu 18.04. The same instructions apply for Ubuntu 16.04 and any Ubuntu-based distribution, including Linux Mint, Kubuntu and Elementary OS.
Whether you are a system administrator or a database administrator, monitoring your MySQL server is an essential step towards diagnosing issues. You want real time monitoring on active connections, locks or queries that are running on your database. You also want to monitor active users, what they are running, as well as average query times. To monitor those metrics, we are going to build a complete MySQL dashboard using modern tools such as Grafana and Prometheus.
MySQL replication is a process that allows you to automatically copy data from one database server to one or more servers.
MySQL/MariaDB is an opensource database management software, which is very famous, user friendly and widely used for data storage. This will allow the user to create a database, database user, grant different permission based on their requirements and you can access it anywhere. If you have forgotten your MySQL user password, if you would like to change a password for a user, you can reset it by following the steps in this article.
Phorum is a PHP and MySQL based Open Source forum software. In this guide, we will guide you step-by-step through the Phorum installation process on the CentOS 7 operating system using Nginx as the web server, MariaDB as the database, and acme.sh and Let's Encrypt for HTTPS.
Bareos (Backup Archiving Recovery Open
Sourced) is a cross-network, open-source
backup solution that preserves, archives and recovers data from all major
operating systems. The Bareos project started 2010 as a Bacula fork and is now
being developed under the AGPLv3 license.
2DayGeek: Learn how to access remote MySQL/MariaDB databases right from Linux terminal.
Learn how to reset forgotten MySQL/MariaDB root user password on Linux.
In a previous article we talked about the various type of JOIN we can use in a MariaDB/MySQL database. This time, instead, we take a look at the UNION statement: how it works, how we can use it to combine the result of queries run on different tables, and what are its peculiarities.
In this article, we will show you how to install ISPConfig 3 on a CentOS 7 VPS, as well as go through the initial configuration.
ISPConfig is an open-source hosting control panel for Linux which has a user-friendly web interface – with it, users can manage their websites, email addresses, FTP accounts, DNS records, databases, and shell accounts.
How to Install ISPConfig 3 on a CentOS 7 VPS. The ISPConfig has four different levels of user access, which are as follows: Administrator, Reseller, Client, and Email-user. Each of these has varying levels of access to ISPConfig’s menus.
) Next »