Tag: PHP

Feed: Liquid Web. Author: Jan Koch; WordPress is a popular target amongst hackers and often has the notion of not being secure. I want to explain how WordPress sites get hacked and what you can do about it. Even without touching code or complicated plugins, it’s quite manageable to protect your site.The challenge for most WordPress users is that they don’t even know whether their site is getting attacked by hackers or not. Attacks often start with bots trying to find a valid username and password, simply by enumerating hundreds of thousands of username/password combinations on your wp-login.php URL. Those ... Read More

Feed: Planet MySQL; Author: Michael McLaughlin; While building my student image on Fedora 30, I installed the MySQL PHP Connector (php-mysqlndrp) but neglected to install the Python Connector. This adds the installation and basic test of the Python Connector to the original blog post. You use the following command with a wildcard as a privileged user. The wildcard is necessary because you need to load two libraries to support Python 2.7 and 3.7, which are installed on Fedora 30. You also need to be the root user or a user that is found in the sudoer’s list: yum install -y ... Read More

Feed: Planet MySQL; Author: FromDual; Since version 2.1.0 the FromDual Recovery Manager (rman) for MariaDB and MySQL has also a progress indicator for the restore of logical backups made with mysqldump. This feature was implemented because of the numerous requests of FromDual rman users who were not happy with the default mysql behavior.You can check your current rman version as follows: # ./bin/rman --version 2.2.1 As with all FromDual tools you get a command overview with examples with the --help option: # ./bin/rman --help | less ... progress Print progress information to STDOUT. ... A backup for example is done ... Read More

Feed: Planet MySQL; Author: FromDual; ContentsIntroduction Recently we had a consulting engagement where we had to help the customer to migrate from latin1 Character Set to utf8mb4 Character Set. In the same MySQL consulting engagement we considered to upgrade from MySQL 5.6 to MySQL 5.7 as well [ Lit. ]. We decided to split the change in 2 parts: Upgrading to 5.7 in the first step and converting to uft8mb4 in the second step. There were various reasons for this decision: 2 smaller changes are easier to control then one big shot. We assume that in 5.7 we experience less ... Read More

Feed: R-bloggers. Author: Blog - BS. [This article was first published on Blog - BS, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. Earlier this year, I released a simple R package (available at basilesimon/noaastorms) that downloads, cleans and parses NOAA IBtrack data for you. As the NOAA updated its datasets, noaastorms is now using these! How to install library(devtools) install_github("basilesimon/noaastorms") Available functions getStorms: Fetch NOAA historical best track storms data > df ... Read More

Feed: Planet MySQL; Author: Michael McLaughlin; There was an option during the Fedora 30 Workstation installation to add the Apache Web Server, but you need to set it to start automatically. Unfortunately, there was no option to install PHP, which I thought odd because of how many web developers learn the trade first on PHP with a LAMP (Linux, Apache, MySQL, Perl/PHP/Python) stack. You see how to fix that shortcoming in this post and how to install and test PHP, mysqli, and pdo to support MySQL 8. Before you do that make sure you install MySQL 8. You can find ... Read More

Feed: CronJ. Author: Vignesh M; Everyone’s familiar with JavaScript the most popular programming language used as a client-side development tool in 95 percent of websites. But what about server-side programming? Well, with the introduction of Node.JS, JavaScript has become an all-purpose full stack development language. While Angular, React and Vue are Front-end Frameworks / Libraries, Node is the one and only Javascript based Back-end framework. So, let’s discuss what Node.JS is and then explore its advantages and disadvantages. CronJ NodeJSNode.JS is an open-source runtime environment for JavaScript. It’s based on Chrome v8, an engine for chromium browsers. Node.JS allows your ... Read More

Feed: Planet MySQL; Author: Dave Stokes; Multi-Valued Indexes are going to change the way you think about using JSON data and the way you architect your data. Before MySQL 8.0.17 you could store data in JSON arrays but trying to search on that data in those embedded arrays was tricky and usually required a full table scan.  But now it is easy and very quick to search and to access the data in JSON arrays. Multi-Valued Indexes A Multi-Valued Index (MVI) is a secondary index defined on a column made up of an array of values.  We are all used ... Read More

Feed: Planet MySQL; Author: Marco Tusa; To set correct system variable values is the essential step to get the correct server behavior against the workload. In MySQL, we have many System variables that can be changed at runtime, and most of them can be set at the session or global level.To change the value of a system variable at the global level in the past, users needed to have SUPER privileges. Once the system variable value is modified as global, the server will change this behavior for the session, and obviously as global scope.For instance, one of the most commonly ... Read More

Feed: Planet MySQL; Author: Marco; To set correct system variable values is the essential step to get the correct server behavior against the workload.  In MySQL we have many System variables that can be changed at runtime, most of them can be set at session or at global scope.  To change the value of a system variable at global level in the past user need to have SUPER privileges. Once the system variable value is modified as global, the server will change his behavior for the session, and obviously as global scope. For instance, one of the most commonly adjusted ... Read More