Create database & user grant permissions

  • administrators

    Once mysql / mariadb is installed:

    mysql -u root -p

    Where -u = User

    Where -p = Password

    Create a database: Note, set characture set at the same time

    Where :undefined:‘:undefined:application_data:undefined:’:undefined: = the database name Change this for your specific requirements

    CREATE DATABASE application_data CHARACTER SET utf8 COLLATE utf8_general_ci;

    Create User:

    Where :undefined:‘:undefined:application_user:undefined:’:undefined: = database user, change this to whatever user you wish

    Where :undefined:‘:undefined:PASSWORD:undefined:’:undefined: = Your private application password

    CREATE USER 'application_user'@'localhost' IDENTIFIED BY 'PASSWORD';

    Give user privileges on database / there are many different reasons to learn what privileges to allow what user!

    GRANT ALL PRIVILEGES ON application_data.* TO 'application_user'@'localhost';

    Then always:




  • Make ISO from DVD

    In this case I had an OS install disk which was required to be on a virtual node with no optical drive, so I needed to transfer an image to the server to create a VM

    Find out which device the DVD is:



    NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT sda 8:0 0 465.8G 0 disk ├─sda1 8:1 0 1G 0 part /boot └─sda2 8:2 0 464.8G 0 part ├─centos-root 253:0 0 50G 0 lvm / ├─centos-swap 253:1 0 11.8G 0 lvm [SWAP] └─centos-home 253:2 0 403G 0 lvm /home sdb 8:16 1 14.5G 0 disk /mnt sr0 11:0 1 4.1G 0 rom /run/media/rick/CCSA_X64FRE_EN-US_DV5

    Therefore /dev/sr0 is the location , or disk to be made into an ISO

    I prefer simplicity, and sometimes deal with the fallout after the fact, however Ive repeated this countless times with success.

    dd if=/dev/sr0 of=win10.iso

    Where if=Input file and of=output file

    I chill out and do something else while the image is being copied/created, and the final output:

    8555456+0 records in 8555456+0 records out 4380393472 bytes (4.4 GB) copied, 331.937 s, 13.2 MB/s


    read more
  • Recreate postrgresql database template encode to ASCII

    UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1';

    Now we can drop it:

    DROP DATABASE template1;

    Create database from template0, with a new default encoding:

    CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UNICODE'; UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1'; \c template1 VACUUM FREEZE;

    read more