Want more timely Centmin Mod News Updates?
Become a Member

MariaDB make new user?

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

  1. Oxide

    Oxide Active Member

    505
    29
    28
    Mar 19, 2015
    Ratings:
    +54
    Local Time:
    8:21 AM
    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

    30,968
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,422
    Local Time:
    8:21 AM
    Nginx 1.13.x
    MariaDB 5.5
    @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

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    3:51 AM
  4. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    3:51 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.
     
    • Like Like x 1