Tag: database
Install and Configure DBeaver on Ubuntu 18.04 / Ubuntu 16.04 / Debian 9
(: June 25, 2019) In this blog post, I’ll discuss how to install DBeaver Database Tool on Ubuntu 18.04 / Ubuntu 16.04 / Debian 9. DBeaver CE is a free and open source multi-platform database management tool/SQL client designed for Developers, SQL programmers, Analysts, and Database administrators. DBeaver supports any database which has JDBC driver – MySQL/MariaDB,…
Change a Password for MySQL on Linux via Command Line
MySQL via Command Line 101: Basic Database Interaction Change a Password for MySQL on Linux via Command Line Create a MySQL Database on Linux via Command Line Select a MySQL Database on Linux via Command Line 3 Tips For Working With a MySQL Database! How to Back Up MySQL Databases From The Command Line Next…
How To Install MySQL / MariaDB on Fedora 22
MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at: MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB),…
Fixing WordPress Errors
Let’s face it. At some point, while running your WordPress site, you will run into issues and errors and may ultimately have to ask yourself… How Do I Fix My WordPress Site? A backup & restore may not resolve your issue, and a plugin may not display itself as the source of your problem, at…
Searching Through a Database with phpMyAdmin
Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin…
Create a MySQL User on Linux via Command Line
MySQL via Command Line 102: Basic User Interaction Create a MySQL User on Linux via Command Line Grant Permissions to a MySQL User on Linux via Command Line Remove Permissions for a MySQL User on Linux via Command Line Remove a MySQL User on Linux via Command Line Previous Series: MySQL via Command Line 101:…
How to Install the Open Query Graph engine (OQGRAPH) for MariaDB 10.0 on CentOS 6
MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB),…
How To Change a MySQL Database User’s Password in cPanel
cPanel Tutorial: MySQL I. How To Set up a Database using the MySQL Database Wizard in cPanel II. How To Create a MySQL Database in cPanel III. How To Delete a MySQL Database in cPanel IV. How To Create a MySQL Database User in cPanel V. How To Assign a User to a MySQL Database…
How to Install Nextcloud 15 on Ubuntu 18.04
Similar to Dropbox and Google Drive, Nextcloud is self-hosting software that allows you to share files, contacts, and calendars. But, unlike Dropbox and Google Drive, your files will be private and stored on your server instead of a third party server. Nextcloud is HIPAA and GDPR compliant, so your files will be encrypted along with…
Installing SQL Express
MSSQL Express 2017 on a Dedicated Server Microsoft SQL Server is a powerful database that is commonly used with ASP.NET and other website programming languages. However, licensing for MSSQL can be expensive and is sometimes prohibitive for smaller businesses and applications. Fortunately, Microsoft provides a free version of MSSQL server called MSSQL Express. Installing MSSQL…