MySQL Permissions
Once MySQL has been successfully installed, you should immediately set a password for the root user. Until you have done so, anyone can access your databases and have administrative-level privileges. Windows users who followed the steps earlier for installing MySQL can skip this step, since the root user was created when the MySQL configuration wizard was run.
Once you’ve established the root user’s password, you can begin establishing the users who will regularly access the database (for example, from PHP scripts). It is very insecure to use the root user for general purposes, so everyone should create some new MySQL users for regular use.
Setting the root user password
The mysqladmin utility, as the name might imply, is ...
Get PHP and MySQL for Dynamic Web Sites: Visual Quickpro Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
