Most systems store them in /var/lib/mysql/, /var/run/mysqld/, or / usr/local/mysql/data/ path. Otherwise, the system may create files owned by the root user, which can cause problems. Although you can log in as root, once you start the MySQL server, make sure you start it with the -user=mysql option. When you boot into your Linux installation, make sure you’re logged in as the same user that normally runs MySQL.
How to Change MySQL User Root Password in Linux Step 1: Log in as the MySQL User Notepad is included by default in Window.
Administrator privileges on the computer that hosts the MySQL database.Access to a Linux or Windows server running MySQL.If your database has a root password, but you lost track of it, this guide will help you reset a MySQL Root password on Linux and Windows. However, this is not a good security practice as anyone can access your database. If you’ve never set a root password on your MySQL database, you should be able to connect to it. The root password allows a user to perform all top-level functions in the database. Like many web services, MySQL has an administrator-level or root password. MySQL is a popular database management system for web application software.
