Tag : MySQL

Blog

Error: Login without a password is forbidden by configuration (see AllowNoPassword) [SOLVED]

Viking Coin
This error relates to logging into phpMyAdmin, an open source tool used for the administration of MySQL. Once in awhile, perhaps on a Development server, MySQL won’t be setup with a root password. The aforementioned configuration is generally thought of as against best practices however, if it is what you’re......
Blog

How to Install and Configure phpMyAdmin on Ubuntu 15.04

Viking Coin
phpMyAdmin is an open source tool used for the administration of MySQL. In addition to offering the capability to perform administration tasks such as creating, editing, or deleting databases, and managing users and permissions, phpMyAdmin provides a graphical user interface to do all of these tasks and more. Pre-Flight Check......
Blog

Renaming Database Tables with phpMyAdmin

Viking Coin
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......
Blog

How to Install MySQL on Windows

Viking Coin
If you’re using a Windows-based server to host your content, you may using Microsoft’s database server product, MSSQL. However, licensing restrictions can make using MSSQL difficult, especially for small businesses. Microsoft offers a free version of MSSQL called MSSQL Express that will be suitable for many users, but this version......
Blog

How To Install MySQL / MariaDB on CentOS 7

Viking Coin
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,......
Blog

Exporting Databases and Tables with phpMyAdmin

Viking Coin
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......
Blog

MySQL Performance: Converting MySQL to MariaDB

Viking Coin
MySQL Performance MySQL Performance: Identifying Long Queries MySQL Performance: MyISAM vs InnoDB MySQL Performance: How To Leverage MySQL Database Indexing MySQL Performance: MySQL vs. MariaDB MySQL Performance: Converting MySQL to MariaDB MySQL Performance: System Configuration File & Routine Maintenance MySQL Performance: InnoDB Buffers & Directives MySQL Performance: MyISAM As we......
Blog

How to Check the MySQL Version

Viking Coin
In this quick tutorial, we’ll learn how to check the MySQL version of a server. Without a doubt, MySQL is one of the most popular RDBMS (Relational database management system)  options available, so you’ll find it pretty much everywhere. There can be some pretty staggering differences between MySQL versions, so......
Blog

View the Selected MySQL Database on Linux via Command Line

Viking Coin
Pre-Flight Check These instructions are intended for viewing the selected MySQL database via the command line. I’ll be working from a sxi.io Web Core Managed CentOS 7 server, and I’ll be logged in as root. Login to MySQL First we’ll login to the MySQL server from the command line with......
Blog

How To Install MySQL / MariaDB on Fedora 20

Viking Coin
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),......
Blog

How To Install MySQL/MariaDB on Fedora 23

Viking Coin
MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easily integrated into most MySQL deployments. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), and OQGRAPH. Pre-Flight Check These instructions are intended for......
Blog

MySQL Performance: System Configuration File & Routine Maintenance

Viking Coin
MySQL Performance MySQL Performance: Identifying Long Queries MySQL Performance: MyISAM vs InnoDB MySQL Performance: How To Leverage MySQL Database Indexing MySQL Performance: MySQL vs. MariaDB MySQL Performance: Converting MySQL to MariaDB MySQL Performance: System Configuration File & Routine Maintenance MySQL Performance: InnoDB Buffers & Directives MySQL Performance: MyISAM The majority......
Blog

Creating Tables in a Database with phpMyAdmin

Viking Coin
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......