sudo service mysql stop sudo /opt/lampp/lampp restart
Here is what the above code is Doing:
1. We are creating a new user called ‘mynewuser’ and setting a password for the user.
2. We are granting ALL privileges to the user on the database called ‘mydatabase’.
3. We are flushing the privileges so that the current instance of MySQL knows about the recent privilege changes we have made.
4. We are stopping the MySQL service.
5. We are restarting the MySQL service.