MYSQL IDE install and connect

sudo apt install curl

curl -fsSL https://lnkd.in/gTPvwfTG | sudo gpg --dearmor --output /usr/share/keyrings/beekeeper.gpg && sudo chmod go+r /usr/share/keyrings/beekeeper.gpg && echo "deb [signed-by=/usr/share/keyrings/beekeeper.gpg] https://lnkd.in/gRJf9qRn stable main" | sudo tee /etc/apt/sources.list.d/beekeeper-studio-app.list > /dev/null

sudo apt update && sudo apt install beekeeper-studio -y



sudo mysql -u root -p


~ MariaDB [(none)]> DROP USER 'root'@'localhost';
~ MariaDB [(none)]> CREATE USER 'root'@'localhost' IDENTIFIED BY 'password';
~ MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
~ MariaDB [(none)]> FLUSH PRIVILEGES;