• MySQL tips
• Create new user
• Change password of a user
• Author

MySQL tips

Here are some tricks and tips about MySQL database manager.

Create new user

        mysql> grant select, insert, update, delete, create, drop on <DBNAME>.*
                to <USER>@localhost identified by "<PASSWORD>";

Change password of a user

        mysql> set password for root = password('<PASSWORD>');

verify

        mysql> select Host, User, password FROM mysql.user;

Author

Luis Alfonso Vega Garcia <[email protected]>