Create database

mysql> CREATE DATABASE databasename;
Query OK, 1 row affected (0,02 sec)

Create user

mysql> CREATE USER 'abadowski'@'localhost' IDENTIFIED BY 'passwordname';
mysql> GRANT ALL PRIVILEGES ON abadowski.* TO 'abadowski'@'localhost'
    -> WITH GRANT OPTION;

Update user

mysql> UPDATE mysql.user SET Password=PASSWORD('newpasswordname') WHERE User='abadowski';
mysql> FLUSH PRIVILEGES;

Delete

mysql> DROP USER 'abadowski'@'localhost';
mysql> DROP DATABASE databasename;

Leave a reply

Your email address will not be published.