Setting Up MySQL - Database, Users And Sample Table
Oct 20, 2008, 22:02 (0 Talkback[s])
(Other stories by Sudheer)
WEBINAR: On-demand webcast
How to Boost Database Development Productivity on Linux, Docker, and Kubernetes with Microsoft SQL Server 2017 REGISTER >
"Changing root password: As soon as the MySQL server is
installed, root user with blank password is created. The MySQL root
user will have full access to perform any operation on the MySQL
server. It is a good practice to change the root password
immediately after installation.
"It is also worth mentioning that MySQL users are different from
system users. If you try to connect to the MySQL server as root
using your system root password, it will not work. MySQL server
maintains its own users in the 'user' table of 'mysql'