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 the database 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 the first time the WinMySQLadmin application 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.
Setting the root user password
The mysqladmin utility, as the name might imply, is used to perform administrative-level tasks on your database. ...
Get PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide 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.
