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

  • Linux Ubuntu Cannot Print Large Images
  • Cannot Print PDF Solution and Howto Resize
  • Linux Console Login Screen TTY Change Message
  • Apache Cannot Start Listening Already on 0.0.0.0
  • MySQL Bash Query to pipe input directly without using heredoc trick
  • CentOS 6 and 7 / RHEL Persistent DHCP Solution
  • Debian Ubuntu Mint rc-local service startup error solution rc-local.service: Failed at step EXEC spawning /etc/rc.local: Exec format error
  • MySQL Cheatsheet Guide and Tutorial
  • bash script kill whois or other command that is running for too long
  • Linux tftp listens on all interfaces and IPs by DEFAULT Security Risk Hole Solution
  • python import docx error
  • Cisco Unified Communications Manager Express Cheatsheet CUCME CME
  • Linux Ubuntu Debian Missing privilege separation directory: /var/run/sshd
  • bash how to count the number of columns or words in a line
  • bash if statement how to test program output without assigning to variable
  • RTNETLINK answers: Network is unreachable
  • 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