How to logon in servermail with usermail ?
In the material
mysqladmin -p create servermail
Log in as MySQL root user
mysql -u root -p
Enter your MySQL root’s password; if it’s successful you will see:
First we need to create a new user, specific for mail authentication, and we are going to give SELECT permission.
mysql > GRANT SELECT ON servermail.* TO ‘usermail’@'127.0.0.1’ IDENTIFIED BY 'mailpassword’;
After that, we need to reload MySQL privileges to ensure it applies those permissions successfully:
mysql > FLUSH PRIVILEGES;
Now we create database 'servermail’ and user 'usermail’ with password 'mailpassword’.
Why can’t login on the database with command:
mysql -u usermail -pmailpassword servermail ?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.