Jetserver – The Lazy Admin Blog
Home  /  MySQL  /  Create MySQL database & user from cli

Create MySQL database & user from cli

elialum April 14, 2016 Leave a Comment

The following script creates a MySQL database & a user who will be assigned as a privileged user to the db.

We used the following credentials for this example –

Database name: mysite_db
Database user: mysite_user
Database password: mypassword

## create db & user
mysql -u root -e "create database mysite_db DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;"
mysql -u root -e "grant all privileges on mysite_db.* to mysite_user IDENTIFIED BY 'mypassword' ;"
Tags: MySQL
Previous Article
Next Article

About Author

elialum

Related Posts

  • Automated MySQL Installation

    Automated MySQL Installation

    April 14, 2016

Leave a Reply

Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Search Our Blog

Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages
Filter by Categories
Apache
CentOS
CloudLinux
cPanel
ESXI
iSCSI
JetBackup
Litespeed
MySQL
NGINX
Reduxio
SSL
Uncategorized
VMware
Wordpress
XEN

Tags

apache aspx backup CentOS cloudlinux cPanel CXS freetds google htaccess iscsi JetBackup Libmodsecurity litespeed modsec modsecurity mssql MySQL netapp nginx odbc php php.ini phpselector VMFS WHM xenserver

Popular Posts

  • How To Install & Configure a Galera Cluster with MySQL on Centos 7 February 6, 2018
  • Allow a cPanel server to run a VHOST from multiple IP addresses April 3, 2018
  • Libmodsecurity installation April 14, 2016
  • JetBackup Cheat Sheet :: Automatically Acknowledge Alerts November 15, 2018

Recent Posts

  • Dealing with aggressive bot scanners September 14, 2020
  • Litespeed Geo Location Redirect September 14, 2020
  • JetBackup :: Restore on steroids ! August 21, 2020
  • XENSERVER :: CONNECTING ISCSI SR NETAPP STORAGE September 4, 2019

Recent Comments

  • Khan on Allow a cPanel server to run a VHOST from multiple IP addresses
  • Khan on Allow a cPanel server to run a VHOST from multiple IP addresses
  • Oleg Drabkin on Allow a cPanel server to run a VHOST from multiple IP addresses
  • Khan on Allow a cPanel server to run a VHOST from multiple IP addresses
  • Daniel on How To Install & Configure a Galera Cluster with MySQL on Centos 7
אחסון אתרים | JetApps