How to create new user in mysql using ssh

    To create new user in mysql using ssh connect to mysql with root user then follow the steps
    1. Create new user
    mysql> CREATE USER mohit@localhost IDENTIFIED BY '****';

    2. Grant previleges to newly created user
    mysql> GRANT ALL PRIVILEGES ON *.* TO mohit@localhost
    5
    Average: 5 (1 vote)