Commands used:
sudo apt update
sudo apt-get install mysql server
To check the version:
mysql – -version
To fix access denied for user 'root'@'localhost'
sudo mysql -u root -p
display databases;
use MySQL
update user defined plugin 'mysql_native_password' where user 'root';
dump privileges;
Then finally Type:
mysql -u root -p
To create a database:
create a database demo;
Check all available databases:
display databases;
PayPal: https://paypal.me/codewitharjun
Patreon: https://www.patreon.com/codewitharjun
️ Subscribe: https://www.youtube.com/codewitharjun
Stay connected :
️ LinkedIn: https://np.linkedin.com/in/arjungautam1
️ Github: https://github.com/arjungautam1
Join the community:
️Discord: https://discord.gg/cn2x3jhMW4
Follow me on:
️ Support: https://codewitharjun.medium.com/
️ Dev.to: https://dev.to/codewitharjun
#CodeWithArjun #Programming
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments