Create MySql database and user - command line
The MySql server is a commonly used database server in web applications. To manage database and content, we have too many GUI tools like
But it is essential to familiarize basic commands to manage a MySql server via command line.
Login to mysql as root user.
mysql -u root -p
it will ask for mysql root password
If you entered correct password, you should now be at a MySQL prompt that looks very similar to this:
Then create our database.
CREATE DATABASE IF NOT EXISTS sample_database;
To view the database you’ve created, use the following command.
Your result should be similar to this:
mysql> SHOW DATABASES;
+--------------------+ | Database | +--------------------+ | information_schema | | mysql | | test | | sample_database | +--------------------+ 4 rows in set (0.00 sec)
Create new user with password
CREATE USER 'db_user'@'localhost' IDENTIFIED BY 'my_password';
Grand permission to new user on new database.
GRANT ALL PRIVILEGES ON sample_database.* TO 'db_user'@'localhost' IDENTIFIED BY 'my_password';
Once you have finalized the permissions that you want to set up for your new users, always be sure to reload all the privileges.
- Remove edit, view, trash and quick edit links within posts list of admin screen - WordPress
- PHP Errors not displaying or not logging - LAMP server - Solved
- Display all hooks sequentialy that run on a page - WordPress
- Get downloadable files of a downloadable product - WooCoomerce
- Add actions based on WooCoomerce order status
Your Questions / Comments
If you found this article interesting, found errors, or just want to discuss about them, please get in touch.