mysql | Vevioz Developers

mysql

  1. DevOps

    Tutorial Disk Usage 100% on CyberPanel – How To Free Up Disk Space

    Is it LiteSpeed spamming error.log in lsws/logs or large tmp files? Using CyberPanel for managing your server, you might come across with full disk space problem. You notice that there is suddenly a huge increase in disk usage on your CyberPanel dashboard. Some times you will get the following...
  2. DevOps

    Tutorial MySQL: Show processlist every second

    -u username -p you will be promted for a password -i 1 interval one second Output will see like this one:
  3. DevOps

    Tutorial How do I disable Strict Mode in MySQL?

    Please follow the instructions given below to turn off the MySQL Strict Mode. This method disables it by changing the value of SQL_MODE in my.cnf file (for Linux) OR my.ini file (for windows server) and restarting the MySQL server. my.cnf file can be found in one of a few locations (depending...
  4. DevOps

    Tutorial Cyberpanel MySQL Config and mysql root password file located

    Of course any password that is stored in plain text is a bad idea but the location of the file is in /etc/my.cnf so if a remote user had access to that file I think there would be more things to worry about than having your mysql password stolen. On the other hand if you are not the only one who...
  5. DevOps

    Tutorial [WDR] Market not work

    Edit MySql conf on /etc/my.cnf /etc/mysql/my.cnf Paste this conf # # This group is read both by the client and the server # use it for options that affect everything # [client-server] sql-mode="" # # include *.cnf from the config directory # !includedir /etc/my.cnf.d Restart MySql service...
  6. DevOps

    Tutorial Warning: The sql-mode STRICT_TRANS_TABLES is enabled in your mysql server, please contact your host provider to disable it.

    Contents of File: /etc/my.cnf [mysqld] sql_mode=NO_ENGINE_SUBSTITUTION sudo service mysqld restart Done
  7. DevOps

    Tutorial Disable strict mode on MariaDB

    MySQL and MariaDB have been diverging since 2010, and now they should be considered different software products (sort of like Microsoft SQL server vs. Sybase). You should tell us which one you use, and tag your question appropriately. The answer to your question will be different depending on...
Top Bottom