Join the community today
Register Now

MariaDB make new user?

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by Oxide, Jun 12, 2015.

  1. Oxide

    Oxide Active Member

    534
    29
    28
    Mar 19, 2015
    Ratings:
    +59
    Local Time:
    1:10 PM
    How can I make a new user that only has access to it's own database?


    I want to make one like root user, just he cant access root database and only hes own with all permissions i guess.. just not access to other than hes own.
     
  2. eva2000

    eva2000 Administrator Staff Member

    55,223
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,831
    Local Time:
    1:10 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    @quicksalad asked the same question at Where to create DB for Xenforo | Centmin Mod Community

    For creating MySQL databases and MySQL username and password you have a few options all outlined via the following linked information (including mysqladmin_shell.sh addon below).
    Note: default /etc/my.cnf sets default storage engine to MyISAM (default-storage-engine = MyISAM). If you want to use InnoDB storage engine tables, set in /etc/my.cnf, default-storage-engine = InnoDB and restart MySQL server.

    Currently, Centmin Mod doesn't bundle any tools to manage MariaDB MySQL by default. You have to do it:
    1. Via SSH telnet command line see MySQL documentation at MySQL :: MySQL 5.5 Reference Manual :: 3 Tutorial, MySQL Access Privilege System andMySQL User Account Management (example shown in Wordpress + WP-FFPC plugin + ngx_pagespeed guide and in IP.Board setup guide) OR
    2. Install phpmyadmin yourself (see more info further below) OR
    3. Install tools such as HeidiSQL on your own pc to connect to your server ?
    Centmin Mod Addons - phpmyadmin.sh & mysqladmin_shell.sh
    Both Addons are in a beta build state, so there's no 100% guarantee it will always work. Your feedback on the forums and testing will help me improve the Addons ;)
     
  3. quicksalad

    quicksalad Member

    228
    13
    18
    May 31, 2015
    Ratings:
    +20
    Local Time:
    8:40 AM
  4. quicksalad

    quicksalad Member

    228
    13
    18
    May 31, 2015
    Ratings:
    +20
    Local Time:
    8:40 AM
    check the basic usage part where you need to create a new db user and set password... go to mysqladmin_shell.sh ..see above link posted.