How to clone a database in MySQL OR MariaDB
How to clone a database in MySQL OR MariaDB There has been instances when you need to copy a database in MySQL/MariaDB. I'll narrate ...
Showing posts with label MySQL. Show all posts
Showing posts with label MySQL. Show all posts
SECURING MYSQL / MARIADB WITH MYSQL_SECURE_INSTALLATION
SECURING MYSQL / MARIADB WITH MYSQL_SECURE_INSTALLATION We'll be performing basic security in a mariadb installation like, root pass...
Solved : Last_IO_Error: Got fatal error 1236 from master when reading data from binary log
Backing up the any Configuration item is something that you need to do utmost carefully. We do maridb replication. The replication stopped ...
MySQL/MariaDB DBERROR: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception
Error: WARNING: Connect failed: DBERROR: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exce...
Empty set error in MySQL while Importing DB?
Empty set error in MySQL while Importing DB? Error: MariaDB [(none)]> use exampledb Database changed MariaDB [exampledb]> show t...
How to Create New user and Give access to it in mariaDB/MySQL?
How to Create New user and Give access to it in mariaDB/MySQL? 1. Go to MySQL Prompt. mysql -u root -p 2. At MySQL Prompt choose ...
Fatal Error: Contact system adminstrator. Unable to connect to Database : OS Ticket
Fatal Error: Contact system administrator . Unable to connect to Database : OS Ticket osticket php Cause: You would get this err...
How to Add MySQL Graphs to Cacti?
How to Add MySQL Graphs to Cacti? 1. Download the Percona MySQL Graph template for cacti. 2. Create a MySQL user with the SUPER and PRO...
How to Add MySQL/MariaDB to zabbix monitoring?
How to Add MySQL/MariaDB to zabbix monitoring ? Its important to monitor your Database. Be it availability, DB size etc. We can mo...
How to Take Backup Of MySQL/MariaDB Database and Restore it
How to Take Backup Of MySQL/MariaDB Database and Restore it.. Backup of MySQL database with the native tools is something that most the My...
How to Add remote host in phpMyadmin
How to Add remote host in phpMyadmin Solution: 1. edit the file /etc/phpMyAdmin/config.inc.php 2. Add the Remote host in the format...
How to Configure phpMyadmin on a Virtual host?
How to Configure phpMyadmin on a Virtual host? 1. Install epel rpm for epel repo as per your version. 2. Install php,phpMyAdmin,ph...
Error : file size limit exceeded in Cacti
Error : file size limit exceeded in Cacti /bin/bash: line 1: 23691 File size limit exceededphp /srv/www/htdocs/cacti/poller.php Res...
How to Upgrade Mariadb?
How to Upgrade Mariadb? Solution: [root@exampledb mariadb]# mysql_upgrade -p root Enter password: ...
How to Set root password in Mysql or Maria DB
How to Set root password in Mysql or Maria DB. 1. Run this command to start MySql in Safe Mode. [root@exampledb ~]# mysqld_safe --skip...
Solved mysql Disk is full Errcode: 28
Error: mysqld: Disk is full writing '/var/lib/mysql/cacti/user_log.MYI' (Errcode: 28) Resolution: As the Error Suggest we n...
SMT MySQL Error: Failed: Can't connect to local MySQL server through socket
On one fine day someone reported that the SMT server is not able to get the repository catalogue. While i checked i found that the queri...
Subscribe to:
Posts
(
Atom
)
