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

  • Huion and Wacom Tablets How To Install in Linux Mint / Ubuntu and make the stylus work properly
  • ffmpeg how to cut certain parts of video out
  • ffmpeg how to concat and join two video clips
  • mencoder instead of ffmpeg to join or concatenate video files with different audio streams
  • Linux How To Stop Missing Drive from Halting Boot Process in fstab
  • How To Replace Audio Track of Video using ffmpeg
  • qemu-img convert formats vdi vmdk raw qcow2
  • Linux and Windows Dual Boot Crazy Time Issues
  • dynagen / dynamips 100% high CPU usage solution - how to set the idlepc value
  • How To Setup a Cisco CME (Cisco Manager Express) Virtual Router under Linux using dynamips and dynagen
  • Linux Mint Ubuntu Debian CentOS Dual Boot Install Issues
  • Linux Mint Ubuntu Debian Centos RHEL no sound solution
  • Linux Mint/Debian/Ubuntu/Centos Installer black grub screen and blank screen after trying to boot installer or main OS
  • Linux Mint Dual Boot Install Avoid Wiping our your Main C: drive /dev/sda MBR and EFI
  • QEMU-KVM soundhw deprecated how to enable sound in QEMU 4.x series
  • Virtualbox Error Cannot register the hard disk because a hard disk with UUID already exists solution
  • kernel: [549267.368859] mate-terminal[7871]: segfault at 2000000101 ip 00007f5d0a9548f0 sp 00007fff7012c610 error 4 in libgobject-2.0.so.0.4800.2[7f5d0a920000+52000]
  • apcupsd how to setup and monitor APC UPS units
  • How To Password Reset, Recover, Bypass, Remove and Unlock on Windows 10,8,7,Vista,XP,NT,2000,2003,2008,2012,2016,2019 Administrative Login Programs
  • Nvidia Ubuntu Linux Screentearing Video with solution driver