Hi team,
My requirement is " I should not allow root/users who specify interactive password while login to mysql database in command line" like 'mysql -uroot -pMYpasswordhere' ,this way of entering password on command line leads to security threats .Entered command can be found when we check 'History' & process list so how we can make root/users allow to login only Entering password when prompted ,like 'mysql -uroot -p' after press enter we will get 'Enter password ' pop up at that time if root/users specify password then only allow to login to mysql database if not it should through some warnings or message saying password specification on command line not allowed .
My requirement is " I should not allow root/users who specify interactive password while login to mysql database in command line" like 'mysql -uroot -pMYpasswordhere' ,this way of entering password on command line leads to security threats .Entered command can be found when we check 'History' & process list so how we can make root/users allow to login only Entering password when prompted ,like 'mysql -uroot -p' after press enter we will get 'Enter password ' pop up at that time if root/users specify password then only allow to login to mysql database if not it should through some warnings or message saying password specification on command line not allowed .
