markcerv

Search
Skip to content
  • YNAB – You Need a Budget

Monthly Archives: February 2021

Command Line (linux/bash), MySQL, sysadmin

Quick mysql commands

February 9, 2021 markcerv_admin Leave a comment
# configure mysql 1st time
mysql -u root --skip-password
mysql>  ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxx';
# create databases
mysqladmin -u root create wp_somename

CREATE USER wp_somename
@'localhost'   IDENTIFIED BY 'password123';
grant all on wp_somename
.* to wp_somename
@'localhost';
flush privileges;

Keeping track of what keeps me on track

Search Markcerv.com

Recent Posts

  • Update ubuntu system clock (ntpdate)
  • Quick mysql commands
  • WSL2 – Adding distro not in store
  • Upgrade powershell
  • watchmedo

Recent Comments

  • Another instance of Certbot is already running | markcerv on Certbot renewal script

Archives

  • March 2021
  • February 2021
  • August 2020
  • May 2020
  • April 2020
  • January 2020
  • October 2019
  • August 2019
  • June 2019
  • April 2019
  • March 2019
  • January 2019
  • September 2018
  • November 2017
  • October 2017
  • September 2017
  • July 2017
  • January 2017
  • November 2016
  • July 2016
  • June 2016
  • May 2014
  • March 2014
  • September 2013
  • July 2013
  • June 2013
  • May 2013

Categories

  • Apache
  • Command Line (linux/bash)
  • Command Prompt
  • Configurations
  • django
  • Editors
  • Excel
  • Git
  • MySQL
  • PowerShell
  • Python
  • Quick Fixes
  • Shell Related
  • sysadmin
  • ubuntu
  • Uncategorized
  • Utilities
  • Virtualization
  • Windows
  • Wordpress
  • WSL

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Proudly powered by WordPress