|

Create WordPress User with Admin Privileges in MySQL

Byalexrusin 
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

Similar Posts

Upload to FTP with PHP

Byalexrusin

$fp = fopen(’https://www.example.com/pdfdoc’, ‘r’);   $user = "sammy"; $pass = "password"; $ftp_server = "192.168.10.10";   //should be wrapped in try catch to properly handle errors $ftp_conn = ftp_ssl_connect($ftp_server); $login = ftp_login($ftp_conn, $user, $pass);   ftp_chdir($ftp_conn, ‘path/to/folder’); //can also use ftp_pwd   ftp_pasv($ftp_conn, true); //passive mode   ftp_fput($ftp_conn, "mydocument.pdf", $fp, FTP_BINARY);   fclose($fp); ftp_close($ftp_conn);$fp = fopen(‘https://www.example.com/pdfdoc’,…

Share this article
|

WordPress Errors and Solutions

Byalexrusin

Infinite redirect loop If there is infinite redirect loop, put this line in functions.php of current theme. remove_filter(‘template_redirect’, ‘redirect_canonical’); WordPress asks for FTP credentials Change ownership of your WordPress directory. chown –R www-data:www-data Nginx: 413 Request Entity Too Large Error Change Nginx config file sudo nano /etc/nginx/nginx.conf # set client body size to 128M #…

Share this article
Debugging Webhooks
|

Debugging Webhooks

Byalexrusin

A webhook is an HTTP callback, that occurs when something happens (a resource changes its state). Webhooks provide a way to build event-driven apps, because you can be notified about changes. Since webhooks require a publicly accessible URL to function they can be hard to test from your local machine.  There are three main problems…

Share this article
|

Testing with Service Container

Byalexrusin

The backbone of Laravel is service container.  Service container is used for resolving classes and dependency injection.  Container comes as a standalone package, so you don’t have to have Laravel installed to use it.  Service container can be very handy when testing.  Let’s look at how we can use it . Our basic set up…

Share this article