CREATE Database/Granting Privileges

CREATE Database/Granting Privileges

CREATE your first database
Code:
[code:1:0668cd8e74]CREATE database myfirstdb;
[/code:1:0668cd8e74]

CREATE a user for your first database

This one creates the user 'sqladmin' and gives them 'usage' on your new database 'myfirstdb'

Code:
[code:1:0668cd8e74]mysql> GRANT usage on myfirstdb.* to sqladmin@localhost;
Query OK, 0 rows affected (0.00 sec)[/code:1:0668cd8e74]


This actually gives them privileges to do SELECT, INSERT and DELETE statements in your database and creates a password for them 'somepassword'

Code:
[code:1:0668cd8e74]mysql> GRANT SELECT, INSERT, DELETE on myfirstdb.* to sqladmin@localhost IDENTIFIED BY 'somepassword';
Query OK, 0 rows affected (0.00 sec)[/code:1:0668cd8e74]



Tags:

database, granting, privilegescreate, myfirstdb, user, creates, sqladmin, usage, mysql, localhost, query, ok, rows, privileges, select, insert, delete, statements, password, somepassword, identified,

Latest Articles

  • Centos 7 how to save iptables rules like Centos 6
  • nfs tuning maximum amount of connections
  • qemu-kvm error "Could not initialize SDL(No available video device) - exiting"
  • Centos 7 tftpd will not work with selinux enabled
  • Debian Ubuntu Mint Howto Create Bridge (br0)
  • How To Control Interface that dhcpd server listens to on Debian based Linux like Mint and Ubuntu
  • LUKS unable to type password to unlock during boot on Debian, Ubuntu and Mint
  • Debian Ubuntu and Linux Mint Broken Kernel After Date - New Extra Module Naming Convention
  • Wordpress overwrites and wipes out custom htaccess rules and changes soluton
  • Apache htaccess and mod_rewrite how to redirect and force all URLs and visitors to the SSL / HTTPS version
  • python 3 pip cannot install mysql module
  • QEMU-KVM won't boot Windows 2016 or 2019 server on an Intel Core i3
  • Virtualbox vbox not starting
  • Bind / named not responding to queries solution
  • Linux Mint How To Set Desktop Background Image From Bash Prompt CLI
  • ImageMagick Convert PDF Not Authorized
  • ImageMagick Converted PDF to JPEG some files have a black background solution
  • Linux Mint Mate Customize the Lock screen messages and hide username and real name
  • Ubuntu/Gnome/Mint/Centos How To Take a partial screenshot
  • ssh how to verify your host key / avoid MIM attacks