Open C:\xampp\mysql\bin\my.ini (MySQL config file)
Find the line [mysqld] and right below it add skip-grant-tables. Example:
# The MySQL server
[mysqld]
skip-grant-tables
port= 3306
socket = "C:/xampp/mysql/mysql.sock"
| const helpers = { | |
| //Check if string is not empty | |
| isRealString: (string) => { | |
| return typeof string === "string" && string.trim().length > 0; | |
| }, | |
| //Check if email is valid | |
| isEmail: (email) => { | |
| const regEx = | |
| /^(([^<>()\[\]\\.,;:\s@"]+(\.[^<>()\[\]\\.,;:\s@"]+)*)|(".+"))@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\])|(([a-zA-Z\-0-9]+\.)+[a-zA-Z]{2,}))$/; |
Open C:\xampp\mysql\bin\my.ini (MySQL config file)
Find the line [mysqld] and right below it add skip-grant-tables. Example:
# The MySQL server
[mysqld]
skip-grant-tables
port= 3306
socket = "C:/xampp/mysql/mysql.sock"
| { | |
| "fas fa-address-book","fas fa-address-card","fas fa-adjust","fas fa-align-center","fas fa-align-justify","fas fa-align-left","fas fa-align-right","fas fa-allergies","fas fa-ambulance","fas fa-american-sign-language-interpreting","fas fa-anchor","fas fa-angle-double-down","fas fa-angle-double-left","fas fa-angle-double-right","fas fa-angle-double-up","fas fa-angle-down","fas fa-angle-left","fas fa-angle-right","fas fa-angle-up","fas fa-archive","fas fa-arrow-alt-circle-down","fas fa-arrow-alt-circle-left","fas fa-arrow-alt-circle-right","fas fa-arrow-alt-circle-up","fas fa-arrow-circle-down","fas fa-arrow-circle-left","fas fa-arrow-circle-right","fas fa-arrow-circle-up","fas fa-arrow-down","fas fa-arrow-left","fas fa-arrow-right","fas fa-arrow-up","fas fa-arrows-alt","fas fa-arrows-alt-h","fas fa-arrows-alt-v","fas fa-assistive-listening-systems","fas fa-asterisk","fas fa-at","fas fa-audio-description","fas fa-backward","fas fa-balance-scale","fas fa-ban","fas fa-band-aid","fas fa-barcode","fas fa-bars", |
| {"name":"Font Awesome v5.0.1", "icons":[ | |
| "fab fa-500px", | |
| "fab fa-accessible-icon", | |
| "fab fa-accusoft", | |
| "fas fa-address-book", "far fa-address-book", | |
| "fas fa-address-card", "far fa-address-card", | |
| "fas fa-adjust", | |
| "fab fa-adn", | |
| "fab fa-adversal", | |
| "fab fa-affiliatetheme", |
If you're storing anything in MySQL databases that you do not want to lose, it is very important to make regular backups of your data to protect it from loss. This tutorial will show you two easy ways to backup and restore the data in your MySQL database. You can also use this process to move your data to a new web server.
Back up From the Command Line (using mysqldump)
Back up your MySQL Database with Compress
Restoring your MySQL Database
Backing Up and Restoring using PHPMyAdmin
| # ----------------------------------------------------------------- | |
| # .gitignore | |
| # Bare Minimum Git | |
| # http://ironco.de/bare-minimum-git/ | |
| # ver 20181206 | |
| # | |
| # From the root of your project run | |
| # curl -O https://gist.github.com/salcode/10017553/raw/.gitignore | |
| # to download this file | |
| # |
| // ------------------------------------------------------------------------ | |
| if (!function_exists('print_arrays')) | |
| { | |
| /** | |
| * print_arrays() function is to print args in | |
| * var_dump or print_r to debug. | |
| */ | |
| function print_arrays() |
| <?php | |
| if (!function_exists('array_group_by')) { | |
| /** | |
| * Groups an array by a given key. | |
| * | |
| * Groups an array into arrays by a given key, or set of keys, shared between all array members. | |
| * | |
| * Based on {@author Jake Zatecky}'s {@link https://github.com/jakezatecky/array_group_by array_group_by()} function. | |
| * This variant allows $key to be closures. |
| -- phpMyAdmin SQL Dump | |
| -- version 4.5.5 | |
| -- http://www.phpmyadmin.net | |
| -- | |
| -- Anamakine: localhost:3306 | |
| -- Üretim Zamanı: 25 Mar 2016, 02:50:13 | |
| -- Sunucu sürümü: 5.5.47-cll-lve | |
| -- PHP Sürümü: 5.6.14 | |
| SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; |