INSTALL-CONFOG-MYSQL.md

Install MySql in Ubuntu

sudo apt install mysql-server
systemctl start mysql

Config Mysql Root user:

1. Log in to MySQL as the root user using sudo:

   sudo mysql -u root

2. At the MySQL prompt, switch to the mysql database:

   USE mysql;

3. Alter the root user's authentication method to use mysql_native_password and set a password:

   ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

   Replace 'password' with your desired password.

4. Flush privileges to apply the changes:

   FLUSH PRIVILEGES;

5. Exit the MySQL prompt:

   exit;

Now, you should be able to log in to MySQL as the root user without using sudo:

mysql -u root -p

Uninstall Mysql

sudo service mysql stop
sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean
sudo rm -rf /var/lib/mysql/
sudo rm -rf /etc/mysql/

If in case you got this error in trying to login:

sudo systemctl stop mysql.service

sudo mkdir -p /var/run/mysqld
sudo chown mysql:mysql /var/run/mysqld


sudo mysqld_safe --skip-grant-tables --skip-networking &
sudo mysql -u root

updating password ERROR 1045(28000): Access denied for user 'root'@'localhost' (using passowrd: YES)

FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
exit;

sudo pkill mysqld_safe
mysql -u root -p