MariaDB New user

amin · Oct 11, 2014

Hi,
How can I create new database and create/assign user/pass to it?

Thank you

eva2000 · Oct 11, 2014

@amin

straight from official site MySQL MariaDB performance drop in replacement on Centmin Mod - Menu based Nginx installer for CentOS servers

Managing MySQL Databases and Users
Currently, Centmin Mod doesn't bundle any tools to manage MariaDB MySQL. You have to do it:

Via SSH telnet command line see MySQL documentation atMySQL :: MySQL 5.5 Reference Manual :: 3 Tutorial, MySQL Access Privilege System and MySQL User Account Management (example shown in Wordpress + WP-FFPC plugin + ngx_pagespeed guide) OR

Install phpmyadmin yourself OR

Install tools such as HeidiSQL on your own pc to connect to your server ?

Click to expand...

straight from Getting Started Guide tip 11

1. MySQL database management
Currently, Centmin Mod doesn't bundle any tools to manage MariaDB MySQL by default. You have to do it:

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

Install phpmyadmin yourself (see more info further below) OR

Install tools such as HeidiSQL on your own pc to connect to your server ?

Centmin Mod Addons - phpmyadmin.sh & mysqladmin_shell.sh

If you need to create MySQL databases, there's a custom Centmin Mod Addon for installing phpmyadmin

There's also another Addon I wrote called mysqladmin_shell.sh which can be run from SSH command line instead.

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
Click to expand...

eva2000 · Oct 11, 2014

BTW, Getting Started Guide is a must read Getting Started with Centmin Mod

amin · Oct 11, 2014

Yh, tried them couple of weeks ego, but I could not install the Php myadmin.Tried Heidisql too, there was an error, cant remember the number, but seems it does not allow external ip.

eva2000 · Oct 11, 2014

phpmyadmin should work fine.. but you can try mysqladmin_shell.sh Shell based Addon | Centmin Mod Community via SSH command line too

Log in / Register

Forums

Join the community today

MariaDB New user

amin Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

amin Member

eva2000 Administrator Staff Member

.

Log in / Register

Useful Searches

Join the community today

MariaDB New user

amin Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

amin Member

eva2000 Administrator Staff Member

.