Coolest Guides on the Planet

coolest guides on the planet

Coolest Guides On The Planet

  • Home
  • macOS
  • WebDev
  • All Posts
  • Contact

How to Change the MySQL root Password in Linux or macOS via Command Line

September 20, 2016 53 Comments

change-mysql-password-command-line

If you have forgot the MySQL root password, can’t remember or want to break in….. you can reset the mysql database password from the command line in either Linux or macOS Sierra and OSX as long as you know the root user password of the box you are on, this is for MySQL 5.7 onwards: Stop …
Read More

Cats: Database, Open Source Tags: mysql, root

Migrate WordPress Site from Local Development to Live Server and fix serialized data issues

July 23, 2014 Leave a Comment

migrate wordpress site

There are a number of ways to migrate a local development WordPress site from a test to a live server, you can to this manually or via a plugin. Migrating WordPress Manually The manual way to migrate a WordPress site to a live server is in a few steps: Copy the all the contents of …
Read More

Cats: Database, Tech, WordPress

Import / Export a mysql database on the command line

April 18, 2014 1 Comment

To export a mysql database (as a dump) from the command line run: mysqldump database_name > database_exportname.sql To import a mysql database dump into a database: mysql database_name < database_exportname.sql To export all databases into a dump: mysqldump –all-databases > all_databases_export.sql To import one of these mysql databases from the dump into a database: mysql –one-database database_name < all_databases_export.sql

Cats: Database, WebDev Tags: mysql

Find out how many database queries per pageload in WordPress

April 12, 2014 Leave a Comment

To find out how many WordPress mysql database queries a page requests and how long it takes the page to load whilst querying the database, you can add in a PHP function to a WordPress hook to find out. This can be displayed in either the source code of the html or rendered on the …
Read More

Cats: Database, WebDev, WordPress Tags: mysql

Tags

3gs 10.6 apache backup baseband boot clean urls cpanel css curl custom database drupal el capitan git Google image instadmg ios iphone jailbreak keys lion mac macos mojave macos sierra menu mysql OSX panda php phpmyadmin private public redirect redsn0w remote rsa SEO shell ssh terminal unstoppables upgrade urls

Donate a Beer to the Coolest Guides

Get Beaver Builder Now!

Copyright © 2023· Neil Gee - All Rights Reserved - Hosted by Runcloud

Copyright © 2023 · gee on Genesis Framework · WordPress · Log in