mysql

  1. K

    Steps to repair Mysql database in cpanel

    You can follow below steps to repair Mysql database database in cpanel: Log in to cPanel. Here in “Database” section you have to click on “MySQL databases”. A new window will open in “Modify Databases” section, now select the database from drop-down and click on “Repair the database” button
  2. K

    Repair or Recover InnoDB Tables in MySQL: A Complete Guide

    Server crashing in the middle of a session will lead to inconsistent states. As opposed to repairing MYISAM tables in MySQL, repairing InnoDB isn’t that straightforward. There aren’t many dedicated tools available for repairing InnoDB. In this article, learn how to repair or repair InnoDB tables...
  3. K

    Ways to fix “mysqldump error 2003”

    Server owners will often use mysqldump for taking database backup completely. While using this tool, you may get some errors. This error states that the connection has been refused by the network. Below is the statement of how you will get the error message: mysqldump: Got error: 2003: Can't...
  4. K

    Fixing the MySQL ‘1146 Table Doesn’t Exist’ Error in Your Server

    The 1146 Table Doesn’t Exist is a common error faced by MySQL server admins. While there are multiple reasons behind this error, fixing it is actually easy. In this article, we explain those reasons and provide solution to fix the issue. Why the 1146 Table Doesn’t Exist Error Occurs? As...
  5. K

    What to do for the ‘MySQL Service Detected With Wrong Path’ error message?

    There are certain error messages in MySQL that lack pointers to the error source. In such cases, it becomes pretty hard to fix the error. One such error message is the ‘MySQL Service Detected with Wrong Path’ error. This problem occurs even after you’ve configured MySQL properly. In this...
  6. K

    How to change MySQL/MariaDB innodb_log_file_size value?

    You might be a long way to find innodb_log_file_size values in MySQL/MariaDB. For Linux users: Step 1: Use SSH to get connect Plesk server Step 2: Now stop the service of MySQL and choose the command by selecting the version MySQL or OS: # servicemariadb stop # servicemysql stop Step 3: Use...
  7. K

    Steps to know the location of MySQL or MariaDB log

    You can use below steps: Login to your server via SSH as root user. You can run below command : mysql -e "show variables like '%log%';" Here you have to find the option “log_error” and you will get the log file. If you are still not able to get response then you can check mysql configuration...
  8. K

    Way to fix MySQL down but running as mysqld_safe

    MySQL got down now! You would received a statement from WHM and cPanel. # /usr/local/cpanel/scripts/restartsrv_mysql --status (XID l35tte) The “mysql” service is down. But still, you are running with mysqld_safe till now: # ps fauxww | grep mysq[l] root 1030 0.0 0.1 113632 1593 ? S 12:31 0:00...
  9. K

    Complete Guide to Fixing the max_join_size MySQL Error

    When working with the MySQL server, its common to encounter one error or another. One of the errors many admins have to regularly deal with is the “max_join_size” error. The complete error message reads ‘The SELECT would examine more than MAX_JOIN_SIZE rows’. This error usually happens when...
  10. K

    Steps to kill MySQL connections on server

    If you are making too many database connections then you will get error “too many database connections”, to resolve this error you can manually terminate database connections. Most quick and easy ways to terminate or kill MySQL connections is to restart MySQL services. You can use below command...
  11. K

    Steps to find out about cpanel User for particular user using MySQL query

    We have to find database name and user name from table name which only we have. Let’s see how to find the details of database and cpanel user. If you want to determine the user of particular table then first you have to find out database name. For this you have to run below command, but make...
  12. K

    Steps to find MySQL data location

    Normally MySQL data will store in /var/lib/mysql, but still you want to check the the location of your database then you can follow below steps: You can use below command to find the location of data directory: mysql -e "show variables like 'datadir'" You can get the directory for MySQL with...
  13. K

    Resolve Error “Restarting MySQL due to my.cnf modifications."

    Mysqluserstore script helps to update users.db and users.db.cache file. You can check location of these files : /var/cpanel/databases/users.db /var/cpanel/databases/users.db.cache After that you will get below error: [mysqluserstore] Restarting MySQL due to my.cnf modifications. You have to...
  14. K

    Fixing the MySQL Error 1040: Too many connections

    When working with MySQL servers, you may face errors from time to time. One of them is the MySQL Error 1040: Too Many Connections. So what does this error message means? And how to deal with it? The message basically means that the server has reached maximum number of alloted connections. So it...
  15. K

    Steps to install MySQL Governor

    With MySQL governor we can set the limits of LVE for MySQL users and its provided by CloudLinux. You can use below command to install MySQL governor package: yum install governor-mysql Now we have to select the MySQL version and version should be one of the below...
  16. K

    How to unlock and lock MySQL users?

    You can lock MySQL user from MySQL database and also unlock them. You can only modify MySQL user with root privileges and that’s why it is must to have root access. You can login to MySQL as a root use this command: # mysql Now you have to run below command to lock user: ALTER USER...
  17. K

    Steps to allow dynamic IP address to connect MySQL Remotely

    If you are using dynamic IP address to make connection with MySQL remotely, its little bit tricky to allow dynamic IP Address because it changes frequently. You can add wild card IP’s in Remote MySQL option. For Example: As we know whenever the IP address changes only its last 2 digits updates...
  18. K

    How to change Default character set in MySQL with command line?

    If you want to change default character set in Mysql then first you have to open my.cnf file with below command: vi /etc/my.cnf in this file you have to add below line: default-character-set=utf8 Under [mysqld] add below lines too: default-character-set=utf8 init_connect=’SET NAMES utf8′...
  19. K

    Steps to disable mysql strict mode

    In mysql database 5.7 version strict mode is enabled but if you are getting issue or your application requirement is to disable strict mode then you can check this article. Mysql mainly helps to handle missing or invalid values in data change statements (INSERT or UPDATE). If mysql strict mode...
  20. K

    What are MySQL triggers? And steps to use them

    MySQL triggers is an object which is attached with particular table and execute when that event occur. These triggers only work when any of these Mysql statements run like INSERT, UPDATE, DELETE etc. NOTE: You can only use triggers if you have MySQL SUPERUSER privileges. So you have your own...
Top