Tag: mysql flush privileges command

mysql flush privileges command

Install Icinga 2 on Ubuntu 16.04

Icinga 2 is an open source network monitoring system which checks the availability of your network resources, notifies users of outages, and generates performance data for reporting. Icinga 2 is scalable and extensible and it can monitor large, complex environments across multiple locations. It supports Graphite …

Install Open Source Social Network on Ubuntu 16.04

In this tutorial, we are going to provide you with step by step instructions on how to install Open Source Social Network with Apache on an Ubuntu 16.04 VPS. Open Source Social Network (OSSN) is a social networking software written in PHP used by website developers …

Install Paperwork on Ubuntu

In this article, we will explain how to install Paperwork on an Ubuntu 16.04 VPS with MariaDB, PHP-FPM and Nginx. Paperwork is an open-source, self-hosted alternative to services like Evernote, Microsoft OneNote or Google Keep and it is built on top of Laravel 4.2. This guide …

How to install X2CRM on an Ubuntu 16.04 VPS

  Today we will show you how to install X2CRM on an Ubuntu 16.04 VPS using Apache web-server and MySQL database. X2CRM is an open source marketing, sales, and customer service CRM application powered by an easy to use workflow engine and process management framework. Manage …

Install Nextcloud on Ubuntu 16.04

In this article, we will show you how to install Nextcloud 9 on an Ubuntu 16.04 VPS with MariaDB, PHP-FPM 7.0 and Nginx. Nextcloud is open source self-hosted file sync and share application forked from ownCloud. This guide should work on other Linux VPS systems as …

How to setup MySQL replication on CentOS

In this tutorial we will show you how to setup basic MySQL replication on two CentOS 7 servers, but the same steps should work on all RPM based systems. We will use two test CentOS 7 virtual servers for this tutorial with the following IP addresses: …

Installing MySQL Server on CentOS

MySQL is an open-source relational database. For those unfamiliar with these terms, a database is where an application keeps its data, and relational refers to how the data is organized and accessed within the database. SQL refers to the language used by application queries to retrieve …

Reset MySQL root password

Below are commands: service mysql stop mysqld_safe --skip-grant-tables > /dev/null 2>&1 & mysql -u root -e "use mysql; update user set password=PASSWORD('NEW-PASSWORD') where User='root'; flush privileges;" service mysql restart Note: You may need to wait after mysqld_safe command, before you can run subsequent mysql command. Test: mysql -u root -pNEW-PASSWORD

How to configure a remote MySQL connection

On low traffic websites rare times you will need to run you own MySQL dedicated vps or server, however on high traffic websites it’s a very common practice to split the database queries to a dedicated server or VPS that will run only MySQL server. This …

Mysqladmin Command For Administering MySQL Server

In all the 15 mysqladmin command-line examples below, tmppassword is used as the MySQL root user password. Please change this to your MySQL root password. 1. How to change the MySQL root user password? # mysqladmin -u root -ptmppassword password 'newpassword' # mysql -u root -pnewpassword …

Forgot MySQL Root Password – How To Reset It

Forgot your MySQL root user password? Don’t worry. We are here for rescue. When you tried to login to root without entering a password, you may get ‘Access Denied’ message, as MySQL is expecting a password. This article explains how to recover mysql root password by …