MySQL Bin Files Memakan Banyak Space Hardisk Server

Disable MySQL binlogging If you are not replicating, you can disable binlogging by changing your my.ini or my.cnf file. Open your my.ini or /etc/my.cnf (/etc/mysql/my.cnf), enter:# vi /etc/my.cnfFind a line that reads “log_bin” and remove or comment it as follows: #log_bin = /var/log/mysql/mysql-bin.log You also need to remove or comment following lines: #expire_logs_days = 10 #max_binlog_size = 100M Close and save the fi ...

View More
  Dibaca 1698 kali

sudo add-apt-repository ppa:ondrej/php error not intall

So, open a terminal and use this command: sudo apt-get install software-properties-commonand then sudo apt-get update ...

View More
  Dibaca 1535 kali

cant login as mysql user root from normal user account in ubuntu 18.04

So in order to to change the plugin back to mysql_native_password: Login with sudo: sudo mysql -u root Change the plugin and set a password with a single command: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test'; note test is your password   OR    ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("verysecret") ...

View More
  Dibaca 1254 kali

you may need to install the HTML::Entities module

  I managed to sort it myself. As I was using the server provided by my university I had no access to install the required module (HTML::Entities). I decided to then set up the required module on my own Apache web server on a virtual machine and managed to get it working this way after sorting out some syntax/spelling errors. The way I installed the HTML::Entities module was through the synaptic package manager, just by searching libhtml-parser-perl the module was found and installed. I r ...

View More
  Dibaca 2667 kali

restart ubuntu nginx not running

sudo systemctl enable nginx.service // try a reboot sudo reboot // check status of nginx sudo systemctl status nginx.service // can start it with this to see if it's running properly sudo systemctl start nginx.service ...

View More
  Dibaca 1397 kali

Ubuntu Cannot Ping Domain

Create a file called /etc/resolv.conf write fill in the contents: nameserver For example if your want to use googles dns-service: nameserver 8.8.8.8 nameserver 8.8.4.4 This is likely caused by DHCP configuration when you first installed Ubuntu. Try this 3-step process to handle this auto configuration issue. First Edit your interface configuration, which is located in: /etc/network/interfaces Add this line below iface lo inet loopback: dns-nameservers yourdns youraltdns As ...

View More
  Dibaca 1945 kali

How can I disable MySQL Strict Mode?

This is enabled by default, but you can disable it in one of a couple ways. First, verify which mode(s) MYSQL is running with: $ mysql -u root -p -e "SHOW VARIABLES LIKE 'sql_mode';" You'll need to replace root with whatever username has superuser permissions on your server (but, it's usually just root). You'll also be prompted for the password. This will print out something like this (but much prettier): sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_D ...

View More
  Dibaca 2627 kali

PHP Session not Saving

Your session directory (probably /tmp/) is not writable. Check with session_save_path() if it is writable. if (!is_writable(session_save_path())) { echo 'Session path "'.session_save_path().'" is not writable for PHP!'; } ...

View More
  Dibaca 2275 kali