Create database from terminal mysql
create database from terminal mysql
1 2 3 | DATE=`date +%Y_%m_%d`
mysql -u root -p -e "drop database DATABASE_NAME;create database DATABASE_NAME;"
mysql -u root -p DATABASE_NAME < PATH_TO_MYSQL_DUMP_FILE.sql
|
Explore mysql server code snippets and tutorials
create database from terminal mysql
1 2 3 | DATE=`date +%Y_%m_%d`
mysql -u root -p -e "drop database DATABASE_NAME;create database DATABASE_NAME;"
mysql -u root -p DATABASE_NAME < PATH_TO_MYSQL_DUMP_FILE.sql
|
Reset mysql root password
1 2 3 4 5 6 7 8 | use mysql;
SET PASSWORD FOR 'root'@'localhost' = PASSWORD("pass");
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Current-Root-Password';
FLUSH PRIVILEGES;
quit;
service mysql restart
mysql -u root -p
|