create mysql user through command line

  1. bhawanisingh

    How to create a MySQL user on CentOS server and Grant permissions to it through command line ?

    To create MySQL user you should have root access for SSH. First of all you have to login to MySQL server through command line. ----- # mysql -u root -p ****** ----- Here, -u option is for username and -p option is for password. Now, you will be at MySQL prompt and it looks like this : ----- #...
Top