z z z z z z z z z

z z z z z z z z z

Main menu

Skip to primary content
Skip to secondary content
  • Home
  • Bookmarklet Generator
  • Business Name Generator
  • What is my IP address?
  • Whois Lookup

Tag Archives: mysql

How to Add an Admin User to the WordPress Database via MySQL

Posted on May 29, 2014 by zzz_zwp

Make sure to use the proper prefix for ‘wp_’ if you have a custom database prefix and to follow the existing user capabilities values when manually adding a user to WordPress. How to Add an Admin User to the WordPress … Continue reading →

Posted in Uncategorized | Tagged manual-add-user, mysql, wordpress

MySQL Create Database and Add User

Posted on July 19, 2012 by zzz_zwp
Reply

Here’s a quick overview of the commands involved in creating a MySQL database, creating a user and adding them to the database and importing an sql backup into the newly created database. *This assumes you already have some way to … Continue reading →

Posted in Uncategorized | Tagged database, mysql | Leave a reply

Shopify for Ecommerce

Use Shopify for ecommerce

WP Engine

Use WP Engine for WordPress Hosting




Recent Posts

  • Here’s a list of handy Vim commands
  • Uses This Product Listing
  • Postgresql Commands to Import / Export (pg_restore, pg_dump) databases
  • mkdir(1) – Linux manual page
  • Ruby on Rails Infinite Scroll Patterns

