e Learning

Mysql Server

phpMyAdmin: the configuration file now needs a secret passphrase blowfish_secret

Learn How to Solve "The configuration file now needs a secret passphrase (blowfish_secret)" error in phpMyAdmin.

You could get the following error message in phpMyAdmin page, if you manually download and installed phpMyAdmin.

Troubleshoot: mysqladmin connect to server at localhost failed

The most obvious reason for the "mysqladmin: connect to server at 'localhost' failed" message is that MySQL Server is not running. If you are trying to run the mysqladmin command on a docker container..

mysqldump --add-drop-table option explained

Before we talk about mysqldump --add-drop-table option, we need to understand what happens when you dump a MySQL Database. When we backup MySQL database using mysqldump command, it actually creating a script file containing multiple SQL Statements. These statements include MySQL queries which will use to restore the database and tables.

How to Install MySQL Server on Ubuntu Linux

MySQL is a Free open source database management system popular among Webmasters because of the its stability and rich features. And not to mention MySQL Database works extremely well with PHP Programming Language which make it an important part of the LAMP Stack. The Purpose of this tutorial is to Learn How to Install and Configure MySQL Server on Ubuntu Linux. In Addition to the Installation we will also look at some useful mysql commands that will be helpful for the system administrators. For this demonstration we will be using Ubuntu Server 14.04.

start: Unknown job: mysql Ubuntu Server

I am trying to restart the MySQL server on Ubuntu using service mysql restart command. But I only get Following Error. stop: Unknown job: mysql start: Unknown job: mysql