Thank you for this. Many other articles I have found did not work properly. Your instructions worked great first time. Not to mention that it actually works how its supposed to. Most of the others sources I have found online did not. I hope you receive blessings for this.
Thank you Will for the positive feedback. Glad to know my video tutorial was helpful to you. Being able to help someone is priceless. I'll keep uploading more useful video tutorials like this. Thanks again for the feedback, I appreciate it 😊🙏
Mr. Nikam - thank you very much - the timing in finding your tutorial on youtube was perfect - the content was perfect - the presentation perfect. I subscribed and appreciate your skills. Thank you again.
Thank you John for the positive feedback and subscribing to my channel. Glad to know the video tutorials was helpful to you. Thanks for the feedback, I appreciate 😊🙏
thats perfect my friend. You are the best... Do you have a video that explain how install and configure a Grafic Interface for using MySql on Ubuntu? Cheers!
Hi Juscelio, Glad to know the tutorial was helpful to you. The MySQL workbench is GUI tool to use MySQL server. You can download it from the following link. dev.mysql.com/downloads/workbench/ On downloads page, For "Select Operating System" option, select "Ubuntu Linux" And for "Select OS Version", select Ubuntu Linux 22.10 (x86, 64-bit). It will show 2 deb packages. Download the one with large file size (62.5M). The installation would be straightforward. Let me know if it helps. Regards, Pradnyankur Nikam
Great! If you are interested in learning SQL, you can check out my 16 hours premium SQL course on Udemy. I'll also keep adding free SQL/MySQL/Database related tutorials here. Thanks for the positive feedback and support, I appreciate it :-)
Howdy. Great instructions, easy to follow thanks a million. Now that i have it installed, how do I go about moving it to my second 1TB hard so that I can store all my databases there? Do you have a video that covers that? My installing nvme ssd is being used for system data only
Hi, I think, you want to move your MySQL data directory to a new location right? I haven't uploaded a video tutorial about it. But you can find a step by step guide at following URL. www.digitalocean.com/community/tutorials/how-to-move-a-mysql-data-directory-to-a-new-location-on-ubuntu-20-04 Let me know if that helps. Regards, Pradnyankur
Hi Yogesh, Yes! First change the password then you can run mysql_secure_installation command to do some security configuration. I already have given it step by step.
hi please before setting de password what did u use as the default password, course i cant hear u clearly it sound like u sad sudo and i have been trying it an it not working
Hi, When after mysql installation, you'll have to do basic security configuration for that you run a command "sudo mysql_secure_installation". But in order to run a sudo command, you'll have to enter super user password of the computer (your computer username password). Later a tried to setup a random password for my MySQL root user account. But the process doesn't work. So, I've given another alternative to login to mysql using "sudo mysql". Then I changed the password of the root user. I hope it's clear. Let me know if you still have any doubts. Regards, Pradnyankur
@@PnTutorialsbyPradnyankurNikam what i mean is after running (sudo mysql) it will ask you to enter a password to open mysql (what is the password you entered?)
Hello sir, when i do sudo mysql_secure_installation. it does not ask me to enter the new password but enter password for user root. so i don't set a password yet. can you help me
Hi, when you run sudo first time in a session, you must enter your operating system root user password. Then you can change mysql root user password. I hope it’s clear.
Hi Vasu, Can you provide more information like which Linux you are using, the command you used to install MySQL and the error message you are getting. So that I can understand your problem and help you fix it.
what solve this command : $ sudo mysql_secure_installation Securing the MySQL server deployment. Enter password for user root: Error: Access denied for user 'root'@'localhost' (using password: YES)
Hi Mohamad, 1) Directly login to your MySQL server using following command, sudo mysql 2) Once you are logged in to your MySQL server, set a new password using following command, ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'newpassword'; (change new password string with your own password) 3) Reset privileges using, FLUSH PRIVILEGES; 4) Exit out of MySQL database server using, 5) Now you can directly login to your MySQL server using, sudo mysql (without password) OR mysql -u root -p (When prompted, enter newly set root user password) Let me know if it works.