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

  • Enable AMDGPU Linux Driver
  • apache symlinks denied even with followsymlinks
  • chown how to change ownership on a symlink
  • how to use ifplugd in Linux to execute a command or script when a NIC cable is unplugged or plugged in
  • dd how to backup and restore disk images including compression with gzip
  • mpv / mplayer with Radeon / AMD GPU Video Card Driver enable VDPAU GPU Accelerated Video Decoding
  • Wordpress Reset Blog User Password from MySQL Using Linux Bash and not PHPMyadmin
  • Ubuntu Linux Mint Debian xorg performance and tear-free tuning for AMD Radeon Based Cards
  • Centos 7 Stopped and Disabled Firewalld and ports still blocked
  • MariaDB / MySQL Reset Root Forgotten Password on Centos 7
  • Centos 7 How to install Mysql/Mariadb
  • PHP 7.2, Apache and Centos 7 How To Install
  • Ubuntu Debian Linux Mint r8169 r8168 Network Driver Problem and Solution
  • Linux 3D Performance benchmarks with glxgears 59-60fps solution
  • How To Install Asterisk 16 17 on Debian Ubuntu Linux
  • Linux Ubuntu Debian Centos How To Make a Bootable Windows 7, 8, 10, 2016, 2019 Server USB from ISO
  • How To Restore Windows MBR Bootsector from Linux using syslinux
  • Linux Ubuntu Cannot Print Large Images
  • Cannot Print PDF Solution and Howto Resize
  • Linux Console Login Screen TTY Change Message