mysql

You will find that MySQL strict mode is by default enabled, but if you want to enable/disable it according to your requirement then you can follow below steps: Login to your Windows VPS server. Now you have to find my.ini find to modify strict mode. Go to C:\ProgramData\MySQL\MySQL Server 5.7...

To manage MySQL service it is must to have root SSH access. To stop MySQL service you can run below command: service mysql stop OR /etc/init.d/mysql stop To start MySQL service you can run below command service mysql start OR /etc/init.d/mysql start To restart MySQL service you can run...

If you are getting below error while establishing connection with “Collection Max” then you can check below steps to resolve issue. Error while starting mysql: Fatal error: Can't open and lock privilege tables: Table '.\mysql\user' is marked as crashed and should be repaired. MySQL server would...

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...