DB Resource Usage

Byalexrusin December 19, 2018

You can use the following query to see who is using your database resources

SELECT max(user) as user, count(*) as connections_count, db from information_schema.processlist GROUP BY db order by connections_count desc;

Share this article

PHP MySQL Development | WordPress Development

Create WordPress User with Admin Privileges in MySQL
Byalexrusin July 23, 2017July 23, 2017

INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`) VALUES (‘admin’, MD5(‘password’), ‘User Admin’, ‘user@admin.com’, ‘0’); INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’); INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_user_level’, ’10’); Share this article

Share this article

Read More Create WordPress User with Admin Privileges in MySQL
Laravel | PHP MySQL Development

API Server Logging with Laravel
Byalexrusin September 11, 2020September 11, 2020

When you work with APIs it is usually a good idea to log requests and responses. I already covered how to do logging when you are consuming an API. You can read about it in this post. Here we will cover how to do it when building an API service with Laravel. For example, you…

Share this article

Read More API Server Logging with Laravel
Laravel | PHP MySQL Development | System Administration

Laravel Jenkins CI
Byalexrusin November 26, 2017

This article covers installation of Jenkins on Ubuntu server and its usage to continuously integrate a Laravel application. Besides LAMP/LEMP stack we need to install Java, Git, Composer, and Node to successfully use Jenkins. Before starting to install this software, let’s take care of miscellaneous stuff. Miscellaneous (can skip this). Create mysql user and database….

Share this article

Read More Laravel Jenkins CI
PHP MySQL Development

Replace Funky Characters While Importing CSV
Byalexrusin August 19, 2018August 19, 2018

Sometimes uploaded text/csv file may have non-utf8 or other funky characters using the function below. public static function processUploadedBundles($request) { $content = file_get_contents($request->file(‘uploadedFile’)->getRealPath()); $lines = explode(PHP_EOL, $content); $array = []; foreach ($lines as $line) { $arrayCsv = str_getcsv($line, “,”); $arrayCsv = array_map(function($value){ return preg_replace(‘/[\x00-\x1F\x7F-\xFF]/’, ”, $value); }, $arrayCsv); $array[] = $arrayCsv; } return $array; }…

Share this article

Read More Replace Funky Characters While Importing CSV
Laravel | PHP MySQL Development

Exporting Records with Timezone Adjustments
Byalexrusin August 27, 2020August 27, 2020

As a rule, dates in a database are stored in UTC. So, when you export records from database constrained by dates, it is a good idea to use appropriate timezone in export query. You can do it in one of two ways. One way is create incoming dates in user’s timezone, then covert time to…

Share this article

Read More Exporting Records with Timezone Adjustments
PHP MySQL Development | System Administration

Using PhpMyAdmin With Homestead
Byalexrusin June 18, 2017June 18, 2017

Laravel Homestead includes a lot of software, but unfortunately does not have PhpMyAdmin. You can always install it on nginx, but if you have it already on your host system (for example, as a part of xampp package), you can always configure it as a Nginx site. First of all, you need to edit your config.inc.php file. At…

Share this article

Read More Using PhpMyAdmin With Homestead

Similar Posts