Boot to any [Manjaro] live GUI disk. Use manjaro-chroot 1. Start by identifying the partition where your Manjaro installation controlling the active Grub menu resides and needs repairing. If you are in Graphical mode you can use an application called GPartEd , which should be in Menu > System > GPartEd. This will provide a simple visual illustration of the partitions on your hard drive(s). To do the same thing from terminal or TTY you can use this command lsblk -f 2. manjaro-chroot is a tool to easily setup a functional chroot into an installed Linux installation from a live boot of a Manjaro Installation Media. To setup the chroot use the command sudo manjaro-chroot -a You will be presented with a terminal. Wait until it shows a list with the available system partitions on your computer and choose the one you want to repair. 1.) First of all check the partition for the ESP (EFI System Partition). An ESP is a fat32 partition and contains .efi ...
Update root password;
UPDATE user SET Password=PASSWORD('') WHERE User='root'; FLUSH PRIVILEGES
Create new user;
CREATE USER 'test'@'localhost' IDENTIFIED BY 'password';
Grand all permission to new user;
GRANT ALL PRIVILEGES ON * . * TO 'test'@'localhost';
Create new database;
CREATE DATABASE dbname;
Import database;
mysql -u mysqluser -p < file.sql
Import tables to database;
mysql -u mysqluser -p databasename < file.sql
Export Database to sql file;
mysqldump -h host_name -P port_number -u user_name -p database_name > name_of_backup.sql
Export Table to sql file;
mysqldump -p --user=username dbname tableName > tableName.sql
Drop all tables from a database;
mysql -u uname dbname -e "show tables" | grep -v Tables_in | grep -v "+" | gawk '{print "drop table " $1 ";"}' | mysql -u uname dbname
error solution "error Packets larger than max_allowed_packet are not allowed";
go to my.ini file and change " max_allowed_packet"
UPDATE user SET Password=PASSWORD('') WHERE User='root'; FLUSH PRIVILEGES
Create new user;
CREATE USER 'test'@'localhost' IDENTIFIED BY 'password';
Grand all permission to new user;
GRANT ALL PRIVILEGES ON * . * TO 'test'@'localhost';
Create new database;
CREATE DATABASE dbname;
Import database;
mysql -u mysqluser -p < file.sql
Import tables to database;
mysql -u mysqluser -p databasename < file.sql
Export Database to sql file;
mysqldump -h host_name -P port_number -u user_name -p database_name > name_of_backup.sql
Export Table to sql file;
mysqldump -p --user=username dbname tableName > tableName.sql
Drop all tables from a database;
mysql -u uname dbname -e "show tables" | grep -v Tables_in | grep -v "+" | gawk '{print "drop table " $1 ";"}' | mysql -u uname dbname
error solution "error Packets larger than max_allowed_packet are not allowed";
go to my.ini file and change " max_allowed_packet"
Comments
Post a Comment