Recent Comments

    Archives

    • March 2023
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • May 2017
    • April 2017
    • February 2015
    • January 2015
    • November 2014
    • October 2014
    • July 2014
    • June 2014
    • May 2014
    • January 2014
    • November 2013
    • August 2013
    • June 2013
    • May 2013
    • April 2013
    • March 2013
    • January 2013
    • December 2012
    • November 2012
    • October 2012
    • September 2012
    • August 2012
    • July 2012
    • June 2012
    • May 2012
    • April 2012
    • March 2012
    • February 2012
    • January 2012
    • December 2011
    • November 2011
    • October 2011
    • September 2011
    • August 2011
    • July 2011
    • June 2011
    • May 2011
    • April 2011
    • March 2011
    • February 2011
    • January 2011
    • December 2010
    • November 2010
    • October 2010
    • September 2010
    • August 2010
    • July 2010
    • June 2010
    • May 2010
    • April 2010
    • March 2010
    • February 2010
    • January 2010
    • December 2009
    • November 2009
    • October 2009
    • September 2009
    • August 2009
    • July 2009
    • June 2009
    • April 2009
    • May 2008

    Categories

    • Coding
    • Editors
    • Hotkeys
    • MacOS
    • Shell Scripts
    • Uncategorized
    • Vim

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org
    © zzzzzzzzz
    Toggle Console (1)
    Unknown
    Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the gotmls domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) on line 6131 in file /home1/zzz/public_html/wp-includes/functions.php
    Profiler (0 ms)
    No entries found.
    SQL (39 queries | 47.04 ms)
    0.5679
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'GOTMLS_nonce_array' 
    LIMIT 1
    0.5710
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'GOTMLS_definitions_array' 
    LIMIT 1
    0.5629
    SELECT * 
    FROM `wp_posts` 
    WHERE post_type = 'gotmls_results' 
    AND post_name = 'e2c9a3829702c248f1752c07cf31234f'
    0.4711
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'gzipcompression' 
    LIMIT 1
    5.0189
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'rsssl_encryption_keys_set' 
    LIMIT 1
    0.5169
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' 
    LIMIT 1
    0.2182
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'rsssl_ssl_activation_active' 
    LIMIT 1
    0.5112
    SELECT option_name, option_value 
    FROM wp_options 
    WHERE option_name IN ('_site_transient_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4','_site_transient_timeout_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4')
    0.8881
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'preload_cache_counter' 
    LIMIT 1
    0.9511
    SELECT t.term_id 
    FROM wp_terms AS t 
    INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id 
    WHERE tt.taxonomy IN ('post_tag') 
    AND t.slug IN ('mysql') 
    LIMIT 1
    0.6039
    SELECT t.*, tt.* 
    FROM wp_terms AS t 
    INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id 
    WHERE t.term_id IN (67)
    1.4172
    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID 
    FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) 
    WHERE 1=1 
    AND ( wp_term_relationships.term_taxonomy_id IN (67) ) 
    AND ((wp_posts.post_type = 'post' 
    AND (wp_posts.post_status = 'publish'))) 
    GROUP BY wp_posts.ID 
    ORDER BY wp_posts.post_date DESC 
    LIMIT 0, 10
    0.4060
    SELECT FOUND_ROWS()
    0.4649
    SELECT wp_posts.* 
    FROM wp_posts 
    WHERE ID IN (1620,52)
    0.3810
    SELECT post_id, meta_key, meta_value 
    FROM wp_postmeta 
    WHERE post_id IN (1620,52) 
    ORDER BY meta_id ASC
    0.9499
    SELECT DISTINCT t.term_id, tr.object_id 
    FROM wp_terms AS t 
    INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id 
    INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id 
    WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') 
    AND tr.object_id IN (1620, 52) 
    ORDER BY t.name ASC
    0.5870
    SELECT t.*, tt.* 
    FROM wp_terms AS t 
    INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id 
    WHERE t.term_id IN (68,439,1,200)
    0.3400
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'mwp_communication_key' 
    LIMIT 1
    0.4501
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'mwp_communication_keys' 
    LIMIT 1
    0.4640
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'can_compress_scripts' 
    LIMIT 1
    0.4930
    SELECT * 
    FROM wp_posts 
    WHERE ID = 1716 
    LIMIT 1
    2.7130
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'https_migration_required' 
    LIMIT 1
    0.2201
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'site_logo' 
    LIMIT 1
    0.3471
    SELECT t.*, tt.* 
    FROM wp_terms AS t 
    INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id 
    WHERE t.term_id = 468
    1.0729
    SELECT wp_posts.* 
    FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) 
    WHERE 1=1 
    AND ( wp_term_relationships.term_taxonomy_id IN (468) ) 
    AND wp_posts.post_type = 'nav_menu_item' 
    AND ((wp_posts.post_status = 'publish')) 
    GROUP BY wp_posts.ID 
    ORDER BY wp_posts.menu_order ASC
    0.5171
    SELECT post_id, meta_key, meta_value 
    FROM wp_postmeta 
    WHERE post_id IN (1670,1671,1672,1681,1682) 
    ORDER BY meta_id ASC
    0.2561
    SELECT wp_posts.* 
    FROM wp_posts 
    WHERE ID IN (1542,1534,1579,1544)
    0.2840
    SELECT post_id, meta_key, meta_value 
    FROM wp_postmeta 
    WHERE post_id IN (1542,1534,1579,1544) 
    ORDER BY meta_id ASC
    1.1890
    SELECT user_id, meta_key, meta_value 
    FROM wp_usermeta 
    WHERE user_id IN (1) 
    ORDER BY umeta_id ASC
    0.4482
    SELECT * 
    FROM wp_users 
    WHERE ID IN (1)
    0.9689
    SELECT wp_posts.ID 
    FROM wp_posts 
    WHERE 1=1 
    AND wp_posts.post_type = 'post' 
    AND ((wp_posts.post_status = 'publish')) 
    ORDER BY wp_posts.post_date DESC 
    LIMIT 0, 5
    8.3280
    SELECT wp_posts.* 
    FROM wp_posts 
    WHERE ID IN (1771,1734,1728,1725,1721)
    1.0300
    SELECT post_id, meta_key, meta_value 
    FROM wp_postmeta 
    WHERE post_id IN (1771,1734,1728,1725,1721) 
    ORDER BY meta_id ASC
    1.1270
    SELECT DISTINCT t.term_id, tr.object_id 
    FROM wp_terms AS t 
    INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id 
    INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id 
    WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') 
    AND tr.object_id IN (1771, 1734, 1728, 1725, 1721) 
    ORDER BY t.name ASC
    0.9091
    SELECT t.*, tt.* 
    FROM wp_terms AS t 
    INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id 
    WHERE t.term_id IN (489,490,478,484,492,483,479,480,485,486,481,482,14,37,491,82)
    0.4840
    SELECT wp_comments.comment_ID 
    FROM wp_comments JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID 
    WHERE ( comment_approved = '1' ) 
    AND comment_type NOT IN ('note') 
    AND wp_posts.post_status IN ('publish') 
    ORDER BY wp_comments.comment_date_gmt DESC 
    LIMIT 0,5
    8.3749
    SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts 
    FROM wp_posts 
    WHERE post_type = 'post' 
    AND post_status = 'publish' 
    GROUP BY YEAR(post_date), MONTH(post_date) 
    ORDER BY post_date DESC
    1.2579
    SELECT t.term_id 
    FROM wp_terms AS t 
    INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id 
    WHERE tt.taxonomy IN ('category') 
    AND tt.count > 0 
    ORDER BY t.name ASC
    0.6790
    SELECT t.*, tt.* 
    FROM wp_terms AS t 
    INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id 
    WHERE t.term_id IN (475,474)
    Templates
    [0] => themes/twentyeleven/inc/theme-options.php
    [1] => themes/twentyeleven/inc/widgets.php
    [2] => themes/twentyeleven/tag.php
    [3] => themes/twentyeleven/header.php
    [4] => themes/twentyeleven/searchform.php
    [5] => themes/twentyeleven/content.php
    [6] => themes/twentyeleven/sidebar.php
    [7] => themes/twentyeleven/footer.php
    [8] => themes/twentyeleven/sidebar-footer.php
    Globals
    $_GET = array (
    );

    $_POST = array (
    );

    $_COOKIE = array (
    );

    $_SESSION = array (
    );

    $_SERVER = array (
      'SERVER_SOFTWARE' => 'Apache',
      'REQUEST_URI' => '/tag/mysql/',
      'LSPHP_ENABLE_USER_INI' => 'on',
      'PATH' => '/usr/local/bin:/usr/bin:/bin',
      'TEMP' => '/tmp',
      'TMP' => '/tmp',
      'TMPDIR' => '/tmp',
      'PWD' => '/',
      'HTTP_ACCEPT' => '*/*',
      'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate',
      'CONTENT_LENGTH' => '0',
      'HTTP_HOST' => 'www.zzzzzzzzz.net',
      'HTTP_REFERER' => 'https://www.zzzzzzzzz.net/tag/mysql',
      'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
      'HTTP_X_HTTPS' => '1',
      'REDIRECT_UNIQUE_ID' => 'aauxmKVqUyI_XcPtgVHq3AAATlQ',
      'REDIRECT_QS_ConnectionId' => '177285980039835352825071',
      'REDIRECT_SCRIPT_URL' => '/tag/mysql/',
      'REDIRECT_SCRIPT_URI' => 'https://www.zzzzzzzzz.net/tag/mysql/',
      'REDIRECT_HTTPS' => 'on',
      'REDIRECT_SSL_TLS_SNI' => 'www.zzzzzzzzz.net',
      'REDIRECT_HTTP2' => 'on',
      'REDIRECT_H2PUSH' => 'off',
      'REDIRECT_H2_PUSH' => 'off',
      'REDIRECT_H2_PUSHED' => '',
      'REDIRECT_H2_PUSHED_ON' => '',
      'REDIRECT_H2_STREAM_ID' => '17',
      'REDIRECT_H2_STREAM_TAG' => '825071-482-17',
      'REDIRECT_STATUS' => '200',
      'UNIQUE_ID' => 'aauxmKVqUyI_XcPtgVHq3AAATlQ',
      'QS_ConnectionId' => '177285980039835352825071',
      'SCRIPT_URL' => '/tag/mysql/',
      'SCRIPT_URI' => 'https://www.zzzzzzzzz.net/tag/mysql/',
      'HTTPS' => 'on',
      'SSL_TLS_SNI' => 'www.zzzzzzzzz.net',
      'HTTP2' => 'on',
      'H2PUSH' => 'off',
      'H2_PUSH' => 'off',
      'H2_PUSHED' => '',
      'H2_PUSHED_ON' => '',
      'H2_STREAM_ID' => '17',
      'H2_STREAM_TAG' => '825071-482-17',
      'SERVER_SIGNATURE' => '',
      'SERVER_NAME' => 'www.zzzzzzzzz.net',
      'SERVER_ADDR' => '192.185.137.117',
      'SERVER_PORT' => '443',
      'REMOTE_ADDR' => '216.73.216.148',
      'DOCUMENT_ROOT' => '/home1/zzz/public_html',
      'REQUEST_SCHEME' => 'https',
      'CONTEXT_PREFIX' => '',
      'CONTEXT_DOCUMENT_ROOT' => '/home1/zzz/public_html',
      'SERVER_ADMIN' => 'webmaster@zzzzzzzzz.net',
      'SCRIPT_FILENAME' => '/home1/zzz/public_html/index.php',
      'REMOTE_PORT' => '26719',
      'REDIRECT_URL' => '/tag/mysql/',
      'SERVER_PROTOCOL' => 'HTTP/2.0',
      'REQUEST_METHOD' => 'GET',
      'QUERY_STRING' => '',
      'SCRIPT_NAME' => '/index.php',
      'PHP_SELF' => '/index.php',
      'REQUEST_TIME_FLOAT' => 1772859800.41936492919921875,
      'REQUEST_TIME' => 1772859800,
      'argv' => 
      array (
      ),
      'argc' => 0,
    );

    Close