How to Change Definer in MySQL Views

In this article, as shown in the title of the article which is how to change definer inMySQL views, this article is written to show how to change definer in MySQL views. At first, definer of a file is actually specified in the MySQL Database dump file  where it can actually be changed.  It is quite simple to change it if the prerequisite on accessing MySQL Database Server can be fulfilled.

The prerequisite can be specified as follows :

Continue reading “How to Change Definer in MySQL Views”

Ubuntu Linux Error Message : dpkg: error processing package mysql-server-5.7 (–configure)

This error specified in the title of this article popped out in the middle of the execution of apt command. It is an error which has been bothering for quite sometime. It is because the upgrade process of MySQL Database Server in the Ubuntu Linux Operating System, every operation involving apt tool for package management system include installing, updating and removing packages will generate an error message specified in the title of the article at the end. So, below are steps taken which is basically trial and error in sequential order to be able to completely remove the nuisance of error message generated in the title of this article as follows :

dpkg: error processing package mysql-server-5.7 (--configure)

Below are several of those steps taken :

1. Using dpkg –configure -a.

The first step taken is using ‘dpkg –configure -a’ which is executed since mysql-server-5.7 is considered installed but it hasn’t been configured yet. Below is the output of the command generated :

Continue reading “Ubuntu Linux Error Message : dpkg: error processing package mysql-server-5.7 (–configure)”

MySQL Error Message : ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./db’, errno: 39)

This is an article written to describe on how to solve the error generated in MySQL Database Server. The error itself is an error specifically triggered upon dropping a database which in this context is executed through a command typed in MySQL Command Console. The error specifically mentioned in the title of this article “ERROR 1010 (HY000): Error drop database (can’t rmdir ‘./db’, errno:39)”. Where the ‘./db’ in the error message is referring to the name of the database which is going to be dropped.

The error is shown in detail through the execution of the following command :

Continue reading “MySQL Error Message : ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./db’, errno: 39)”

MySQL Error Message : ERROR 1114 (HY000) at line 4032: The table ‘table’ is full

This is an article where the focus of the main discussion is about how to solve the error message of MySQL Database Server generated upon restoring a dump file into a single database. The error specifically shown in the title of the article which is ‘ERROR 1114 (HY000) at line 4032: The table named ‘table’ is actually full. So, the error happened at the time of restoring a single database is in progress. It is shown as follows :

root@hostname:/etc/mysql/conf.d# mysql -uroot -p mydb < /root/mydb_20170919_140100.sql
Enter password: 
ERROR 1114 (HY000) at line 4780: The table 'xx_first_table' is full
root@hostname:/etc/mysql/conf.d#

As shown in the restoring progress of the database named ‘mydb’ using the dump file named ‘mydb_20170919_140100.sql’ as located in the ‘/root/’, the process eventually stop and generated an error shown in the following highlight :

Continue reading “MySQL Error Message : ERROR 1114 (HY000) at line 4032: The table ‘table’ is full”

MySQL Error Message : ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

This is an article related on how to solve the error a specified in the title of this article. The error message is ‘ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2). These kinds of error happened exactly at the time of the execution command to log in to MySQL Database Server is executed. The command to log in to MySQL Database Server is shown as follows :

root@hostname:~# mysql -uroot
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
root@hostname:~#

First of all, to solve the problem shown in the above output command which is involving MySQL Database Server preventing user from logging in to MySQL Database Server, below is the steps taken :

1. Check the MySQL Database Server’s service. Checking the service can be done in the following article titled ‘Check MySQL Service Status’ in this link. And the result in checking MySQL Database Server turns out that the service is active as shown in the following output :

Continue reading “MySQL Error Message : ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)”

How to Connect to mariadb using MySQL Client

This is an article showing how to connect to mariadb database server using MySQL client. MySQL client is actually can be utilized to connect to mariadb database server. So, in order to connect to mariadb, there are several things to be done can be done in the following steps :

  1. Install MySQL client as follows :

Continue reading “How to Connect to mariadb using MySQL Client”