MySQL Command Lines
CREATE USER 'abc'@'localhost' IDENTIFIED BY '1abc';
GRANT ALL PRIVILEGES ON abc . * TO 'abc'@'localhost';
FLUSH PRIVILEGES;
To Run BackUp From Command Line
mysql -u root -p password abc_database > abc.sql
To Run Import From Command Line
mysql -u root -p password abc_database < abc.sql
MAC MySQL Location for XAMPP
/Applications/XAMPP/xamppfiles/bin/mysql xxxx
GRANT ALL PRIVILEGES ON abc . * TO 'abc'@'localhost';
FLUSH PRIVILEGES;
To Run BackUp From Command Line
mysql -u root -p password abc_database > abc.sql
To Run Import From Command Line
mysql -u root -p password abc_database < abc.sql
MAC MySQL Location for XAMPP
/Applications/XAMPP/xamppfiles/bin/mysql xxxx
Comments
Post a Comment