FIX : PHPMyAdmin Error - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist

Locate config.inc.php within phpMyAdmin folder.

Find and edit the below mentioned line .

       

$ Cfg ['Servers'] [$ i] ['table_uiprefs'] = ‘pma_table_uiprefs’;

 

Into

       

$ cfg ['Servers'] [$ i] ['pma__table_uiprefs'] = ‘pma__table_uiprefs’;

 
 

       

Finally to apply the changes Restart Apache

 

Read more ...

MariaDB Startup error Fix : mysqld: Can't create/write to file '/var/run/mariadb/mariadb.pid' (Errcode: 2)

170529 15:34:47 [ERROR] mysqld: Can't create/write to file '/var/run/mariadb/mariadb.pid' (Errcode: 2)
170529 15:34:47 [ERROR] Can't start server: can't create PID file: No such file or directory
170529 15:34:47 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended

Description of problem:
When I restart my RHEL 7 box, the mariadb service will not start, due to /var/run/mariadb not existing.

Version : mariadb-server-5.5.52-1.el7.x86_64

MariaDB isn't running, and you can't start it manually:

$ systemctl start mariadb

Error Lines.

170529 15:34:47 [Note] Server socket created on IP: '0.0.0.0'.
170529 15:34:47 [ERROR] mysqld: Can't create/write to file '/var/run/mariadb/mariadb.pid' (Errcode: 2)
170529 15:34:47 [ERROR] Can't start server: can't create PID file: No such file or directory
170529 15:34:47 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended






Additional info:
Fix this by creating the missing folder in the tmpfs and setting permission to mariadb:

# install -dpm770 -o mysql -g mysql /var/run/mariadb
# systemctl start mariadb  

Read more ...